Access 2007 export Macros are deleting sql query

Discussion in 'Access Macros' started by dhender09, Oct 20, 2008.

  1. dhender09

    dhender09 Guest


    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
    dhender09, Oct 20, 2008
    1. Advertisements

  2. dhender09


    Mar 20, 2012
    Likes Received:
    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...
    jurgsw, Mar 20, 2012
    1. Advertisements

  3. dhender09


    Jun 20, 2012
    Likes Received:
    Did anyone find a resolution to this issue? I'm having the same problem in Access 2010.
    bkewan, Jun 20, 2012
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.