Answer Questions

• MightilyOats Launching Adobe Reader Programatically

  Is there a way to launch Adobe Reader with a file name from within VFP90   I want my users to be able to print PDF files without having to search for the files - the search would be done through the GUI. Thank you, FUNCTION ShellExec LPARAMETER lcLink, lcAction, lcParms   lcAction = IIF(EMPTY(lcAction), "Open", lcAction) lcParms = IIF(EMPTY(lcParms), "", lcParms)   DECLARE INTEGER ShellExecute ;     IN SHELL32.dll ;     INTEGER nWinHandle, ;     STRING cOperation, ;     STRING cFileName, ;     STRING cParameters, ;     STRING cDirectory, ;     INTEGER nShowWindow   DECLARE INTEGER FindWindow ...Show All

• bigshiny90 Copying from one sheet to another within the same book

  I am creating a workbook for a local company using excel. I've got most of the book worked out except that when information is input into the "main" sheet I need the same information - the entire row - copied over to another sheet within the same book depending on certain criteria. In other words, if the value in a column is 2 then copy the entire row to sheet 2, if it's 3 then copy to sheet 3, and so on. Is there a way I can accomplish this kind of automation You need to create a function (macro in excel) and apply it in each cell of column 2. Macro can be done with vb editor from excel using "if" and "copy" range from excel visual basic. Anything you can do in Excel ...Show All

• RyanB88 Visual FOXPRO ODBC Drivers for windows Vista

  Hi. Does any one knows where i can get the Visual FoxPro ODBC Drivers for Windows Vista Thanks. Helder Santos I ran into the same problem and figured out a workaround. I tried to install the current 6.0 version of the VFPODBC DLL, and the MSI package ran. However, when I checked the drivers in the ODBC in the Admin Tools, it was still at version 1.0 I then went into the command line, unregistered vfpodbc.dll from c:\windows\system32, and then copied the verision 6.0 vfpodbc.dll (from another machine) into the c:\windows\system32 directory and registered it with regsvr32. Works fine, and give me a chance to relax. Our applications rely on the ODBC connection, and was starting to swet after ...Show All

• GrimStoner How to: Query dbf free tables with cdx

  Hi all, My english is not good, lets see if i can make myself clear: Im importing data from .dbf tables into Sql Server. Using VS2005, VB, SQL Server 2005 Express My connection string: Public dbfConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\server\folder on Srv\" _ + Replace(strDate, "-" , "" ) + "\;Extended Properties=dBase 5.0" With .dbf tables without a corresponding cdx I have no problem. But when trying to query .dbf tables with cdx files i get this error: Syntax error (missing operator) in query expression 'GNDITEM.ENTRYID = GNDLINE.ENTRYID INNER JOIN TAX ON GNDITEM.TAXID = TAX.ID'. In the directory folder theres a table "TAX ...Show All

• BinCoder Auto test a vfp form of exe

  Dear Experts, Is there any testing tools that can work with a vfp form or exe to repeat a set of mouse click say 10000 times for a stress test Any suggesion and thank you in advance. Milton You may repeat in a loop, a click method on a control and increment a variable... As per DNI, with MOUSE command For lno to 100 Mouse click AT nRow1 + lno , nColumn1 + lno && etc. endfor ...Show All

• ITJoeB Server 2000 v 2003

  Hi all, I'm working on a multi-user FoxPro product across a network. Up to recently we used a 2000 server and everything was fine. Since we've moved to a 2003 server we've ran into problems. We get 3 testers working on the same network tables and within a few minutes the application hangs and seems to lock the tables. The really frustrating thing is that it never hangs in the same area or on the one computer. Our error messages are very vague as well. Basically I was wondering if other people had problems going from Server 2000 to 2003. Is there maybe extra security or configuration in 2003 that 2000 doesn't have. Any help would be much appreciated, I have been doing tests on my app on 2000 Server ...Show All

• Snickel65 Form behavour different if launched from menu or click event?

  I am having a strange problem where the behaviour of a form differs if a form is launched from a menu or from say the click event of a button. The form is top-level with a default data session. I have a few variables that are assigned as control sources to some textbox controls. I am using the destroy event to perform some updates using theses variables. This allows the update to happen regardless if the user clicks the exit button on the form or the title bar. The problem is that the form behaviour seems to vary depending on how the form is initially launched. From a menu the above works fine but from a the click event of a button the variables are not available in the destroy event Does anyone know why the behaviour is not consi ...Show All

• Ian Barber .

  For 1st one what does "are not O-kay" mean What is the error message (I assume you already corrected my typo of not having .rows after oSheet ( oSheet.rows( "10:" + m.mrows)... ) ). For 2nd one, it's your fault not specifying VFP version you're using, not mine. oSheet("10:" + ltrim(str(m.mrow)) ).NumberFormatLocal = "#,##0.00_)" or: oSheet( textmerge("10:<<m.mrow>>") ).NumberFormatLocal = "#,##0.00_)" or one of other N ways... ...Show All

• dn8 VFP Bug... Or is it a feature?

  Hi all; In a grid's AfterRowColChange I have the following: if CertainCondition this.AllowCellSelection = .T else this.AllowCellSelection = .F. endif This is basically to implement a 'when' for the record the user is in. I have noticed that in some cases the AfterRowColChange won't fire. I have used ReadOnly (Instead of AllowCellSelection) and it works fine. Aleniko Aleniko wrote: Don't want to sound like Monti Paython but... No it doesn't... But readonly works fine. I did not make this statement without testing it If this is not the case for you, comething else is going on.   Aleniko wrote: Hi all; I have noticed ...Show All

• DavidC&amp;#35;2005 How not to print the image if there is no image file?

  My data table contains an image field holding the path and file name of image files. In my VFP report, I dragged in an OLE control and difined in the " Print When " option as "!empty(image)", meaning print only when the image field has data there. and I checked " Remove line if blank " option. My purpose is not to print or display the image (OLE control) if there is no image attached. But it still display a big blank space or simply a blank sheet. Anybody can help Thank you in advance.   Thank you for replying. The detail section looks fine. I simplified my table to make it look like the following: name c(10), descr (m), image c(20) In the report file, descr field goes to th ...Show All

• MDiwakar SCREEN RESOLUTION

  HELLO EVERYBODY, CAN WE SET RESOLUTION PROGRAMATICALLY IF YES, PLEASE TELL ME HOW Check http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=623910&SiteID=1 Yes. But don't do it. This is one of the few areas where software CAN break hardware. If you set a video mode that the video card can't support, you run the risk of frying the user's equipment. I won't use software that behaves that way, and I wouldn't blame your users for doing the same. Do a search for VFP Resizer classes on Google or other search. You can drop one of these classes on a form, set a few lines of code and it does all the work for you. It is not as eleg ...Show All

• devisjohn Memory leak in COM Server when passing array data?

  Hi, I'm trying to investigate why calls to our VFP COM Server seems to leak memory and hopes somebody can explain what is wrong. When following the memory consumption on the COM Server process instance in the Windows Task Manager the 'Mem Usage' explodes. I've created a scenario involving VFP and VB that seems to reproduce the problem. I'm using VFP 9 SP1 and VB 2005 (as included in Visual Studio 2005 SP1). The VFP program is very simple: DEFINE CLASS ComServer AS CUSTOM OLEPUBLIC FUNCTION PassArray( theArray[] AS Variant @ ) AS Boolean RETURN .T. ENDFUNC ENDDEFINE It has been build as a Win32 COM Server executable (comserver.exe). Because I've building from inside VFP9SP1 the COM Server is registered automa ...Show All

• AnnNeedsHelp FoxPrint font.

  In order for users to be able to use a font, is it enough for it to reside in the working folder of my VFP app, or do I need to install the actual font Thanks again, Aleniko to use a font you have to load it. In your app declare this API DECLARE LONG AddFontResource IN Gdi32 STRING lpFileName DECLARE LONG RemoveFontResource IN Gdi32 STRING lpFileName At startup load fonts LOCAL cFileName, cHomeDir cHomeDir = AddBs(<YourAppHomeDir>) cFileName = SYS(2000, cHomeDir + 'FONTS\*.TTF') && If Fonts are in <YourAppHomeDir>\Fonts directory DO WHILE !EMPTY(cFileName) AddFontResource(cHomeDir + 'FONTS\' + cFileName) cFileName = SYS(2000, '', 1) ENDDO Clo ...Show All

• qzrlsd Using Checkbox in a combo, or using Grids as combos?

  Hi; I need a class which will act like a combo, but will let the user select multiple items using a checkbox. Can this be achieved by using a combo I seem to remember reading somewhere that a grid can be utilized to act as a more advanced combo. Anyone can point me to the right direction Thank, Aleniko Depends on the number of records. If it is not too many then the native combo can do the trick with multi select turned on. If the number of records exceeds 100 or so then a grid (such as Marcias at www.tightlinecomputers.com ) OR Mike Lewis's SimpleList class works well. See http://www.ml-consult.co.uk/foxst-28.htm Mikes class is probably the easiest for simple selections, but Marci ...Show All

• NehpetsZero1 foxpro for windows

  sir, i hope i am not troubling you all. i have installed foxpro for windows 2.6 on win 2000. but i am not able to run foxprow.exe. i get error "divide by zero or overflow error" how to fix it. no. the same installation set works in win 98 or win 95. i have just created icon and run. i have run e:\foxprow\foxprow.exe. i go to my computer and click on foxprow still i get the same error. pls help regards (lakshminarayana r) If all files are properly installed you may try to create a short cut on desktop on foxprow.exe, then press property>compatibility>advanced and try win98. Yoy should have also in config.sys file or config.nt file: dos=high, umb device=%SystemRoot%\system32\himem.sys ...Show All