Access 2007 export Macros are deleting sql query


D

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
 
Joined
Mar 20, 2012
Messages
1
Reaction score
0
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...
 
Joined
Jun 20, 2012
Messages
1
Reaction score
0
Did anyone find a resolution to this issue? I'm having the same problem in Access 2010.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top