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
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
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"
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'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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.