Answer Questions

• Kenneth Jonsson editbox control snaps.

  It is a fairly mild problem but still an inconvenience. I have an editbox and a text is assigned to it in the following manner: THISFORM.Pageframe1.Page4.Edit1.ControlSource = "(ThisForm.cData)" All other operations are done programmatically. I may force it to count the number of lines and go to a specific line and highlight it. It does. But then after a while, perhaps in about 2 minutes, it snaps to the first line (beginning of ...Show All

• James_Peters How to set automatically 'OK' for a foxpro "update table messagebox"?

    Hi! When I add an old table (fox 3.0) in fox pro, the program get me the follow messagebox: "File 'TABLENAME.dbf ' will be updated in new file format, making it unreadable, to previus version of FoxPro. This can be reversed with 'COPY TO' command, and the old table will be saved as a .BAK file. Continue " and I have two button OK,  and NO! But I want that my program choose automatically the OK button! Is it possible Thank you ...Show All

• jacobmross VFP to show UPS tracking info.

  Hi; I have a place in my app where I populate a grid with various info including a txtbox that stores a UPS tracking #. I'd like to make this 'clickable' so it opens up a web browser to show the ups tracking info from the UPS site. I would need to do the same for fedex. I have no idea where to begin. Any pointers and ideas would be greatly apreciated. Aleniko. Here’s the Shell Execute, it wi ...Show All

• Joe C... VFP linked server issue

  We're using SQL Server for the majority of our applications, but our accounting package is still in VFP 8.0.  I need to make some costing adjustements from our inventory program.  I have linked the VFP database to SQL Server just fine and, using OPENQUERY, I can SELECT data without a hitch.  Performing an UPDATE or INSERT, however, is a different story.  I get the following error: "Server: Msg 7301, Level 16, State 2, Line 1 ...Show All

• Ronald Cagape how to copy more than 16383 recs to excel?

  I'm using VFP 7.0 & Excel 2003. I have a table with 58,000 records. Why does it only copy 16383 recs to excel when I use COPY TO "test.xls" TYPE XL5 I thought this limit is only on earlier version of excel TIA. Why should one need to export to Access and import into Excel from Access when s/he can do it directly from VFP Is it faster, better or what Does Excel's existence guar ...Show All

• ChicagoDave report temp file not found

  I need to create a simple report, nothing fancy. Just to preview some memo fields. This is the code I use. lcFile = "C:\VFP_Projects\Reports\MyReport.FRX" SET DIRECTORY TO "C:\VFP_Projects\TEMPORARYFILES\" CREATE REPORT (lcFile) FROM (ALIAS()) FIELDS memo1 The second line (set directory to) should be explained. I get an error that a temp file c:\\VFP_Projects\Data\...\000035e10062.tmp no found. Options are "Loca ...Show All

• Cordt VFP to show UPS tracking info.

  Hi; I have a place in my app where I populate a grid with various info including a txtbox that stores a UPS tracking #. I'd like to make this 'clickable' so it opens up a web browser to show the ups tracking info from the UPS site. I would need to do the same for fedex. I have no idea where to begin. Any pointers and ideas would be greatly apreciated. Aleniko. Dave; thank you so much. H ...Show All

• fpdeguzman78 Database security

  Sorry, my english less good . I'm making a program by using Visual FoxPro computer "A". All database, tables, form, menu and report stored in that computer. Which I wish to ask: 1.        If someone using computer "B", do he/she can make program with source exist in computer "A” 2.       If there are some computer which join by workgroup or domain, then each the computer ...Show All

• Innovasys editbox programmatic change

  I am looking for an easy way to determine if I've made interactive change in an editor box. The issue is that there are about 16 controls on a container, they are initialized from a table record thus their values at activate time generally are not trivial default. I have to save the changes with a SAVE button if I made any but I want this button's click method to quickly determine which control values have been changed. I do not want to do REPLA ...Show All

• CoastalData can't create an instance of Internet Explorer in my VFP 9 web service

  I am testing creating a web service in VFP 9.  In my test I need to read remote data by opening a URL.  The only way I know how to do this is to use CreateObject and open Internet Explorer.  However when I try to do this in my web service code I get a permission/access denied error.  Giving the web service directory additional rights did not fix it. Any suggestions or perhaps an alternate method of reading a URL in a web se ...Show All

• Sushmitha report temp file not found

  I need to create a simple report, nothing fancy. Just to preview some memo fields. This is the code I use. lcFile = "C:\VFP_Projects\Reports\MyReport.FRX" SET DIRECTORY TO "C:\VFP_Projects\TEMPORARYFILES\" CREATE REPORT (lcFile) FROM (ALIAS()) FIELDS memo1 The second line (set directory to) should be explained. I get an error that a temp file c:\\VFP_Projects\Data\...\000035e10062.tmp no found. Options are "Loca ...Show All

• ProfHawking Tools Option question

  There is an option in Tools=>Options=>General=Data Entry It says: " Fill New Records with Current Values ." It is a checkbox. Mine was not checked when I paid attention to it. So I decided to check it. Could anybody provide an explanation: What kind of Current Values is it talking about Why is this checkbox necessary Why is it here What kind of sense does it make Thanks. It is a legacy from the old XBASE days. It specif ...Show All

• Lightning Lord COM application using to much memory

  I have a fox pro program that records data from a website and stores the informatino in a ms sql server.  The com application is made from this program sometimes takes like 50,000 K - 100,000 K of memory.  How can i figure out if there is a memory leak What should I check   Is there a reason for the com to use so much memory.  The program uses sqlstrconnect to connect to the database.  It is only inserting data in the se ...Show All

• Neha Goyal How using barcode in VFP?

  Hi! Help me use barcode in VFP use ActiveX controls Where download it Thanks! Hi, This is true, but most of us don't like the tedious task of hitting the 'enter' key. Is there a way to scan a product and have it come up without further user input required Steve   Hi, Actually when you read a barcode, its just like typing the serial number ended with an enter k ...Show All

• Akram Hussein Query help

  I am trying to form a query in foxpro. I have two tables tab1 and tab2. I like to basically join the fld1 value from tab1 to the column name(named same as these values) in tab2 and get corresponding values for them. My idea of putting in a loop and incrementing the field name seems complicated. I really appreciate if someone can show light on this. tab1 column names id,fld1 values a1,200604 a1,200602 a1,200510 a2,200601 a2,200509 ...Show All