Full Version: Queries disappear!
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
JoeCarter
Hi,

I have a number of fairly straightforward queries that DO work. Two of these are used to export data to Excel spreadsheets. For a while, they will work fine until without warning, the query code is randomly erased. When I try to execute the command that exports the data to the spreadsheet, I get a "Query must have at least one destination field".

Any ideas? Maybe this is a bug or there is something somewhere that is causing my queries to be erased?

Many thanks.
strive4peace
perhaps somewhere you are doing
DoCmd.DeleteObject
without specifying what to delete and the active object is not what you think...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.