Visual FoxPro

Page 16




  • Topics
    Replies
    Last post
  • Using VFP6 to hide sheets and protect book in excel
    by mrfitness
    7 Replies
    Last post by Cindy Winegarden
      • I used a program to copy results of a query into an excel sheet. Now I would like to hide two sheets that I renamed in the program - 'High' and 'Med'. I would also like to protect the book. How can I do this Is this even possible Some sample coding below: esheet=1 loExcelTemplate.sheets[esheet].select oActiveSheet = loExcelTemplate.ActiveSheet oActiveSheet.name = "High" &&RENAME
  • Fax Report Using VFP9
    by emery
    11 Replies
    Last post by emery
      • As resolved in "VFP Fax Integration" thread , I have been using Jaime's method to fax Reports with graphic/image and it works very well for VFP6. set printer to name "Fax" report form myReport to file "myfile.tif" noconsole Recently I compiled and ran my program using VFP9, I got the following Program Error: OLE IDispatch exception code 0 f
  • Embedded manifest - Vista Logo Certification
    by Marius Mutu
    4 Replies
    Last post by Marius Mutu
      • Hello I have a VFP9 app and I want to submit it for Vista Logo Certification. Test Case 1 specifies: " Verify all of the application¡¯s executables contain an embedded manifest that define its execution level " Open CFF Explorer 1 . Browse to and open the executable. In the tree menu on the left look for and highlight Resource Viewer. Look
  • Option group woes
    by Hans L
    3 Replies
    Last post by Hans L
      • I am getting back into VFP after some time off, but I thought I knew that if I create a field iGender (integer) and I created an option group with option buttons Male, Female, and Unknown, and I set the ControlSource of the opg to iGender and the value of the opg to 3, "Unknown" would be filled when I opened the form in which it was located. However, that does not happen for me now. What
  • Virtual keyboard problems
    by RickyPontes
    4 Replies
    Last post by RickyPontes
      • I'm building a Virtual keyboard in Fox Pro. So far no problem, but now i'm having some problems with the cursor keys and delete key. This is the code I'm using for the A key click and it's works fine. DOEVENTS force keybd_event(65,0,0,0) keybd_event(65,0,2,0) DOEVENTS force but the delete key and cursors key it's not working. I'm using code 46 for the delete key and 37,38,39 a
  • impersonateloggedonuser and Getfil()
    by rknh_20
    7 Replies
    Last post by dni
      • Iam running VFP 9 with SP1 under windows 2k. In order to protect my database/table files on a network I have created a single user who has access to the folder where the files are contained. This is the only user with access to the folder. When an individual on the network runs the application the application logs on as that user and has access to the database files...the code goes like this....
  • dot matrix printers
    by jmom
    3 Replies
    Last post by Madix_t
      • Once again, I am asking about printing through terminal services. (Sorry!) At least one user has a dot matrix printer, he/she can print something out. The problem is the output is messed up on his paper. They described it like it was printing over and over on the same line.
  • dropdown list box
    by Hans L
    11 Replies
    Last post by Hans L
      • I read everywhere about the so called "dropdown list box", but, while I have searched long and hard, I cannot find any description of how to create such a beast. Kind of embarrasing, but ... Also, as a stopgap, I use a combo box to select indexes to list various sets of data in a grid, and I do not have anything in the ControlSource. I have 1 ¨C Value in RowSourceType and then six list it
  • VFP9 SP2 problem
    by 4legsgood
    4 Replies
    Last post by Vladimir Zografski
      • I've installed SP2 for VFP9 on a PC running XP SP2. Now, when I right-click a control on a form and take the Code option, instead of displaying the code for that control, it displays either the first (alphabetically) code for the form, or the most-recently viewed code, which is seldom the code for the selected control. Any ideas how to fix this
  • Trouble getting dates in Report
    by Anomaly
    7 Replies
    Last post by Naomi Nosonovsky
      • Hi, Im creating a report and I need it to print out the from and to dates that the user has selected to search by. Do I simply put it in as the report variables Or is it more complicated then that
  • VFP9 application in same network with email server & VOIPs
    by Daniel CW Tan
    10 Replies
    Last post by Daniel CW Tan
      • Hello All. I am currently having a VFP9 application shared in a network that also include VOIP telephony & email servers. Up to 30 users in all. The VFP9 "exe" file is only 3Mb and the database files totalling 5Mb. It seems that the VFP9 application runs awfully slow at times while the others runs fine. Could the VFP9 application the main reason why the slowness . Ho
  • Replate property
    by le tan duc
    2 Replies
    Last post by dni
      • in a form,I want to replate property (ex: caption,tooltiptext...) of all object (commandgroup,commandbuton,grid,toolbar... ) by string "new value" Help me . thanks
  • how do i convert VB Script Code into a VFP Code?
    by Madix_t
    6 Replies
    Last post by dni
      • Good day to the experts! I have here below a VB Script i found in Script Center which is a very useful tool in reducing time to configure a static IP for each computers in a network, especially when you have more than 10 computers in a network.(NOTE: this computer's IP was configured manually with a purpose) How could we convert this code into a VFP code strComputer = "."
  • how could i change the gateway and DNS
    by Madix_t
    1 Replies
    Last post by dni
      • hello good day to all experts how could i change the workstation's gateway, and its preferred & alternate DNS automatically from VFP, so that i don't have to open local network connection status for every workstation and change it manually. I have two service provider at my internet, and if one ISP bugsdown, i have to reconfigure the gateway, and DNS manually the LAN at a particular PC
  • VFPOLEDB Download broaken or other problems?
    by Stefan de Groot
    1 Replies
    Last post by Alex Feldstein
      • I trie to download the odbc driver for vfoxpro for a while now, but the link from the Microsoft Downloads site is broken for quite some time now. Is there a specific reason for it I need it to run queries to an Accountview database. Kind Regards, Stefan de Groot
  • ActiveX control with FoxPro
    by Khalid Jayoussi2
    11 Replies
    Last post by dni
      • I have an MFC ActiveX control with support for SimpleFrame. I added OLEMISC_SIMPLEFRAME for MiscStatus and call EnableSimpleFrame in the constructor. I used this control in MFC and Vb and it works fine. but when I used it in FOXPro, I get a problem with scroll bars. but if I comment out EnableSimpleFrame the scroll will work fine with Fox Pro.
  • How to Filter Records in a Grid
    by msw
    8 Replies
    Last post by MarciaAkins
      • I have a simple form with a Grid that displays my customer database. I would like to place a combo box at the top of this form and when I start typing in it the records would start filtering down. I Have an index created for Lastname and I can list the records but I can't figure out how to make the filter work as I start typing. Thanks for your help...Scott
  • Skip Command
    by Ahsan Amin
    9 Replies
    Last post by LeoLems
      • In a navigation form i am using skip command on a button but it's not working fine. When it comes to 2nd last recoed it does not proceed. There also some records in table marked as deleted. I am using Set deleted On on form's Init event. I have also clicked on button many times so that it could give eof error but it does not. Also record no. message on bottom of VFP's window is always same. It doe
  • field number
    by Mochalatte
    3 Replies
    Last post by Tamar E. Granor
      • Hello, How can I return the field number to a variable This sounds easy, but I can't figure out how to do it. For example, I want to write some code that says something like "look through columns 10 through 20 and if the value matches column 1 then return the column number of the match". Any help is greatly appreciated. Thanks!
  • New Grid Columns
    by dni
    9 Replies
    Last post by dni
      • I am running a form with a grid with 12 columns. It is working fine. At one moment in a click method I am adding more 8 columns . How can I do that new columns to have the same settings with old columns (header and textbox (font size,font,color,allignment...) I don't like to write 8 times settings for each properties ...
  • How to create a Word document?
    by Lightening
    10 Replies
    Last post by Lightening
      • I wish to convert a memo field into a Word format document. I searched around and found this: oWord=CreateObject("word.application") oWord.Documents.Open("c:\test.doc") oWord.ActiveDocument.Range.Start=0 oword.ActiveDocument.Range.End=0 oWord.ActiveDocument.Range.Text="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" oWord.Documents.Save() It works if the
  • Create New tables in existing DBC in specified directory or path
    by TechMate
    6 Replies
    Last post by CetinBasoz
      • I have never used Foxpro before until now. I am able to create a set of stored procedures to create two new tables from existing tables for reporting purposes in a DBC. I am using Visual FoxPro 9.0 for working. What I am trying to achieve: I want the client to execute a stored procedure which will create the two new tables in the same directory (or path where this database currently resides).
  • SELECT-SQL vs. SET RELATION
    by Ed W
    5 Replies
    Last post by Naomi Nosonovsky
      • This thread refers to the Speed with CALCULATE thread which was started on July 26th. I started a new thread because the original title is pretty far off base from what I've now determined the remaining problem to be. I'm working with VFP 6.0. Thanks to all for the ideas yesterday. I didn't realize that SELECT didn't always open the tables. I hate to think of how long it would have
  • LITTLE DOUBTS WITH DATE & TIME PICKER .....
    by Paramu
    4 Replies
    Last post by Paramu
      • Hi There, Thanks in Advance. Iam facing little error....Really I don't know the exact mistake...where I did... Iam getting the error like... OLE IDispatch exception code 0 from DTPicker: Invalid property value... ************************************************************* My requirement is to set the Todays-Date for DT-Picker..... My codings in the
  • Positioning Dbf file in form/List Box
    by Gary Demi
    4 Replies
    Last post by Gary Demi
      • I have a form with a listbox, setting listbox.rowtype=6 (fields) and listbox.rowsource=seqlc.anum,customer,date,type,picture,pictfile,pictdir (fields) from a single dbf The DBF has an index on anum. (SET ORDER TO TAG anum) anum is unique, but not consecutive. When I use the up & down arrows & page up/dn within the the list box it works fine. The list is displayed correctly ordered by anum.