Answer Questions

• Dougal How to change Default FONTS in Forms, Menus, status bar, title bar and so on...??

  Hi, Could somebody tell me, how to change default fonts of Menus, Status bar, titke bar and so on... Right now I can see everything in Arial but I need to use different font. Thanks Hi, You can set the StatusBar's font from it's Font property. myStatusBar.Font = new Font(...) As for Menu and TitleBar, unless you provide OwnerDrawing, these controls will use the default settings of System Display (Start->Settings->Control ...Show All

• Euqil Data Environment

  Is there any way when i drag fields from the data environment to a form that they can be comboxes insted of text boxes without manually changing them Hi Crossow, Try multi-selecting the fields in the Data Environment and then right-click and drag. When you get to the form choose "Create Other Control Here" and navigate to your class library that has the control you want to use. I don't see a way to choose a ...Show All

• Me Myself and I pulling data from one field and making a new column out of it

  Hi all!!! I have two fields, work_id and sp_id. All sp_id's are related to the work_id's ie. work_id sp_id 1 000 3 000 3 111 5 111 9 000 9 111 i need the data to be listed by the work_id, then in another colum have it state whether it is one sp_id, the other sp_id or both sp_id work_id sp_id 1 000 3 both 5 111 9 both any insight life is short ...Show All

• Etumnamboa report temp file not found

  I need to create a simple report, nothing fancy. Just to preview some memo fields. This is the code I use. lcFile = "C:\VFP_Projects\Reports\MyReport.FRX" SET DIRECTORY TO "C:\VFP_Projects\TEMPORARYFILES\" CREATE REPORT (lcFile) FROM (ALIAS()) FIELDS memo1 The second line (set directory to) should be explained. I get an error that a temp file c:\\VFP_Projects\Data\...\000035e10062.tmp no found. Options are "Loca ...Show All

• netomin report export to excel differs from print preview and print

  When using Visual Foxpro 8, I notice that my subtotals based on 2 report variables that calculate sums per group in the 4th data grouping are continuing to accumulate instead of resetting after each group when I export to excel but appear fine when I do a print or print preview.  I tried deleting and re-adding the grouping only to get the same result.  Strangely, I also notice some of my text labels have also shifted over to the r ...Show All

• adisingh RSA Public/Private Key Encryption in VFP 9.0

  Hi, I need to be able to decrypt data pulled from a MySQL table encrypted with RSA public/private key encryption within a FoxPro application.  I am currently using the FoxPro Foundation Class known as _cryptapi as a wrapper to the CryptoAPI interface.  The problem I'm having is that I can't seem to figure out how to decrypt a RSA encrypted string of data.  I know that the _cryptapi class provided by Microsoft uses the Microsoft B ...Show All

• Ranbla =SYS(1037) on VFP90 no longer allows printer changes

  Can anyone tell me how to work around the changes in SYS(1037)   I used to call this with =SYS(1037) before printing in a batch (checks and invoices) and it no longer allows my customers to change the printer in VFP90 (no 'apply' button).  The 'prompt' option in REPORT FORM works just perfect too, but I don't want to call it in a loop (too repetative.)  Any ideas Thanks Using the 80 style report output, you can chain repor ...Show All

• Joey Bradshaw Visual Foxpro tables locked by aspnet_wp.exe process

  Hi! I'm currently using Visual Foxpro 9.0, .NET Framework 1.1, Visual Studio 2003 (VB) for web development. Everything's fine except this little 'quirk'. When i'm doing some testing, and try to open a table with VFP, i have the following message :File access is denied .... with the path of the table. The first solution i found (not very practical in a running environment) is to run a cmd-line and type iisreset to release any ...Show All

• RamiHajbi Call EXE problem

  I have a foxpro 2.5 (for Windows) .fxp which call a .exe (lets say "exe A", compiled from VFP 6.0). "exe A" will in turn call another .exe (lets say "exe B" compiled from VPF6.0). "exe B" will in turn call another .exe (lets say "exe C" compiled from VPF6.0) All the foxpro programs and VFP .exe are commonly used by multi-users (~60). fp2.5 fxp -> vfp6.0 exe -> vfp 6.0 exe -> vfp 6.0 ...Show All

• mwrisner Registering a Visual FoxPro driver in SQL

  Hi... Not sure if this is the right place but we have a problem registering a Visual Foxpro driver in SQL. The driver does not appear on the initial drop down list and so we have added it manually using regsvr32. All seems fine until we try to access the server when we get error 7403 Could not locate registry entry for OLE DB provider 'VFPOLEDB' Any ideas or advice gratefully received... Hope I have all the details, but it is happening ...Show All

• gdwinslow Need help on a small open table code

  Hi, I m trying to make a general opentable function that I will use with all my apps in the future. Now I need someone to explain to me a few things to see things more clear. Here is my code: function OPENTABLE(TABLENAME)  LOCAL TABLETOOPEN *Ok this is just a full path I make for the dbf file. I do not know if it the right way.what it gives is  eg. c:\program files\my app\data\mytable.dbf  TABLETOOPEN=TOSTRING(checkpathf ...Show All

• ErikF Foxisapi permissions issue (I think)

  Windows Server 2003 IIS 6 VFP6.0 SP5 Latest copy of foxisapi.dll http://localhost/common/foxisapi.dll/STATUS displays correctly I have a testServer method that just returns a string and it doesn't work, and the COM server does not load. http://localhost/common/foxisapi.dll/myServer.class.testServer returns "The page cannot be displayed" Web site is running ok. Everyone, IUSR_ & IWAM_ are set for default launch & access per ...Show All

• c0d3r Cancel Button Does not work--A known bug?

  I have no idea if it is a known bug. The important fact for me is that it is a bug. It occurs in _VFP.StartMode = 4 as well as in interactive session (_VFP.StartMode = 0). It caused me to lose numerous error records before I realized what was going on. In exe environment when one error follows another there is no way to quit because the Cancel button does not do what it is supposed to be doing. You crush the system and no records are saved of ...Show All

• Derwood Table in Grid

  Dear Experts I have a listbox and a grid on form. LIstbox has table names as CLOSE DATABASE ALLCTABLEINFO =  "csr" + SYS(2015) CREATE TABLE CTABLEINFO (SNO N(3),CNAME C(20), NFIELDS N(2), NRECS N(5), NSIZE N(6), DDATE D, CTIME C(10)) MYDATADIR="d:\gin2006\TABLES" SET EXCLUSIVE ON LOCAL AFILES, NCOUNT, I DIMENSION AFILES(1,1) NCOUNT = ADIR(AFILES,MYDATADIR+"\"+"*.DBF") =ASORT(AFILES,1) I=1 FOR I = 1 TO NCOUNT  SELECT 0  USE MYDA ...Show All

• Game Programmer COM server problem

  I have a VFP6 project that when compiled worked great as a DLL lookup on an included table. As I no longer have access to VFP6 and the table needed updating, I tried to test out VFP9 with this project. It builds to the DLL with no errors but when I tried to register it, I got the dreaded message" DllRegisterServer in ....failed. Return code was: 0x80004005". I used Dependency Walker to profile this dll and got the following results: ...Show All