Try to solve the Error 3828 when exporting data from a query to Excel
I have code exporting data from queries to Excel. All lines but one works. The last line gives the error 3828.
"Cannot reference a table with a multi-valued field using an IN clause that referers to another database"
The code line is like this:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "DeliveriesThisMonth", PathToEXTAB, True, "Deliveries"
But there is no multi-valued field in any of the tables.