runtime error 3011 Microsoft Access could not find the Object (1 Viewer)

[Oludare]

Hello All,

Could you please help.
I receive the error message runtime error 3011 Microsoft Access could not find the Object "stgHold" make sure the object exist and that you spell its name and path correctly. Please find below my code.

The Error Line: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, StrTableName, StrFileFormat & ".xls", True

full code is attached.

' Export Stg Reissue Payments Data to xls file.

Error Line: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, StrTableName, StrFileFormat & ".xls", True

 

[arnelgp]

the question is, do you have that table?
transferspreadsheet only applies to ms a table/query and not ado recordset.

 

[Oludare]

Hello Arnelgp.
The table exist as a linked table in Access. IT is held in a variable strTableName in the script.

 

[Isaac]

\\Dv0mssql07\gipt_dev07d\Bordereau\cri_"& Forms!frmReissuePayments.cboBordNo doesn't exist.

Debug.

 

[Oludare]

Thank you all. Issue resolved by a solution design change. No longer required.