Search results for query: *

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

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

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

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

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

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

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

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

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 ???

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

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

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

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

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

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

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

I am trying to create a letter merge routine that will merge multiple letters into one Word document. Is there a way to append a merge into an existing file in Word ? Currenty I have a form with a list box displaying the records to be merged. When the user presses [F6] it creates the dbf file...

I am trying to use a combo box to have users input a six digit file number to lookup a record. I have the command in the click event to seek the record and update temporary variables and that works fine. However, when I try and use the keypress event and execute the seek, it finds the wrong...