Recent content by dakotafox

In all of our Excel automation programs we use the following statements and have no problems *---start Excel oExcel=CreateObject("Excel.Application") *----end Excel oExcel.quit Release oExcel

Here was my solution to the problem because we produce these type of reports on a monthly basis. *---Unfortunately excel spreadsheets handle only up to about 65,000 records on *---a single spreadsheet thus we need to create multiple worksheets for them if y13Excel count...

I am working with EXCEL and Visual Foxpro, creating excel worksheets from Customer data. The current worksheet reports show data and multiple subtotals of data on each worksheet. We would like to programically using the group feature. (i.e., like manual selection of Data,Group and...

Does anyone know if there is anyway to increase the limit of the copy to command when trying to copy a data set of records to EXCEL. If the table size is greater than 16,384 records, the remaining records are just dropped with no error message from Foxpro or Excel. (i.e. 25000 records in the...

My company is attempting to place our VFP 7 projects into VSS but we are having major difficulty. We have four developers working on the various projects and need to have them available in development, testing for QC and production. The system is a conversion from Fox2.6 windows,into vfp6 and...

Have just solved this formula, so thought that I would pass it on anyway. formula=IIF({crystal_wcp.discondate}=#12/30/1899#, " " ,totext({crystal_wcp.discondate})) This will work perfectly.

Because of the empty date value being interpreted at 12/30/1899 when creating a recordset from a VFP7 table, I have been working with this workaround but not successful. What am I missing in the statements? The report field is printing as blanks for all dates, and does not put in the current...

As a new user of Crystal Reports I am experiencing problems with date fields when working with a VFP7 table. If the date field contains a valid date value no problem, but if date field is empty it is reported/displayed as 12/30/1899 and then when the report is exported to Excel the same date...

Thank you for the suggestion, but the checkbox is NOT checked in either option. As a test I checked the box and ran the report again and got the same results.

I am hoping some of you sharp VFP people have Crystal Reports experience. As a new user of Crystal Reports I am experiencing problems with date fields when working with a VFP7 table. If the date field contains a valid date value no problem, but if date field is empty it is reported/displayed as...

As a new user of Crystal Reports I am experiencing problems with date fields when working with a VFP7 table. If the date field contains a valid date value no problem, but if date field is empty it is reported/displayed as 12/30/1899 and then when the report is exported to Excel the same date...

oExcel=CreateObject("Excel.Application") *---show User the file oExcel.visible=.T. *----turn off the warning message about file exists oExcel.DisplayAlerts=.f. *---------------------------------------------------- *---now open the template oExcel.Workbooks.Open(mtmplfile) *---now save...

The following command is used is our application, where v1 is the variable containing the unique id. cSQL = "SELECT * from tblAMC2_practice WHERE sql_d_pk=&v1" SQLResult= SQLExec(hdlpline,cSQL) The value of SQLResult is 1, whether records were found or not. How can I identify whether...

Our problem with the unique index violation error is occuring after a record is deleted from a table and a corrected record is trying to be inserted. The main index keys were not changed just some of the other field values, but how do we get Fox CDX to ignore the existence of the deleted record...

Thank for the reply Dave. Our application, cut and paste, will work in development also, and in an EXE run at a development station. But if the exe in placed on the network and run with the run time libraries at stations not having foxpro installed, the the problem exits (no cut and paste)