Answer Questions

• Jimmy Li refresh

  i am placing a value one field depending on what is entered in one field for example if a zip code is entered in the zip field then the corresponding city is entered in the city field.  i get the city to appear but only if i tab to the city field.  how can i get it to automatically be entered upon tabbing or clicking out of the zip field.  im just not sure where to put the code.  am learning visual foxpro after programming un ...Show All

• Dave Green Improved memo fields in grids

  Hi all; I've posted this before. Its hard for me to believe that there are no good solutions for this: I'd like to change the way a memo field is represented in a grid to something better looking than "Memo" or "memo". I'd like to have a command button, maybe with an icon representing if there is data in the memo field or not. Also, I would like to keep the capability in VFP9 that shows a kind of a tooltip with the content when ...Show All

• Magicle Error Loading File - Record Number...

  I have been struggling with this for the better part of this week. When I try and load a form it gives me this error Error loading file - Record number 41. Formset <or one of its members> Parent: Function arguement value, or count is invalid. Looking in the .SCX and the Parent coloumn, the record is an empty memo field. I have very little experience in trying to fix a problem like this and could really use some help. J.Newman ...Show All

• Joannes Vermorel i just wanna do it like this

  can i do that thank you everyone. thank you very much Jet 1st you need a way to track what the user has selected.  The easiest way is probably a logical field in the table, or a related table that you can toggle on and off. 2nd you need to put code in the mousedown or click event for the textboxes of the grid that toggles the selection. 3rd set Column. DynamicBackColor of each column.  Easiest is usually an IIF() with the R ...Show All

• mradlmaier Old Fox Pro Code Please Help

  I have the following code from an older version of Fox Pro.  I typed it into VFP 8 and I can't get it to work. Does anyone have any suggestions SET BELL OFF SET TALK OFF SET DEVICE TO SCREEN CLEAR ****** NUM1 = "   " NUM2 = "   " NUM3 = "   " NUM4 = "   " NUM5 = "   " NUM6 = "   " @ 10, 5 SAY "ENTER LOTTERY NUMBERS" @ 10, 50 SAY NUM1 PICTURE "XXX" @ 10, 50 GET NUM1 PICTURE "XXX" @ ...Show All

• Mr.Sun Vfp 9.0 Report Writer.

  Hello Guys Vfp9 overall is very overwhelming for guys like me who have started very small with FoxPro 2.0 for DOS. Learning VFP 5 (on my own) with no decent books and absolutely no training available and getting all these releases and not all that time to get acquainted is really difficult. One has the choice to keep themselves to what they know and then gradually grow, but seeing all these features and not working on it is again a problem. I h ...Show All

• Pewal Command Window History

  I have VFP 9 SP1 installed both at work and at home. At work, previous commands are saved when I quit, but at home the command window is empty when I start up. I've spent quite a bit of time trying to figure this out with no luck. Apparently, the history is saved in a file named _command.prg in a subfolder of the user's documents and settings folder. I copied the file from my work machine to my home machine, but that didn't seem to have any effe ...Show All

• Brian Matuschak 12 hour time format

  Hello, I am doing a program that will compute the time in and time out.  As much as possible I want to do the time() function and not the datetime() function but the problem is if I use time() it displays the 24 hour format.  What I am tasked to do is to subtruct the time out to time in and be able to display the 12 hour format. Any advice will be greatly appreciated. But surely that's a display issue, not a data storage is ...Show All

• VKB newbee - does VFP9 have a runtime engine?

  In a former life I programmed in dBase/Clipper/FoxBase and other extinct languages.  An old Clipper application from 1987 needs updating and they do not have a Clipper compiler.  My thought is to rewrite the app in Visual FoxPro 9, which I will order next week.  I need to figure out how many copies of VFP9 to purchase.  One copy for me, one at the client location...  Is there a runtime engine in VFP9 Do I need a so ...Show All

• Alistair Leslie-Hughes VisualFoxpro9.0 row delete and commit through JDBC

  Hi all, I am new to foxpro. I have two issues, 1.) I want to run sql statement and delete the rows throght JDBC connection. Every time I run the delete query, I go to table/Remove Deleted Records and remove the records manually. How can I remove deleted records and refresh table through sql statement 2.) I want to manage transaction manually. I set  the autocommit to false in the JDBC connection object but VF doesnt seem to care about ...Show All

• Sussch checking RTF control for EMPTY ()

  I have trouble checking programmatically that RTF.textRTF is empty. If it is visually empty to the viewer the function EMPTY (RTF.textRTF) returns .F. If I use an assignment m.memVar = RTF.textRTF I can print it out as a set of strings (about 3) of formatting characters. It is after the control was filled with some text and subsequently that text was deleted (manually) in the control window. How can a test be done to verify that the control i ...Show All

• Jimc25 =SYS(1037) on VFP90 no longer allows printer changes

  Can anyone tell me how to work around the changes in SYS(1037)   I used to call this with =SYS(1037) before printing in a batch (checks and invoices) and it no longer allows my customers to change the printer in VFP90 (no 'apply' button).  The 'prompt' option in REPORT FORM works just perfect too, but I don't want to call it in a loop (too repetative.)  Any ideas Thanks This solution seems to work, but the printer spools th ...Show All

• gabriel_333 Urgent! How to change the value of a range in an Excel worksheet in VFP?

  Dear Experts, I've formatted a range from Text to Date in an Excel worksheet using codes in VFP, however when I open the worksheet to view the format is changed but the values still showing as text. Also found that the values will only change when i double-click on each indiviual cell on the worksheet, how can i do it using codes in VFP Your help appreciated. Andrew maybe forget about my code as it ...Show All

• Sriteja Error Loading File - Record Number...

  I have been struggling with this for the better part of this week. When I try and load a form it gives me this error Error loading file - Record number 41. Formset <or one of its members> Parent: Function arguement value, or count is invalid. Looking in the .SCX and the Parent coloumn, the record is an empty memo field. I have very little experience in trying to fix a problem like this and could really use some help. J.Newman ...Show All

• Dragon123456789 Foxpro in Visual Studio 2005

  Hi  . Why Microsoft dont develop Visual Foxpro . and why Microsoft dont create Visual Foxpro in .NET Freamwork ThankX. Skyline . In addition to what you have been told already, youy will notice that there are actually two other notable Microsoft products that are NOT in the .NET framework. Access SQL Server Like Visual FoxPro they are databases and since the .NET framework is not (yet) designed to incorporate data integration they ...Show All