Search results for query: *

Thanks JRB-Bldr, I just changed the "" to 0 and it worked fine. Before: IF(RC[-2]=0,"","=RC[-1]/RC[-2]") After: IF(RC[-2]=0,0,"=RC[-1]/RC[-2]") Thanks again! John O'D

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...

Never mind, I am an idiot. I have been using &array instead of @array. :-(

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...

Hi guys, I don't have it yet. My boss wants me to do some testing on it before we get it for everyone in our department. I would just as well keep using the older versions. I create data for the financial analysis people. I often teeter on 65,500 records. If I need to send more than that I...

Thanks Mike L and Mike G, I understand what you are talking about now. I use that all the time in my programming. For some reason I didn't associate this process with the term you used AUTOMATION. Thannks for the info! John O'D

Thanks Mike, What do you mean: "You can, of course, also use Automation to import Excel data"? I use the IMPORT in a VFP program. Is that what you mean? Maybe I will learn something new here. John O'D

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...

Sorry it should say it DOESN'T add a passowrd. John O'D

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...

Woo Hoo! Thanks BongoB1 that worked! John O'D Thanks everyone else for your input also.

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...

Deleting the two files did nothing. When you run the exe the two file are recreated again of course with just the data from that last session. Do you think it could have anything to do with the setting of the screen resoultion? This user has it set 1280 x 1024 John O'D

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...

Thanks baltman and Mike! I appreciate your help. John O'D

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...

Thanks Pamela, I will look into that book. Mike, Yes, I tried the SET CONFIRM ON and it worked great. Trouble is now if you back space it will jump into the textbox before the one you are in. Believe me the user will do this! I am trying the GEt and Lost Focus thing now. It seems to be working...

Pamela, One of the problems is the input mask. She wants to see the commas to make it easier to read long numbers i.e. 600,000 If you don't know you need to place the cursor in a particular position to edit (backspace or delete) you get unwanted results. So if you place the cursor as you enter...

Thanks Mike, That's what this is. A quick and dirty way to display a table for my boss. She needs to edit it every twice in a while. It also runs in a secure environment where all the data tables are encrypted. I have found some weird things happening. thought maybe this was one of them.