L
Leighton.d
I have an Access form that allows a user to select a table or query, then
click a button that executes the following code that exports the selected
object to an Excel spreadsheet:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, Me.cboTables,
Get_Path & Me.cboTables, True
On 99.9999% of the computers this task is performed on, it works fine. On
one users systems, it displays the error "Run time error 3011; Microsoft Jet
database engine could not find object". If I try to export the table
manually by right-clicking the table and selecting "export", it displays the
error message "too many fields defined". There's only five fields in the
table.
Any suggestions?
Thanks!
click a button that executes the following code that exports the selected
object to an Excel spreadsheet:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, Me.cboTables,
Get_Path & Me.cboTables, True
On 99.9999% of the computers this task is performed on, it works fine. On
one users systems, it displays the error "Run time error 3011; Microsoft Jet
database engine could not find object". If I try to export the table
manually by right-clicking the table and selecting "export", it displays the
error message "too many fields defined". There's only five fields in the
table.
Any suggestions?
Thanks!