mamradzelvy
Member
- Local time
- Today, 22:50
- Joined
- Apr 14, 2020
- Messages
- 145
Hello,
I came across a strange issue while working on my Excel Exports.
I've got a query I'm working on at the moment:
and my code, that runs the query being:
So now my excel file is being named after the query name and whenever i try to export into a location where i've exported to before, it gives me a prompt asking if i want to overwrite the file that already exists, on selecting yes, access gives me an error saying that "Query should have at least one destination field " this doesn't happen every time, and i didn't yet manage to find out what the exact criteria for this to occur is...
Whenever this happens, the code in my Query changes to
I came across a strange issue while working on my Excel Exports.
I've got a query I'm working on at the moment:
Code:
SELECT Tabule1.TabKlient, Tabule1.TabOsoba, Tabule1.TabItem, Tabule1.TabQty, Tabule1.TabNote, Tabule1.TabAddedBy, Tabule1.TabDate, Tabule1.TabStatus, Tabule1.ID
FROM Tabule1
WHERE (((Tabule1.TabKlient)=[Formuláře]![formExportExcel]![xKlientSelection])) OR ((([Formuláře]![formExportExcel]![xKlientSelection]) Is Null));
and my code, that runs the query being:
Code:
DoCmd.OutputTo acOutputQuery, "dotaz1", acFormatXLSX, , True
So now my excel file is being named after the query name and whenever i try to export into a location where i've exported to before, it gives me a prompt asking if i want to overwrite the file that already exists, on selecting yes, access gives me an error saying that "Query should have at least one destination field " this doesn't happen every time, and i didn't yet manage to find out what the exact criteria for this to occur is...
Whenever this happens, the code in my Query changes to
SELECT;
Last edited: