Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MrFancyteeth

    Unable to connect to any secured access database

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

    Best way to link two tables with unusual layouts?

    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
  3. MrFancyteeth

    icon added but not visible

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

    SET("PATH")

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

    SET("PATH")

    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...
  6. MrFancyteeth

    SET("PATH")

    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)...
  7. MrFancyteeth

    SET("PATH")

    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
  8. MrFancyteeth

    Whats the best way to point to the default directory?

    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
  9. MrFancyteeth

    view a .jpg via Internet Explorer

    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...
  10. MrFancyteeth

    Report form - VFP8 good - VFP6 errors

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

    Report form - VFP8 good - VFP6 errors

    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
  12. MrFancyteeth

    "Not a charcter exp" error - macro subst

    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...
  13. MrFancyteeth

    "Not a charcter exp" error - macro subst

    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...
  14. MrFancyteeth

    "Not a charcter exp" error - macro subst

    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...
  15. MrFancyteeth

    Can someone help me with a main pro

    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
  16. MrFancyteeth

    any idea on creating a document retrieval system?

    Uploading procedure: if you want to convert word to pdf etc you can use a pdf printdriver (free GO2PDF download at http://www.go2pdf.com/go2pdf.exe ) - as i said before you could save the path to this pdf in a table or store the entire document in a binary memo field. the process would be some...
  17. MrFancyteeth

    any idea on creating a document retrieval system?

    you could, i guess, store the paths+filenames to the docs in a table (using ChrisRChamberlin's recursive search method) then display the contents in a grid on a form. Then when user selects a document from the grid, use Shell execute to 'run'/open the document with their default application...
  18. MrFancyteeth

    can't see form

    My startup program would look something like.. ************* * Main.prg * ************* CLEAR ALL SET ESCAPE OFF SET CPDIALOG OFF SET RESOURCE off SET DATE DMY SET CENTURY on Application.visible = .f. DO FORM "frmForm" naME frmForm Read Events ******************** mrF
  19. MrFancyteeth

    can't see form

    have you got a READ EVENTS in your program that launches the form? mrF
  20. MrFancyteeth

    can't see form

    open up the form (scx) and change the form property from the properties window. It's probably set to default - 0 (as in the form only appears in the Visfox screen) mrf

Part and Inventory Search

Back
Top