Answer Questions

• Chris Fink System resolution

  Hi. How can I find out what the system resolution is, and how can I change it via FoxPro Thanks Why do you want to change the resolution despite what everyone here has said Tamar Thanks for your advices but I will not change my mind. There is a plenty of textboxes, some listboxes. You mean the right way how to do that is to resize the form I tried, it works but if I want to run this form on 640X480 I have to degrease the font size of all of the controls some to value of 6. It is really nice to read text like this size. Please do not solve why to do that, if anybody knows how to do that, please disrcibe me it, if not do not give me an advice like "The "c ...Show All

• SCADirector COM Automation with Excel

  Here's my problem...I have the program writing to Excel and then opening just fine. What I want it to do though is save the spreadsheet in a newer version (I used "copy to 'filename.xls' type xl5") without having to actually see a prompt from Excel. The reason I'm doing this is for workbook consolodation (I'm writing to several workbooks and want to put them together). You can read more about it in my previous post here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=782622&SiteID=1 One of the fast ones: clear Clear All * Create a test cursor Create Cursor testcursor (Rcno i,cType c(10), nType i, dType d) Rand(-1) For ix = 1 To 200000 && Create 200000 recs cursor Insert Into testcursor Values ; (Rec ...Show All

• colindyck VFP9 ReportListner and Excel

  Hi All, Has anyone managed to turn the xml output generated by vfp9's reportlistner into a cursor I would like to then turn the cursor into an excel worksheet adding all the formating and formulae for subtotals etc etc But xmtocursor() generates "XML parse error:field name is invalid or duplicate...." Help please Mathias I have not used xmltocursor, but if I wanted to turn a cursor into an excel spreadsheet I would use: EXPORT TO filename TYPE xls Then you can open it with Excel. Your suggestion SuperFox is what would be the final piece to the jigsaw. The idea is use the reporting capabilities in the reportlistner first. The output is user driven and so t ...Show All

• RayClark096 form in formset are displsayed just once

  Hello, I use vfp 6.0 and win xp as o/s. I have a fornset with a main form that contains push buttons to show another subforms in the same formset. My client has win 98. when i installed my program on his computer, and clik a push button to display a sub form that works fine just for the first time. if i try it next time it wont work. I have used show and hide methods to show and hide the subforms not the release method. pl help. -ravindra Looks like when you first click, you tell the second form to hide. When you want to show it again, it is already hidden. Make sure that you show the second form by changing its hidden status when you want to toggle it. ...Show All

• gmeadows94410 Set printer to NAME

  Hi; I am using "Set printer to NAME getprinter()" to select a printer. I also have tried "Set printer to name \\somePC\someprinter" In both cases an error is produced. "Error accessing print spooler" The network is a win2003 server with both XP pro and Win98 stations. The printer is on a win98 station. I was wondering if I should use "set printer to \\somePc\somePrinter" without the NAME clause Thanks. Here's what I have found: "Name" requires that the network printer will be added as a printer on the local machine. set printer to \\machine\printer however doesn't require one to be installed. Nowhere in the V ...Show All

• Dany V Foxpro Power!

  Hai Everybody, I jus wanted to have some sort of opinion poll from u people. IS FOXPRO ONE OF THE POWERFUL TOOL AVAILABLE NOW In my opinion its really powerful and very much useful even now i am very much found of it.... Medical apps! I should have guessed that from your nickname:) I have done (I'm an MD) medical apps in the past. VFP is just great for those kinds of applications. However, anytime if you ever think of a distributed version of your application (which might be great for an hospital with mobile workers) then I strongly suggest to look into .Net and particularly IdeaBlade's Devforce framework. I'm a solo podiatrist-programmer who has used VFP since its implementation in 1992 or so. L ...Show All

• FA65 VFP7 COM+ object and ASP.Net 2.0 on IIS6 - Interop issue

  Hi,I wonder has anyone managed to get his/her VFP7 COM+ object run on ASP.Net 2.0 on IIS6 1. I compiled the object using MTDLL and deployed into my SBS2003. 2. I think this shouldn't be a security problem as I didn't manage to get it run even I have set the IIS6 worker to Local System. 3. The COM+ object has actually initialised. Codes in INIT method has actually run (I put CREATE TABLE ..... in the INIT method, and check if the table is created later), but when come to calling a method from ASP.Net, I hit an error. 4. Tried many possibilities, but no luck. I have also followed the example from Craig, got the same issue. 5. The same VFP7 class (but complied as EXE and configured as DCOM) was running fine on IIS5 ASP2.0 on Windows 2000 Ser ...Show All

• airwalker2000 Disabling "Open Dialog Box"

  Hi All, We have lots of previously written programs. We have an automated system calls them 24/7. Occasionally they are crashing or bringing up a table open window and stop running. I have control over crashes. But "Open" window needs human intervention, so I don't know if it's working or waiting for an entry. Here is an example: procedure myProgram * Codes Insert into myTable (myField) values ("myValue") * more codes Return If myTable doesn't exist or for some reason we loose the connection with the network drive, it can't find the table and opens up a "Open" window to choose a table to use. Since I have bunch of programs, it's not easy to go and modify all of them one by one. Is there any way to prevent o ...Show All

• milkshake naming a file with timestamp

  hi, i want to export to excel or export a text file including timestamp in the name. plz help. Another way: use myTable copy to (alias()+'_'+ttoc(datetime(),1)+'.csv') type csv USE mytable * prepare or filter or create a cursor from a query or view with the records to export lcFilename = "MyFile_"+Strtran(Strtran(TTOC(DATETIME())," ","_"),":","") COPY TO (lcFilename) TYPE XL5 ...Show All

• SPECIALK_BC help? textbox

  Hi I am new to vfp and my syntax knowledge is not very good actually its quite bad. I was wondering. How do you recieve user's input through a keyboard in a textbox (cmdtxtbox) and then use that input and save it as a variable (userInput) Thanx for the help Bobby thanx for the help i will give that a go. Use the controlsource property on the text box to the same name as your variable, then use REPLACE() to update your table. Make sure you have defined the variable with your setup routine. if you have a textbox named, for example, text1 you will find the "user's input" in: thisform.text1.Value as variable. Bobby110uk wrote: ...Show All

• Shimi Tavori Change default printer works only once

  This one is weird... I use the followin function to change my default printer: FUNCTION SetaImpDefa(imp,muda) Declare long WriteProfileString in "kernel32" ; string lpszSection, string lpszKeyName, string lpszString Declare long SendMessage in "user32" ; long hwnd, long wMSg, long wParam, String lParam if muda HWND_BROADCAST = -1 WM_WININICHANGE = 26 endif printer_name = imp printer_buffer = space(200) * len_ret = GetProfileString("PrinterPorts", printer_name, "", ; @printer_buffer, Len(printer_buffer)) printer_buffer = left(printer_buffer,len_ret) * printer_driver = left(printer_buffer,at(',',printer_buffer)-1) printer_buffer = substr(printer_buffer,at(',',printer_buffer)+1) * printer_port = left(printer_buffer,at(',',printer_ ...Show All

• .net sukbir Pass by reference?

  I am using the code below, the method RunTransaction should be filling the objects varReply and StrErrorInfo with data (they are hashable objects). But its not working. I think its because its not passing the objects by reference. I know everything else is working ok from the log file. I tried SET UDFPARMS TO REFERENCE. Nothing. Thanks Sam. oClient = CreateObject( "CyberSourceWS.Client") varReply=CreateObject("CyberSourceWS.Hashtable") strErrorInfo=CreateObject("CyberSourceWS.Hashtable" ) oProxy = CreateObject("CyberSourceWS.ProxyConfig") oLogger = CreateObject("CyberSourceWS.Logger") IF FILE("C:\FOX\ccLOG.TXT") DELE ...Show All

• Emadkb COntroling objects

  I have 2 forms, Form1 and Form2. In Form1 I have a grid and a button, when I click the button I call Form2. What I want to do is to control the properties and methods of the grid inside Form1 from Form2. How can I do this So, having coded what you said before, if I wanted to change the RecordSource property in the grid inside Form1 from Form2 the only remaining thing for me to do is to write a line like the following Thisform.oForm.Gridinform1.RecordSource="anothersource" Thanks to all of you. Yes, but: What I have learned here recently is that changing recordsource for a grid either at de ...Show All

• j_o_h_a_n_n_e_s How can I get the ole_handle from an bmp image file?

  In my application I need to call the method third party control, the method need pass in ole_handle of image file . I try to use h1=fopen("c:\test") and pass in h1. it did't work. In VB6 I can pass in img1.picture.handle and it work fine. Have Anybody has any idea THanks, CetinBasoz, Thank you very much . It work fine. loadpicture() might help. ...Show All

• Dawa Tsering Foxpro7 crashing with "fatal error exception code=c0000005 ..."

  Hi I have a tricky issue in my VFP7 application. At least tricky for me.  The application is crashing with fatal error C0000005. Sometimes I see a message like this one in the eventlog: "Faulting application <appname>.exe, version 1.4.82.0, faulting module ntdll.dll, version 5.1.2600.2180, fault address 0x00010f29.". Sometimes the application just hangs. I also see the Windows error "The instruction at "0x...." referenced memory at "0x.....". The memory could not be "read"", and then the application is closed, of cource. The error does only appear in situations where I print, but it does not occur in an exact pattern, or when I pass a particular code line. I use a third party dll called foxpp.dll ( ...Show All