Access 2007 export Macros are deleting sql query

[dhender09]

Hi,

This issue "magically" appeared in the last few days.

I have an extensive Access DB designed for non-Accessers. To make their
lives easier, I developed macros to export queries to excel for them to
create charts. The data will export initially, but somehow the sql statement
disappears, i.e. is completely wiped, from the query being exported.

I have changed the format to export to, stepped through the macro, and still
have no good explanation as to why this is occurring. Any thoughts?

Thank you
D

 

[jurgsw]

Same issue

Has anybody got an idea what's happening. The queries simply lose their sql statements when a macro does an outputto excel using the query?

This also happens in Access 2010...

 

[bkewan]

Did anyone find a resolution to this issue? I'm having the same problem in Access 2010.