Recent content by MrFancyteeth

just been browsing the FAQ's & noticed this.. faq796-3853 in the FAQ section might be what you need. mrF

definately go with Darrels suggestion 2 tables: 1 with just the donors & a unique ID , then a donation amount table which contains the donors ID linked to their amounts, then you can filter & sql select away to your heart's content where donor.ID=donation.ID

sorry to ask what may be the obvious - but have you added it as the form icon? mrF

RGBean- thanks too good to know that my help isn't corrupt. mrF

Mike thanks - I was just wondering why intellisense was showing the parameter options for set("path") when there are non I tried it with set("alternate") (which is in the help) which has no parameters and intellisense still showing parameters. I guess i was expecting intellisense to be a...

OlafDoscke - that's exactly what i meant - THERE IS NO HELP for set("PATH") ( PATH under the set() function help) ramani - thanks but I can see all that in the help - just that the path explaination is missing - my VFP8 help just goes from notify to printer - missing out path (& the parameters)...

I'm using Visfox 8 & can't find this in the help file - it goes from SET("NOTIFY") to SET("PRINTER") With intellisense i get can pass the parameters 1, 2 & 3 but what do they mean? They all seem to return the same path - even when my SET PATH TO command has multiple paths. Any Ideas? MrF

Normally in my main.prg lcDefpath = CHR(34)+SYS(5)+SYS(2003)+CHR(34) SET DEFAULT TO &lcdefpath then maybe pass it to a form & make a form property out of it. the chr(34) bits are to handle paths with spaces. It just sets the defa path to the directory the exe runs from mrF

Try Shell execute (courtesy of Mike lewis http://www.ml-consult.demon.co.uk/foxst-26.htm) this will open the file c:\mypic.jpg in Internet exporer DECLARE INTEGER ShellExecute IN shell32.dll ; INTEGER hndWin, ; STRING cAction, ; STRING cFileName, ; STRING cParams, ; STRING...

ha! got it - trial & error though TO PRINTER PROMPT PREVIEW NOCONSOLE mrF

Morning, This compiles fine in VFP8 REPORT FORM swgdelnt.frx PREVIEW TO PRINTER PROMPT NOCONSOLE but errors when i recompile in VFP6 (from error err file) Error in line 38: Missing comma (,) any ideas of the correct order? MrF

FIXED!! it wasn't a macro substition error - i'd already calced the max length of the field. The error was because i was trying to textwidth() a numeric value (the result of the previously created textwidth)! amazing what a beer At lunchtime & getting away from work for a bit can do. - if ur...

thanks but adding "=" to the cexp didn't work cexp="thisform.grid1.column" + ALLTRIM(STR(x))+".width=" then &cexp thisform.TextWidth(arrlen(1,1)) still causes the "not a character expression error" bTW - my logic goes something like get all fieldnames,types from a cursor which is a grid...

morning I'm trying to resize grid columns based on data that the cursor contains step 1 is an Afields() AFIELDS(arrfld,"curgrid") FOR x=1 TO ALEN(arrfld,1) cFld=arrfld(x,1) IF arrfld(x,2)="C" && only for char fields thisform.sizemycolumns(cfld,x) endif endfor step 2 is the...

Try this in the project open up the menu you are using in menu designer from the main foxpro menu choose VIEW select General options (NOT menu options - strangely) click the checkbox for TOP LEVEL FORM click the OK button then re-generate the menu mrF