Search results for query: *

I am copying and pasting a formula into column I rows 4 thru predetermined count of DBF records. The constants are : #DEFINE xlSum -4157 #DEFINE xlFillDefault 0 #DEFINE xlAutoFill 4 #DEFINE xlPasteFormulas -4123 #DEFINE xlPasteValues -4163 #DEFINE xlNone -4142...

I have spent hours and hours trying it get this to work. searching here and on the Internet. I have found the same code over and over but it just doesn't work. Here goes: Column A in Excel table is Country Column G is sales for Country by customer (Actually several columns need to be...

We are thinking of upgrading to excel 2007. I often import excel spread sheets programmatically using VFP (6.0). IMPORT FROM (mfilename) XL8 SHEET I also create Excel spread sheets programmatically. COPY TO filename.xls XLS or FOX2X for those databases over 16,385 records. I also do an...

Sometimes I add a passwrod to an Excel table created in my Fox Pro code using these lines of code. WITH oExcel . . .(some code removed) . .ActiveWorkbook.Password = "XXX" .ActiveWindow.CLOSE(xlSaveChanges) .APPLICATION.QUIT ENDWITH I want to use a password...

I hope this is the correct forum to use. I don't see any forum for errors. I often run code to gather sales data month by month appending into a common dbf for many months which results in huge databases. 5 or 6 million records maybe 10 or 15 fields. Once I get the data into a common dbf I pull...

How do I get this to work? I have two list boxes list1 and list2. I have a drop down list in list2 and I am populating a display list of items in LIST1 as the user clicks on the drop down list in list2: (in the click procedure of list2) WITH THISFORM .WINDOWSTATE = 0...

Simple report I open a dbf USE DBF IN 0 SHARED ORDER emp_no then I open a REPORT REPORT FORM REPORT.frx PREVIEW This report is opened in a FORM. The form opens max screen using ZOOM WINDOW SCREEN MAX in the INT procedure of the parent form. The report opens full screen as I want it to for all...

I am using an ActiveX (OLE as us old f##ts know it) control on a form in VFP 6.0 The command line will execute this: C:\WINDOWS\explorer.exe but when W/Explorer opens I want it to go to a preset path. Am I on the right track that I need to add something at the end of C:\WINDOWS\explorer.exe...

Fox Pro 6.0 I used the Fox Pro form wizard to create a way to view and edit a table. I am finding out that wasn't such a good idea. I should have built my own gui. Each fields data is displayed in a text box. Each text box has a defined length. My question is concerning a numeric field. When...

I have one tab in a multi tab spreadsheet where I cannot get the freeze panes to work. I click on the cell to freeze rows and columns and it just acts like I did nothing? All the other tabs work fine with freeze panes. Anyone ever run into this? John O'D

An OLE object stops working (can't find the object) when we update a server, copy the files from an old server to a new server. In VFP6.0 (I think the entire 6.0 studio) when a file is named with a long name like this, "Surplus Inventory Summary by Division 3 Months Continuous Stock to dbf...

Anyone have this problem? When I first boot up my puter and the start VFP it takes sometimes over 2 minutes for the VFP application to open up. Once it's open for the first time, used and closed, it opens in seconds thereafter, of course until I reboot my puter again. Running Windows 2000...

I open MS Outlook via Fox Pro 6.0 to send hyperlinks to users of reports I create. Something like this: Ob = create([Outlook.Application]) It = Ob.Createitem(0) It.To = cAddresTo It.Subject = cSubject It.Body = cBody This worked fine until I got myself a nice new...

Has anyone run into this error? I am creating and holding two tables. The first table runs ok and the second table appears to get created (lines has a value) but then it crashes. There is no join on this second table. 0 NUMBER OF RECORDS IN TABLE= 865 LINES= 865 0 HOLDING... 0...

Does anyone know where I can find a reference document for formatting an excel document within Fox Pro. I have been trying to figure out how to total an Excel table at the end of a column not at line 65000 or what ever the limit is. Something similar to this: #DEFINE True .T. #DEFINE False...