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!

Register Log in
  • Congratulations derfloh 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: xk120
  • Order by date
  1. xk120

    Refreshing data from a remote view

    I have a query that uses a remote view. I need to check that all the data is updated before beginning some batch processes. I run the query and check the date on each record, if it has not been updated yet, then the program loops back and reruns the query in ten minutes. The problem is after...
  2. xk120

    refreshing remote views

    I am guerring a remote view to test if tables are updated. I run the query and test some file parameters to see it they are ready to download. If they are not updated the program is supposted to wait 10 minutes and requery the table to check the parameters again. When I rerun the query it...
  3. xk120

    Fomatting an Outlook message from VFP

    I have launched Outlook from within VFP and want to add data entered on a form as the Body of the Outlook eMail. Example: Name: Frank Emp Number: 4999 Meno Box: I want to go here tomorrow I want the above fields enter on a VFP form to appear on an eMail as follows...
  4. xk120

    Opening Outlook from VFP and sending an eMail

    I have an application that I want to open outlook in the background and when a command button is pressed it will send an eMail to a particular person.
  5. xk120

    OBDCSTF.DLL won't open during .EXE installation

    Using the Setup Wizard I built a set of installation disks to install my application on other desktops. I used the same proceedure many time in the past with great success. This time when I run the Setup it runs fine until it tries to open the ODBCSTF.DLL. I just reinstall VFP6.0 and it...
  6. xk120

    Reports - removing summary totals if they are '0'

    I tried that, I set the print when to the same expression as I used to create the balance on each line. It applied the logic to the last line of the detail above, if there were three lines 10,-20,0 and the print when said <>0 it would not show -10(the sum of 10-20+0) because the last line of...
  7. xk120

    Reports - removing summary totals if they are '0'

    I have created a report which displays the excess inventory for a part number(it is a calculatrion of three fields), each part number can have several lines. I created a Group Band on Part Number, the calculation is set to sum and it resets after each change in part number. The problem is I...
  8. xk120

    Print Preview ToolBar

    Here is the Code: Report Form I:\programs\issbu\reports\project_billing_issbu to printer prompt preview I'll check the closable properity of the form calling the report. I'll also try and use the _pageno system variable. Thanks Bob Fisk xk120se@aol.com
  9. xk120

    Print Preview ToolBar

    Jon Thanks, the problem is the [X] button on the preview panel is not enabled so the user can't click on it. How can I enable tghe [X] button on the preview panel? I understand the RANGE X,Y format, but can I load two vaiables x,y with value from the print preview toolbar(goto page button)...
  10. xk120

    Print Preview ToolBar

    This is a two part question concerning Print Preview Toolbars: 1) I'm using a short cut menu to run a report with preview at the end. This launches a preivew window containing the print preview toolbar for you the view, navagate, print or close the report. If you click on the...
  11. xk120

    Accessing Win API files

    I am running an application on our network server. When someone logs onto the application I want to store his/her login initials in a file so I know who is currently using my application. The problem is I don't know how to get to the Window API that stores the initials.
  12. xk120

    How to save a file as xls and allow the user to choose the dir(Path)

    Thanks, great job!!!
  13. xk120

    How to save a file as xls and allow the user to choose the dir(Path)

    Copy to (putfile()) type xls works, but when I choose to cancel without saving I get an error &quot; OLE error code 0x80030003 Unkown COM status code&quot; What is this error, how do I fix it?
  14. xk120

    How to save a file as xls and allow the user to choose the dir(Path)

    How can I let the user of my application save a small data set of a table into xls format (COPY TO) and then direct the xls file to a directory they choose? When I use Copy To I will default the file name/path. I want the user to be able to rename and save the xls file to anywhere they choose.
  15. xk120

    HELP

    Here is the SQL select statement that builds the view: SELECT *; FROM DSSCOM.TRANSACTION_DETAIL Transaction_detail; WHERE Transaction_detail.CATEGORY_ID = 'X1'; AND Transaction_detail.INV_PROD_FAM_CD <> 'D1'; OR (Transaction_detail.CATEGORY_ID = 'C1') (This statement creates a 275m...
  16. xk120

    HELP

    Can anyone explain why the cursor created by a remote data view is 275M in size when the table that results from a query of that view is only 6.1M. Next how can I close this 275M cursor after the query builds the table without closing the project?
  17. xk120

    Accessing the Windows Registry

    How can I access data stored in the Windows Registry?&nbsp;&nbsp;I found Registry.Vcx in the Components Gallery of VFP but I can't get it to work.&nbsp;&nbsp;Help!!!<br><br>Bob

Part and Inventory Search

Back
Top