Answer Questions

• kschuler report tool bar

  After a report is generated and appears in a preview you get a small toolbar that floats undecked in full view of the info that you try to read. It was an annoyance until I had only 1 page in the report and once I moved the bar down the report page and believe it or not it DISAPPEARED behind the frame's lower edge. It was not a big alarm for me then since I had only one page but now I have many and the only way to flip pages as I can see is to get the toolbar back. I cannot possibly retreive it no matter what I try. When I moved the toolbar down I hoped that it would deck somewhere and become available as part of the frame but it is not what actually happened. The toolbar disappeared at design stage but the same form's report appe ...Show All

• jan_hk 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

• Davids Learning Visual foxpro 9 watch hang

  I was testing a program with debug and watch window . I enter a function in the watch windw than a window like passward with no title apears and evry think is bloked. I have to end forcely by task manager. Since than evry time I start watch window I get the same window and bloking situation.I uninstald Visual fox pro and I reinstald it. The same think. I uninsald Visual FoxPro and I deleted all the directory from program file . I reinstald Visual FoxPro 9 and the same think happends. I posted a screen copy of the event to www.bluejeans.lx.ro if you want to see it. What can I do    In the watch window I tested this UPPER ( ALLTRIM ( INPUTBOX (DVDLOGIN_LOC,DVDLOGINCAP_LOC))) it permanently genereit an ...Show All

• Irina777 VFP 3.0 on XP

  I need VFP for a small project, and I don't want to spend USD 600 for a new version (is there a beta version still available ) Is it ok to install VFP 3.0 on Win XP Thank you, Tor Henrik ya me too. i wont recommend u develop program using vfp 3.0. pls using vfp 7 and above..... more stable ... Also, unless you have a copy of VFP 3.0b, you are limited to machines with only 384mb RAM or less. And even 3.0b only supports up to 512 mb RAM. Rick Ken, I like the hammer vs nail gun analogy!!! Lamon If you are a developer working in VFP, and if you are hoping to earn a living doing this, buy VFP9. Once you get there, you will never ...Show All

• Ishai Sagi[MOSS MVP] Tile Windows (Vertically) on DESKTOP Programmatically?

  Dear VFP Masters, I'm searching a way to (programmatically) (1) TILE My.Exe with other Window’s windows ... and/or (2) ‘ARRANGE-ALL’ on Window's desktop (VFP-9) ... if that is possible. Thanks in advance for any thought in this matter. You could do it with winAPI. BUT you shouldn't. Check on a related message titled similar to "changing backcolor of dekstop". Users can do that themselves rightclicking on taskbar if they ever wanted to do. CetinBasoz wrote: You could do it with winAPI. BUT you shouldn't. Check on a related message titled similar to "changing backcolor of dekstop". Users can do that themselves rightclicking on taskbar if they ever ...Show All

• MShetty Source from internet

  Where can I find a source on the internet where will be wethear forcast for Slovakia and the other world... I want to include it in my program, to show the weather forcast, just temperature, humidity, air pressure, wheter it will rain, or snow, etc. Don't know wheather this kind of source exists... Thank for your advice Look in some of the Web Service provider directories. For example: http://www.xmethods.net/ Can someone give me a sample code how to extract infos from such a site Dont know how to work with such a webservices... Or is there another way how to get wether infos and forcasts to my VFP program Or read an url adress and extract infos from the si ...Show All

• gkostel 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

• Rakesh Simpi anything wrong ?

  is there any thing wrong with this expression because its giving me an error. thanx for the help SCAN FOR BETWEEN (ldDate,from_date,to_date) ! EOF () Actually, it's easier than that. SCAN FOR implies WHILE !EOF(), so leave that off. The statement can be: SCAN FOR BETWEEN(ldDate, From_Date, To_Date) There is not any operator or scope clause between 2 functions. scan for between(ldDate, from_date,to_date) && no need for eof() check scan does that for you   scan for between(ldDate, from_date,to_date) while !eof() ...Show All

• Paul Bradley Aplication VFP9 can comunicate via computer's port?

  I need to send from VPF9 aplication a signal (grpup of chatacter) to a external device, via COM2 port, and receive also other signal from that device. I dont know what is VFP9 code that I must write in program to do this comunication. Is it posible  without use any auxiliary executable file Thank you.   Yes you can, using MSComm32.OCX See: http://fox.wikis.com/wc.dll Wiki~MsComm32 http://www.universalthread.com/wconnect/wc.dll 2,54,33,9336 http://www.universalthread.com/wconnect/wc.dll 2,84,14,7943 ...Show All

• Shushu Not able to run foxpro exe file (urgent)

  Hi , I have a foxpro forms and reports. when i run from desktop . it is showing 'CANNOT LOCATE THE MICROSOFT VISUAL FOXPRO LIBRARY' I got these files from client. i have installed my visual studio in 'C:\Program Files\Microsoft Visual Studio' So I have to anything in my WZSETUP file , In this file they have mentioned everything. Like source and destination. i have dbf files and forms and reports in this folders. Now i am not able to my client exe file. Kindy anyone tell me the solution Thanx and Regards Selva.R You must tell your client to check the "include run time files" check box in the last step of Setup wizard. If you installed visual foxpro on your computer it is not need ...Show All

• Rob Mijnen Add Fields To Word

  Hello out there: I'm trying to figure out a way to add a field to a Word document so when the document is called using Word Automation in Visual FoxPro, I can place a FoxPro table field value in it. I've seen it done before, I just can't figure out how to do it. Could someone out there help me Thanks. Bob, There are more than one ways. Word field, word mergefield, word form field, bookmark etc. Depends on what you're doing really. For a single document bookmarks seem to be easiest. For multiple documents mergefields sound to be more effective. If you would add fields yourself as a template then from VFP: oWord.Documents.Open( <fulpath to your doc> ) oWord.ActiveDocument.Variables("varname").Value = &q ...Show All

• Sunset Syntax error opening tables with VFP8

  I recently got a new machine and installed VFP8 Professional. .DBF files are associated with FoxPro, but the usual icon isn't displayed in windows explorer, its the windows default icon. When I try to open the .dbf that way, I get a syntax error. I can open up FoxPro and then navigate to and open that table, but that's a pain. I'm baffled on how to fix this, anyone have any suggestions I'd say you're on the right path Dan. I'm running XP Pro with SP2. I ended up doing a full uninstall, wiping away any remnants of FoxPro on the hard drive and re-installed. I ended up getting a different error which was indicating FoxPro was trying to open the .dbfs as .fxp files. I had one of our hardware/network guys ...Show All

• Jim J Vfp Converting DateTime Problem in MSSql

  Hi *. i have table on MsSqlServer "art" with 2 fields id int, date datetime and when try to put some value into datetime(), MsSql say go away :( mSql = "insert into art (id, date) values (2, '20061103141100')" =sqlExec(nHandle, mSql) Please give me solution for this problem in Vfp. p.s. Don't give me example with store procedure, 'coz i use mssql for storage only. Thx. Hi, Assign .NULL. value to your variable if you are following cetin's approach (parameterized sql), or replace your date value with NULL if you put your value as string into SQL. lddate = .NULL. SQLEXEC(m.nhandle, 'INSERT INTO mytable (mydate) VALUES ( lddate)') or SQLEXEC(m.nhandle, 'INSERT INTO mytable (mydate) VALU ...Show All

• Chang Chen Please help

  Any suggestion why the record not disappearing from the grid of Form when I press the delete (it indicates the deletion by black sign but not disappearing) Thanks # DEFINE MSGBOX_YES 6 # DEFINE C_MSGBOX1 36 # DEFINE C_DELETE_LOC "Are you sure you want to delete this record " IF MESSAGEBOX (C_DELETE_LOC,C_MSGBOX1) = MSGBOX_YES DELETE IF ! EOF () SKIP 1 ENDIF IF EOF () AND ! BOF () SKIP -1 ENDIF THISFORM . Refresh ENDIF I set it in "Init" and it's work perfect now Thak you Dan What's the data source If it's a view, you'l ...Show All

• clint 2 Speed issue

  Hi I have an open table in VFP. I am using vb.Net to get the records from the table. I use the following connection string to connect to the open table. Provider=vfpoledb.1; Data Source=\\Commercial\Data; Provider=Microsoft.Jet.OLEDB.4.0; Data Source= \\Commercial\Data;Extended Properties=dBASE IV;" The open table has more than 3,604,393 records in it. When I give the following sql statement Sql = “select * from ordDet where 1=1 and comp_code = ‘01’ and Itemcode =’02’” cmd = New OleDb.OleDbCommand(Sql, gconnMDB_I) Dim rdDept As OleDb.OleDbDataReader = cmd.ExecuteReader() Do While rdDept.Read() dr = dt.NewRow() dr(0) = rd ...Show All