Search results for query: *

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)

Thank you both for your replys. The ctr+c, etc commands are what we had been using as these are the standard Windows commands and they worked fine in VFP6. We are not running any framework nor was there any hardcoded programming. Now that we are running in VFP7, we have lost that functionality...

In our VFP6 application version we were able to cut and paste between textboxes, now in VFP7 we have lost that feature. Does anyone have any solutions.

We are experiencing a problem with the Memo table for a table in our DBC. We are using VFP7.0 now but the problem had just begun while still in VFP6. Each day the memo table for this particular table doubles in size each day. We have a nighttime process that is reindexing all tables (stonefield...

We are still having problems with character displays and error messages in some applications after converting from VFP6 to VFP7. I have not had any response to previous posts about the problem. I would be happy to send some screen shots as a Word.doc attachment to any of our Web Tech Experts...

Isn't anyone else in the VFP7 world having this problem with menu creation? I can't believe that we are the only ones having this problem or that there is no explanation available. I would be happy to send someone a word doc print screen of the problem. Thanks