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: amills
  • Order by date
  1. amills

    Positioning the messagebox on the screen

    Is there a way to position the messagebox at a certain screen location ?
  2. amills

    Activating drop down list box

    I have a text box and list box on my form. What I want to do is open the list box and position it to the record that most closely matches what the user typed in the text box. What I need to know, I guess, is besides clicking on the list box arrow, can I open it with a piece of code. Andy
  3. amills

    Printing a report from multiple data sources

    I'm trying to print a report that list details from (3) different dbfs. Dbf1 Main client record Dbf2 Client payments (payment date and amount) Dbf3 Client comments (comment date, comment text) The first part of the report list the general info on the client. Then comes a section listing...
  4. amills

    Slow form opening form

    I have a form that contains client information and comments per client. Currently I am using the SET FILER TO command on the comments database to display the comments in a list box for any given client#. As the file has grown from 5000 records to 250,000 records the opening of the form takes...
  5. amills

    Listbox Question

    In the list box properties you can select LISTINDEX=1 to have the first record be selected. How do I position the list box to have the last item in the list box highlighted. The listbox can have anywhere from 10 to 100 or more records ? Andy
  6. amills

    Foxpro configuration file

    Where do I find the settings for the configuration file ?
  7. amills

    Foxpro configuration file

    I've copied my .exe file from the server to each workstation. How do I setup foxpro to do the sorting and look for the foxuser.dbf on the local machine ? Andy
  8. amills

    How to store file names from directory to dbf

    I have a folder called f:\convert that is populated with .txt files. How can I have foxpro store the filenames (ex. 123456.txt ) to a dbf file . Ideally, the dbf file ( ex. convert.dbf ) will contain one field that is character type with a length of 10 . Andy
  9. amills

    Error loading file - record number 18

    Never mind the previous reply. I found it. I had a file in the data environment set to exclusive use....duuuughh. Thanks for your help. Andy
  10. amills

    Error loading file - record number 18

    class = formset baseclass = formset objectname = CASESEARCH properties = DataSession = 2 BufferMode = 2 AutoRelease = .F. Name = "CASESEARCH" I've tried changing the datasession and buffermode to no avail. I'm not sure what it could be. Andy
  11. amills

    Can't quit Visual Foxpro

    When user accidentally closes the main form they are left with a blank screen they can't close. Get the message Can't quit Visual Foxpro. Is there a way to disable the X on the form window so that user can't click on x and close the form ? Andy
  12. amills

    Error loading file - record number 18

    I have a application that is run from server on workstations calling the .exe file. When second user pulls up tries to run form thet get message 'Error loading file - record number 18. CASESEARCH < or one of its members > Parent. File access denied&quot; Help ???
  13. amills

    Word requesting ODBC data source

    When I merge to Word I get the a pop up box in Word asking me to confirm data source. I choose Dbase Files - Word via odbc (*.dbf) and it continues the merge. DO I need to define an ODBC source in control panel. And if so, how do I set it up ? Andy
  14. amills

    Merging to word without merging empty fields

    I'm exporting from dbf to word mail merge. When I created the form document and attach a data source to it in word and merged it worked fine. It had an option to check to not print empty fields. When I go back to it after my program has run a merge. That option isn't checked anymore. Andy
  15. amills

    Merging to word without merging empty fields

    I have a dbf file that I merge with that has address1 and address2. If address2 is empty I don't want it to print a blank line before it prints the city,state and zip line. In the Word Merge wizard I can select that setting in my form letter, but once I execute my merge through VFP it doesn't...
  16. amills

    Confirm data source when merging to word

    When I merge to Word I get the a pop up box in Word asking me to confirm data source. I choose Dbase Files - Word via odbc (*.dbf) and it continues the merge. DO I need to define an ODBC source in control panel. And if so, how do I set it up ? Andy
  17. amills

    Closing form with merged fields

    Currently I use the following code which merges the document, saves a new merged document, and then closes the activedocument(s) and reload my saved merge document. The end result I want to achieve is to just have the merged document pulled up when the merge is complete. How can I close just...
  18. amills

    Do not print empty merge field

    In my form letter merge I print the following. {name} {address1} {address2} {city}, {state} {zip} Many customers don't have the address2 field populated, so I don't want a blank line printed if address2 is empty. How can I tell word not to print empty database field ? Andy
  19. amills

    Formatting Numeric Merged data

    I am merging from a dbf file. In my form letter it lists costs, tax, total . Each is a numeric field 10 char long with 2 decimal places. I want the data to line up with the decimal point. I've tried the \# ###,##0.00 switch after the merge field and \# ######.##, but still the decimal point...
  20. amills

    Highlighting first item in list box

    How can I get the first item in the list box to be highlighted when the Page Frame is activated ? I've tried Thisform.Pageframe.page1.list1.refresh Thisform.Pageframe.page1.list1.setfocus The list box is populated with notes by date and I want to have the most recent item highlighted so the...

Part and Inventory Search

Back
Top