Thanks Fred.
From: Fred Taylor
To: ProFox Email List
Sent: Monday, January 23, 2012 8:15 PM
Subject: Re: Foxpro and Excel question
You need to set the VerticalAlignment for all cells or even columns to be:
#DEFINE xlTop -4160
.VerticalAlignment = xlTop
You need to set the VerticalAlignment for all cells or even columns to be:
#DEFINE xlTop -4160
.VerticalAlignment = xlTop
Fred
On Mon, Jan 23, 2012 at 6:06 PM, Michael Madigan wrote:
> I got this code from the internet to extract memo fields from foxpro into
> excel
> cTabla = GETFILE("dbf"
I got this code from the internet to extract memo fields from foxpro into excel
cTabla = GETFILE("dbf")
oExcel = Createobject("Excel.Application")
oExcel.WorkBooks.Add
sele &cTabla
Set Talk Off
nNumRegExp = Reccount() && Total records
For i = 1 To nNumRegExp
WAIT WINDOW "Exporting data:
> Andy Kramek gave a talk on this at one of the Prague DevCons...
>
> Andy Davies
Good to hear from you. I hope all's well.
-Jerry
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free versio
Exactly.
On 23 January 2012 12:07, Dan Covill wrote:
> On 01/23/12 06:50, Sytze de Boer wrote:
>> It gives me the 1 record I want
>> BUT
>> I also need to combine the memodetails into this same single record Can this
>> be done ?
>
> There's no way VFP can automatically concatenate those mem
On 01/23/12 06:50, Sytze de Boer wrote:
> It gives me the 1 record I want
> BUT
> I also need to combine the memodetails into this same single record Can this
> be done ?
There's no way VFP can automatically concatenate those memo fields for
you (much less do anything with a Blob field).
I'd su
In theory, you could use a select to create the memodetails column in your
newtable. Something like:
select client,sum(invvalue) as invttl, desc, ordnum, (select memodetails from
mytable where ...) as memodetails
from mytable
into table newtable
group by client, ordnum
But you don't have a f
Thanks.
To paraphrase, "The definition of insanity is when you ask the same
question over and over again expecting a different answer."
James E Harvey
Corresponding Officer/M.I.S.
Hanover Shoe Farms, Inc.
www.hanoverpa.com
office: 717-637-8931
cell: 717-887-2565
fax: 717-637-6766
-Origina
Thanks Michael, I think I'll try the ShellExecute method as it seems more
flexible.
John
John Weller
01380 723235
07976 393631
> -Original Message-
> From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
On Behalf
> Of Michael Madigan
> Sent: 23 January 2012 11:33
>
an alternate way, but not as elegant is
RUN /n "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe" c:\pdffile.pdf
But this requires you to know the exact location of the acrobat reader.
From: John Weller
To: profox@leafe.com
Sent: Monday, January 23, 20
Staten Island? LOL
From: Pete Theisen
To: ProFox Email List
Sent: Monday, January 23, 2012 5:03 AM
Subject: [OT] Doesn't surprise me
Hi Everybody,
http://www.huffingtonpost.com/2012/01/20/sensitive-men-cities-chemistrycom_n_1214413.html#s617817&title=6_Sar
Thank you Andrew - that's brilliant!!
John Weller
01380 723235
07976 393631
> -Original Message-
> From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
On Behalf
> Of Andrew Stirling
> Sent: 23 January 2012 10:04
> To: profoxt...@leafe.com
> Subject: Re: User Manual
On Sun, Jan 22, 2012, at 11:47 AM, Christof Wollenhaupt wrote:
> >
>
> I wish that customers would always have fully patched operating systems.
> Reality, though, is that customers run old versions of Windows 7 Home
> with
> Windows 98 machines
/faints/
--
Alan Bourke
alanpbourke (at) fas
oops! the url should be
http://www.ml-consult.co.uk/foxst-26.htm
Kind regards
Andrew Stirling
01250 874580
supp...@calcpay.co.uk
http://www.calcpay.co.uk
HMRC Accredited UK payroll program
On 23/01/2012 10:00, Andrew Stirling wrote:
> Hi John
> Use ShellExecute
> this will open the pdf in the cl
Hi Everybody,
http://www.huffingtonpost.com/2012/01/20/sensitive-men-cities-chemistrycom_n_1214413.html#s617817&title=6_Sarasota_Fla
--
Regards,
Pete
http://pete-theisen.com/
http://elect-pete-theisen.com/
___
Post Messages to: ProFox@leafe.com
Subscr
Hi John
Use ShellExecute
this will open the pdf in the clients default pdf reader
* set declaration re Introducing ShellExecute()
* http://www.ml-consult.demon.co.uk/foxst-26.htm
DECLARE INTEGER ShellExecute IN shell32.dll ;
INTEGER hndWin, ;
STRING cAction, ;
STRING cFileName, ;
I want to include an option in the menu bar to open the user manual in a
separate window as a PDF - what do I do? I have the manual as a PDF.
TIA
John Weller
01380 723235
07976 393631
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
Jean Laeremans wrote:
> On Mon, Jan 23, 2012 at 9:45 AM, Pete Theisen wrote:
>
>> We are getting more and more home invasions here. The crooks break in
>> while you are there and demand money, drugs, sex . . .
>
> Sex Pete ? They really must be desperate..hold on to your gun !
Hi Jean,
About 2
On Mon, Jan 23, 2012 at 9:45 AM, Pete Theisen wrote:
> We are getting more and more home invasions here. The crooks break in
> while you are there and demand money, drugs, sex . . .
Sex Pete ? They really must be desperate..hold on to your gun !
A+
jml
_
Paul Hill wrote:
> On Mon, Jan 23, 2012 at 1:45 AM, Pete Theisen wrote:
>>> Typical drivel from Pete. What a change. Have fun shooting your
>>> neighbours.
>> Drivel? Lots of luck tackling the gun-toting criminal in your living
>> room, then. He is *allowed* to have a gun while you are not.
>
This isn't Europe. Here the government hands out guns to Mexican drug lords
From: Paul Hill
To: ProFox Email List
Sent: Monday, January 23, 2012 2:51 AM
Subject: Re: [OT] Reading from the Satanic Verses in Jaipur
On Mon, Jan 23, 2012 at 1:45 AM, Pete Theise
21 matches
Mail list logo
