Answer Questions

• Bassam72 Grid columns populated with incorrect data

  I have a grid with a bunch of columns. First, I suspect that the control source for the columns in this grid 'resets' itself to 'none', but I am not sure about this. Second, When I manually fill in the control source for the columns, some of the columns get populated by the next field in the cursor regardless of what I have specified in the control source. Help... Aleniko You're doing a select *. Maybe the order of the fields have changed and do not match one to one columns. Instead of select * you can specify the fieldnames in the order you want. Second, you're selecting into a cursor and making that cursor the recordsource of the grid. You could directly make the select itself the ...Show All

• Priyananth Passing multiple variables from forms w/ VFP7SP1

  I'm an old Clipper (S' 87) programmer that needs to figure out forms with VFP. The attached code generates a form containing a set of four optiongroups that set basic comm port parameters on the local host for serial communication with an instrument (usually an electronic balance). I'm trying to use the form to replace a series of cascading menus in the original program. My intent is for the form to recognize the 5 existing parameters in the main prg, permit user input and then pass any changes back to the calling procedure or function using a array embedded in the form when the user clicks [OK]. Clicking [Cancel] should leave the parameters unchanged. Can somebody please suggest a technique for passing multiple variables back and forth be ...Show All

• Jon Braganza Using server's date/time.

  Hi; Is there a way to make VFP use the server's date/time in the different date functions I have XP stations on Win2003 server and some machines sometimes have a messed up date. Transactions are updated with the incorrect date because the stations are not set to the right date / time. Thanks, Aleniko Thanks. But how do you set the stations's time You notify the user Is there a way to setup the date from within VFP with no user interaction Thanks. Cetin; Something wierd happening here... I'm running your script. Station time is 5:16:08 PM. Server time is 5:12:23 PM Your function returns 5:16:08 But whats funny is that ...Show All

• IS dude VFP Virtual Hosting Service

  Hi all, I am searching for a good reliable VFP virtual hosting service. Any suggestions Thanks, Jim Try with winnethost.com I'm not sure what you're looking for. Are you looking for someone to host sites that use VFP (say, with Web Connect or another 3rd party product) If so, check out www.dngsolutions.net. Tamar ...Show All

• James Knowles Combo Quick fill while combo is expanded.

  Hi all; I have a class which uses code Marcia Akins posted here (Thanks Marcia). The code uses the InteractiveChange of the combo in order to produce a quick fill functionality. The problem: This won't work when the combo is expanded. I've tried to utilize the kepress method but it didn't work. Is there a place I can disable the inherent functionality of the combo when its expanded so it won't interfere with the quickfill functionality Thank you all. Using a textbox,button and grid you can mimic a better "combo". Not stupid at all, but yes, it is set to false. But Marcia's code should work. ...Show All

• cunyalen Help with rounding

  Help!  I have to round a number to the closest 500 but if last three digits are between 0 - 250 round down, 251 - 499 round up, 500 - 750 round down, 751 up, round up. Example: 2140 should round to 2000 2257 should round to 2500 2660 should round to 2500 2760 should round to 3000 Thanks in advance! Can you test Mod(<number>, 1000) to make round Mod(2140, 500) = 140 -> Down (<number> - 140) Mod(2257, 500) = 257 -> Up (simply <number> - 257 + 500) Mod(2660, 500) = 160 -> Down (<number> - 160) Mod(2760, 500) = 260 -> Up (2760 - 260 + 500) and so on... Thank you everyone for your help! ...Show All

• JeffNick How to retrieve data in memo field for editing ?

  I found that I could not retrieve the data from vfp system variables. What method should I adopted It was because the application need to use long type message. Your question is not clear. On the one hand you talk of system variables: cGenMenu = _GENMENU _INCLUDE = "C:\COMMON\INCLUDE\MyLibrary.H" You talk about "long messages". What are you referring to If it is long filenames (with embedded spaces), just enclose it in quotes: cFilename = "C:\Program Files\Microsoft Visual FoxPro 9\MyFile.txt" On the other hand, the thread title talks about Memo fields: cMemoContents = AllTrim(MemoVar) Please clarify. ...Show All

• weeMac MyEditor (Edit Control) Validation in VFP-9: STOPPING Menus, etc?

  I'm trying to *stay within myEdit control(s)* until *pProcessing* is finished. I seek *better ways*, per se, from any of you (besides making the form(s) modal). Here are some of my awkward (non-bulletproof) workarounds. In myEditor.VALID ... If pProcessing This.SetFocus * Return .F. Endif To STOP Menus... In _msysmenu: set skip for pProcessing (for every menu bar()... ) OR SET SYSMENU SAVE SET SYSMENU TO ...when pProcessing is finished SET SYSMENU TO DEFAULT (I'd prefer to make _MSYSMENU/SYSMENU just *freeze* ... in a modal (myForm.windowtype=1) manner and not have it *blink* off and on ) To prevent oApp.oToolbar... If pProcessing oApp.oToolbar.enabled=.F. Endif Hiding forms until pProcessing is completed, Etc. Etc. Thanks in adv ...Show All

• Bravo2007 Preventing key strokes to be passed to control

  Hi, I have a form that needs to read data from a bar code reader. The bar code reader connects to the keyboard plug and functions like a keyboard. So what I would like to do is to have the user click a "Barcode Read" button and then scan all the bar codes he needs to scan and then click a "Done" Button. I was going to intercept the barcode data in the forms "Keypress" event and store it in a table. Problem is that I have so far found no way to stop the keypress data to be passed to the current control. As each set of data is terminated by a CR each time a barcode is read you jump to the next control and when you get to one of the buttons <CR> just clicks that button. So what I need is to intercept the ...Show All

• Joshua Blake GRID HELP

  hI! I HAVE PUT A GRID IN A FORM BUT THE CURSOR DOES NOT MOVE TO THE SECOND ROW.SO PLEASE HELPPPPPPP! also when i run this form a pop-up window come open with 3 options 1)do you want to add records in a parent table 2)do you want to add records in a child table 3) do you want to add records in both so i want this pop-up window to stop coming up when i add new record I take it that you have used the form wizard to build these forms because this is not native behavior. You would be better off not to use the wizards. There is too much baggage that comes along with them (as you are now discovering). NILKAMAL wrote: hI! I HAVE PUT A GRID IN A FORM BUT THE CURSOR ...Show All

• emccormi how to create a setup wizards?

  Sorry for the incomplete questions before. Yes, i know how to build an executable but i really don't know how to create a setup wizards in Version 7.0 but in Version 5.0 you can only click the Tools--->Wizards--->Setup. Where's the Setup Wizard in Version 7.0 Starting with VFP 7.0, a version of InstallShield was shipped. You can use that to create an installation package for your application. There is a guide to doing this: "Walkthrough: Creating a Visual FoxPro Application Setup Program Using InstallShield Express " available from the VFP Website at: http://msdn2.microsoft.com/en-us/library/ms917481.aspx VFP7 and above comes with Installshield Express which you can use to build setup files ...Show All

• M. Abraham Hot key question

  I know that we can assign a hotkey 'S' for a button like : thisform.button1.caption="\<Start" The question is: how to assign a hot key "Page Up" or "F2" key for the button in a form You can'nt make it using a "Hot Key" assignament, instead, you need enable the KeyPreview property in your form, and to provide custom code into the KeyPress Method with the handlement of your keys. A Example: ** More at **** http://fox.wikis.com/wc.dll Wiki~KeyPress~VFP **** http://msdn2.microsoft.com/en-us/library/6wd37f7s(VS.80).aspx Procedure KeyPress (nKeyCode, nShiftAltCtrl) ** nKeycode returns a inkey value. http://msdn2.microsoft.com/en-us/library/aa977875(VS.80).aspx Do Case Cas ...Show All

• rahoward Error when opening Foxpro build-in database application: Open File - Security Warning

  Hi I upgrade the latest version of Internet Explorer. I received the error (as mentioned in header) when opening the database system. In the box, The publisher could not be verified. Are you sure you want to run this software Name: job000.exe Publisher: Unknown Publisher Type: Application From: \\Server\documents\Jobsys How to verify the publisher Thanks / millbear. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=971214&SiteID=1 ...Show All

• guilhermecvm94558 VNC API?

  I’m not familiar with VNC from a programmer’s point of view. But I would like to add a “Get help” button to my FoxPro apps that will once clicked a VNC server will load and Connect to a viewer at my office. Is there a VNC API some where that can do this Thanks Sammy You may find API functions and examples for connection : http://www.news2news.com/vfp/ example=412&ver=vfp or an other way to connect may be: http://www.sharewareconnection.com/vnc-fast.htm ...Show All

• Diango how can i restore a form that failed to load?

  it happens when i compile my project. "Error Loading file-record number 3. cursoradapter < or one of its members>. Methods: c:\myprogram\forms\solditem.SCT is not an object file" is there anyway we can restore it since if we copy from the original, and or make another d'same form from scratch it's a long process. Thank you i locate that record # 3 at MS SQL Server table but it has no problem in there. i can't also modify it anymore because of that error. thank you for your help. I meant record #3 in your scx file. You should do something like this: -Take backup of .scx and .sct -Try a compiling and check if that works (that might be the only thing needed at times) compile form solditem.scx ...Show All