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: *

  • Users: DHart
  • Order by date
  1. DHart

    Copy Data from VFP to a worksheet in an EXCEL workbook

    Thanks!!! Thanks,Bill - Your code got me started on the right track! Thanks, JRB-Bldr - I found information that I have used to enhance the flexibility and correct an error. I feel that I am a better programmer because of your willingness to help.
  2. DHart

    Copy Data from VFP to a worksheet in an EXCEL workbook

    Background Info: The program extracts data from a database for reporting on several criteria. The tables are then copied to EXCEL files. I have an EXCEL workbook that contains graphs with links to these created worksheets. Since the files with the data need to be opened before the graph...
  3. DHart

    remote View -- Can you pass a variable from the screen that calls the

    ramani, Thanks!! Your suggested code change works when I run the view from inside Visual Fox. I changed my code to: SELECT * FROM {oj PMPPD Pmppd LEFT OUTER JOIN PMDBFA.PMPPR Pmppr ; ON Pmppd.PDSEQ = Pmppr.PRSEQ }; WHERE Pmppr.PRPOID = Pmppd.PDPOID; AND (Pmppd.PDCO = ' 2'...
  4. DHart

    remote View -- Can you pass a variable from the screen that calls the

    I want to pass variable from my program to a remote view. public beg_dte_sql beg_dte_sql = 37884 OPEN DATABASE l:\pur\dbC\por.dbc SHARED USE POR!pur_por AGAIN IN 0 SELECT pur_por The above remote view has the following code. As you can see, I have hard coded a value so that I don't get the...
  5. DHart

    Program runs but no screen displayed - OS: WinXP

    That did it! Our standard config.fpw does not have this line of code. But you got me thinking, I checked the directory from which the program runs and found another project had created a config.fpw that had that line of code. Removing it did the trick. Thanks!!
  6. DHart

    Program runs but no screen displayed - OS: WinXP

    I should have added that the copied files did contain VFP runtimes. I will furnish the list. They were added to both c:\windows\system and c:\windows\system32 directories...
  7. DHart

    Program runs but no screen displayed - OS: WinXP

    Problem running vfp6.0 application Copied vfp6r.dll and vfp6renu.dll to c:\windows\system32 Recomplied the exe in vfp7.0. Ran a setup.bat file -- c: md avhdnc f:cd f:\configfp f:\configfp\editauto.exe adds SET FOXPROWCFG=C:\CONFIG.FPW to c:\windows\system32\autoexec.nt copy...
  8. DHart

    Notification that email has been deliveried

    I made this change. It works GREAT when I send only one attachment. When I attempt to send two attachments in the same email, the second one attaches as a shortcut to the actual file. Due to network security, some receipents cannot read the doc. Thanks for all the help, DHart
  9. DHart

    Notification that email has been deliveried

    Is there code that can be added to my Visual FoxPro program so that the mail server will send an email notification that the email was deliveried? procedure deliver_mail if empty(m.subject) .or. empty(m.text) .or. empty(m.recipient) wait window "Missing Email Header Data... Program Will...
  10. DHart

    EMAILING MULTIPLE ATTACHMENTS

    Recently, I received the below code as a solution to emailing word documents created in VisualFoxPro from existing reports. Also let me say thanks to danceman, mgagnon and rgbean for their quick reponse and help. MAPI control with MAPIMessages1 .AttachmentIndex = 0 .AttachmentPosition = 0...
  11. DHart

    Two reports to a single word document

    I need to send two different reports together in one email. One report was actually a fox report that was originally printed. The other one was really a word document. I created a database with memo fields and an input screen and a new report to accomplish the same effect without having to...

Part and Inventory Search

Back
Top