Search results for query: *

If you're using automation to drive Excel from VFP then it's Excel saving the file, not VFP, which is why SET SAFETY has no bearing on the matter. What you probably want to do is write some VFP code to detect if the destination file already exists and if so then to delete it before telling Excel...

Steve, There is a known bug when you launch a report to preview while a grid has focus, then print the report. See "Printing or previewing Report Form results in incorrect data" at http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q185628. One easy workaround is to take the focus off...

The newly added array elements will have initial values of logical False, but the original array element values should not be disturbed when the array is redimensioned. The following code does what I think you're describing and leaves the first set of array elements as is: CREATE TABLE...

You're welcome, Bart. Thanks to you for continuing to provide information until we figured this out. -Rick

Yes, that's correct. Setting the path to the location of the .h file in the prg has no effect on the compiler because the program is compiled before the SET PATH statement in the prg is run. What matters is that the path includes the location of the .h file at compile time, or alternatively that...

OK, now we're getting somewhere. < smile > Here's what's happening: When you select main.prg in the project manager and click the Run button, VFP silently compiles the program but cannot find the #include file if it's not along the current path. When this happens VFP creates an error file with...

Bart, We have to infer a couple of things from what you've posetd. It sounds like start.prg is the main program in an application, and that when you say "the exe-version never complains" you're talking about running the EXE generated by building the project. This makes sense, because building...

Help me understand what you meant when you said In what program did you place this code, and does that program have #INCLUDE myIncludeFile.h in it?

From what you've said, I assume you've defined ccMyConstantVar in myIncludeFile.h with something like #DEFINE ccMyConstantVar "foo" If that's true, then you're getting that error message because ccMyConstantVar is not a variable, it's a defined constant. Defined constants are preprocessor...

Lee, I may have misunderstood your original post, but I thought what you were trying to accomplish was to create an empty spreadsheet with a specific name in a specific location. The low-level commands I posted (FCREATE and FCLOSE) create a 0-byte file with a .XLS file name extension. When...

It doesn't, but what is the point of deleting the first row of a newly created worksheet? There is no data in those cells, and even after deleting the row you still have 65,536 rows in the worksheet. Of course, if deleting the first row is a requirement for reasons I don't understand then of...

Lee, If all you want to do is create a file with a given name and an "xls" extension, you don't need to use Excel at all. Given the time it takes to instantiate the Excel appliation object, it would be faster just to use low level file functions to create and then close the file, like this...

Try form2.pageframe1.ActivePage = 2

> Using WWIPStuff... if the recipient has a hyphen in their > email address, the program sending the mail just hangs - > when you issue the sendmail() command. I've seen the WWIPStuff::SendMail() hang if the cRecipient string (the list of e-mail addresses) is not correctly formed. If the...

> You are using profesiional printers? Mostly my clients and I use HP LaserJet printers, so yes, I guess you would call them professional-grade printers. > I'm afraid that the now-a-days lowcost HP printers cause the error. Maybe so, but one other thing to check is do you have...

Check the properties of your field(s) in the report writer and be sure 'Object Position' is not set to Float and also that 'Stretch with overflow' is unmarked. Also, is there anything in the page header that could stretch with overflow and push the detail down? I doubt the paper is stretching...

Let's assume the value you're working with is a character data type in VFP and is stored in a variable named lcx. Then if you need a numeric result you can simply do VAL( lcx) / 1000 If you need a character string as the result you can do STR( VAL(lcx)/1000, 10, 3) where 10 is an arbitrary...

BROWSE NOMENU

One way is to create a VFP form for this purpose. Add a property to hold the text of the file you want to display, let's call that property cTextString. Place an editbox on the form and set its ControlSource to thisform.cTextString. Use FILETOSTR to load the value of thisform.cTextString from...

>I'm trying to get the selected date value from the MonthView control and get a C000005 error whenever I use the keypress event to try to store the value of the control in a public variable.... Not sure what you're tyring to do in the Keypress event, but you shouldn't need to do anything...