Answer Questions

• Shady9399 Automate appending data from an MS Access.mdb to two different Foxpro tables (including memo fields)

  I have 1 MS Access table calles Notes.mdb. I have two FoxPro tables called Measures.dbf and Special.dbf. I need to take data from Notes.dbf and import it into the FoxPro tables. Notes.mdb Special.dbf ID Number local.id Date/time datein comment code scode comment stext ARKS=yes SUP=yes Notes.mdb Measures.dbf ID Number local.id Date/time mdate Weight mvalue Weight unit munits ARKS=yes Sup=yes Need ideas for coding this. Tried to do an append query but the memo fields were empty. You could drop autoinc field from the list (select field1,filed2 .... from ...) and it would populate itself. The only problem I ...Show All

• Haim Cohen Detect hard diskk serial number.

  Dear Expert, Can I know how to detect the hard disk serial number or code using foxpro Thanks a lots. Oh I thought you could do it WMI already and don't know how to get driveletter. Create Cursor myDisks (DriveLetter c(1),SerialNumber c(50),Model c(50),DeviceID c(50)) wmiServices = Getobject("winmgmts:{impersonationLevel=Impersonate}!//.") wmiDiskDrives = wmiServices.ExecQuery("SELECT Model,DeviceID FROM Win32_DiskDrive") For Each wmiDiskDrive In wmiDiskDrives lcDeviceID = Trim(Strtran(wmiDiskDrive.DeviceID,'\','\\')) wmiDiskPartitions = wmiServices.ExecQuery(; 'ASSOCIATORS OF {Win32_DiskDrive.DeviceID="' +; m.lcDeviceID + '"} WHERE '+ ; 'AssocClass = ...Show All

• shmulik_segal Error Problem in FoxPro application

  Hello all, I am trying to open an application that was build using FoxPro and when I open it, I got this error message. I have no clue at all that it means. And if I click "Ignore" the application will run just fine. Here is the message error that I am getting: Error #1429 in Init line 27 OLE IDispatch exception code 0 from Nodes: Element not found.. Call Stack: 7 Surveys001.Oletree.Init (..\..\..\..\..\program files\tfhudgins\compressormanager\source\surveys.sct) 6 Cmstatemanager.Cmformcollection.Add (..\..\..\..\..\program files\tfhudgins\codemine\common50\cmstate.vct) 5 Cmstatemanager.Openform (..\..\..\..\..\program files\tfhudgins\codemine\common50\cmstate.vct) 4 Tbrlaunchpad.Chktoollaunchbutton1.Launchform ( ...Show All

• GTrz Visual Foxpro report writer

  I have a dbf with following fields bill no, bill date, cust name,item name,qty,rate,amount and i have 553 records. i want a simple report on 132 column stationary. i dont want totals also. (so no page footer or summary). i used visual foxpro report writer. but the report does not print with proper ejection i.e. second page starts printing from bottom of first page and third page prints from bottom of second page and so on. printer is absolutely fine because documents from excel and word print with proper page breaks. can anybody help >>why dont u ansewer this question First, may I remind you that all people here are volunteers who give their time and expertise, for nothing, to the community. No-one who an ...Show All

• robertje Turning off Word Spell/grammer check programmatically in VFP

  Can anyone help me out here I am trying to turn off the spell check and grammatical check in word through a VFP application. I cannot find the correct property for the two to use.... I ran a macro to try and get it, but the macro uses .CheckSpellingAsYouType .CheckGrammarAsYouType .CheckGrammarWithSpelling etc... but when trying these properties in VFP they do not translate obviously... I get ole error - unkown name If anyone could help me out here.. that would be great.. I have searched for about 3 hours now and can't seem to get it correct.. thanks for any help Try this: *** Reference to Word ow = CREATEOBJECT ( 'word.application' ) *** Get a reference to the Options Object oWOpt = ow.Options *** Set ...Show All

• mbuchetics VFP 9.0 ReportPreview ZoomLevel Property

  Hi All, I am trying to setup the ZoomLevel as " Whole Page" by default when the preview is loaded. I use reportlistener and a custom preview container. i have this piece of code in my Custom Extension Handler in the previewcontainer .PreviewForm.movable = .f. .PreviewForm.windowstate = 1 .PreviewForm.windowtype = 1 .PreviewForm.minbutton = .f. .PreviewForm.maxbutton = .f. .PreviewForm.borderstyle = 1 .PreviewForm.autocenter = .t. .PreviewForm.titlebar = 0 .PreviewForm.ZoomLevel = 5 loToolbar = .PreviewForm.toolbar .PreviewForm.toolbar.movable = .f. .PreviewForm.toolbar.sizable = .f. .PreviewForm.toolbar.visible = .f. .PreviewForm.toolbar.dock(0) .PreviewForm.refresh() .PreviewForm.toolbar.visible = .t. .PreviewForm.toolbar.refresh When i ...Show All

• Ather. Error loading

  Hi al; I have an application installed on site which is using vfp runtime. Often we get the following error: Error#2005, Error loading file - record number 29. frmCustService01 <or one of its members>. Loading form or the data environment : File is in use by another user. I have no clue how to try and figure out which file in use is causing the problem, or exactly where in the code the error is being generated. Record#29 - is this the record # in the scx file How can I figure out what exactly is causing this Any good ideas Thanks so much. This may not be relevant, but one possible cause is that you are trying to open a table exclusive. Could you have inadver ...Show All

• fatquack cryptography failure

  I use _cryptapi class of the _CRYPT class library to encrypt limited amount of information: ids and passwords. They are in a table and the table feeds treeview items on demand. Before appearing in treeview the field values are automatically decrypted. Everything has been working fine until I noticed a problem yesterday. I have done most of development on C: drive but recently began moving the whole project to a G: drive since I set a new OS up on that partition. It is a bootable partition. If the encryption done on C: partition it can only be decrypted on that same partition. On partition G: everything is garbled. If I encrypted an item on G: partition I can decrypt it only here, it will be garbled if I run the application on C: I ch ...Show All

• Nigel36 dsn-less connection

  I'm using VFP9 SP1. I have tables (dbf) which are contained in a database container (e.g. test.dbc). Now, I want to create another database which will contain remote views to those tables. I will use dsn-less connection. What is the difference between a connect string to visual foxpro tables and a connect string to visual foxpro database DSN=Visual FoxPro Tables;UID=;PWD=;SourceDB=c:;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes; DSN=Visual FoxPro Database;UID=;PWD=;SourceDB=c:\test.dbc;SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes; Thanks, Peter The difference is in the "SOURCE" that you specify. If you are a ...Show All

• Michael_Giagnocavo Column Visible in Grid

  Ok, I am creating a grid and I need to create a column called "ProvRecno" to use for a refrence pointer. I can make the column, and I can see all the info I need, however I want that column to be non-visible. I am not sure how to set this column to visible = .f. The Grid is built from a SQL select, and I need some way to select the column titled ProvRecno so that I can set its visibility to .f. Any Ideas No setting to 0 was also ill behaving. It was setting to columnwidth to 0 but gridline is there, making a thicker gridline (the more the invisible columns the thicker the line was). And using tab key or alike that column(s) is visited in between (user gets confused where the cur ...Show All

• Voodoo45 BINDEVENT with Windows messages

  Hi: I've been trying with BINDEVENT to prevent a form from being resized by intercepting the WM_SIZING message but I couldn't manage to do it Repro code (VFP9): -------------------- DECLARE INTEGER GetWindowLong in Win32API INTEGER hWnd, INTEGER nIndex DECLARE INTEGER CallWindowProc in Win32API INTEGER lpPrevWndFunc, INTEGER hWnd, INTEGER Msg, INTEGER wParam, INTEGER lParam PUBLIC frmTest frmTest = CREATEOBJECT("xForm") frmTest.Show() RETURN #define WM_ENTERSIZEMOVE 0x0231 #define WM_EXITSIZEMOVE 0x0232 #define WM_SIZING 0x0214 #define BROADCAST_QUERY_DENY 0x424D5144 #define GWL_WNDPROC -4 DEFINE CLASS xForm as Form Left = 600 PROCEDURE Init WITH ThisForm BINDEVENT (.HWnd, WM_ ...Show All

• Georgiev Grid and textbox Refresh issue.

  I'm having this problem with an application I’m writing. I have a Grid with a couple of text boxes next to it. When you select a record it updates the values in the textboxes with the values from that record. I also have a few command buttons that switch the tables viewed in the grid. Now here’s my problem... The text boxes stop updating after I change the tables a few times. Not sure what I am missing because I don't get any error messages and it does work for a little while. If you need more information let me know. Try changing _mainform to thisform. _MainForm is not guaranteed to be be thisform (public var, scx name both dangerous). What's the code in AfterRowColChange What ...Show All

• WHMoweryJr sms sample code

  Could someone please give me a sample code on how to send SMS through VFP 6 0r 7. I live in Australia and my mobile phone provider is OPTUS. My internet provider is optusnet.com.au Thank you and happy new year. Thank you for all who have unselfishly helped us VFP users for the past years. Rolly I've never used it myself. But, at worst, you may find this at least a place to start: Smart SMS http://fox.wikis.com/wc.dll Wiki~SmartSMS~VFP Excellent!!! Carl. Thanks. ...Show All

• MWillig Learning 9.0

  Hello, I'm new here and wanted to know if anyone could give me some ideas on which books would be best to learn FoxPro 9.0. I'm a beginner so I need to learn from the start. Any help would be appreciated. I agree with Hentzenwerke as publisher of the best VFP books. You should also look at the Fox Wiki ( http://fox.wikis.com ) as a great source of information. And of course, ask here once you have a question on a piece of code that got you stuck. Check out http://www.hentzenwerke.com Thanks for sharing As Cetin says, try the Hentzenwerke web site for the best VFP books. Probably the best beginner's book (although it was written for Version 6.0 the b ...Show All

• yeos_lee Grid class

  I have made my own grid base class with 9 columns. When I create a grid based on this class, and I try to reduce the number of columns, I get an error message saying "Member COLUMN# is a class member" (# being the umber just above the one to which I want to change; if I want to go from 9 to 7, # = 8). What am I missing, believing this would work Hans L PS. I wanted to make every column heading centered vertically/horizontally and bold. With column # = -1, this cannot be done, as far as I understand (no columns in Propoerties). And when I set the When to .F. in my Grid class, and, for instance, Valid to .T., and I then look at an instance of the Grid class, Valid shows "Inherited ..." ...Show All