S
Syd
I am working on an application developed in Access 2000 as an ADP Project. Naturally it contains views and Stored Procedures. One of the queries called: "qryViewByMachineReworkedEmailData" is to be exported to an Excel97/2000/2002 format. However, the line of code that should do tthe exporting to excel is generating a strange error. The error reads as follows: Run Time Error 7874: can't find (database' name) the object "qryViewByMachineReworkedEmailData"
Private Sub cmdExportToExcel_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "qryViewByMachineReworkedEmailData", "MachineParts.XLS", True
End Sub
Since this is an Access 2000 project application (Now running under Access XP), are there any issues that can possibly be causing this error? What is the fix? Is the code syntax wrong, if it is, can someone assist in correcting it.
I am in a bind and pressed for time. I am hoping that this time it will post correctly!
Thanks in advance for the assistance.
Private Sub cmdExportToExcel_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "qryViewByMachineReworkedEmailData", "MachineParts.XLS", True
End Sub
Since this is an Access 2000 project application (Now running under Access XP), are there any issues that can possibly be causing this error? What is the fix? Is the code syntax wrong, if it is, can someone assist in correcting it.
I am in a bind and pressed for time. I am hoping that this time it will post correctly!
Thanks in advance for the assistance.