keeping queries behind a report from opening

[magick]

I have a report that is based on a series of queries running from a macro.
Since i have been using Access 2007, the queries are suddenly popping up as
the macro runs, behind the report preview. the user must close the report,
then close the queries as well. didn't happen in 2003, and still doesn't
even in 2007 with the reports that were created in 2003. Must be something
very simple that i cannot find.

 

[Jeff Boyce]

Right off the top of my head, I'm guessing that your macro runs some of
those queries, and that the macro is being run.

I have a fair number of reports, each of which is based on a query (or in
some instances, on the last query in a "chain" of queries), and I've never
had to close the queries after closing the report ... they just aren't
opened.

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[magick]

yes, the macro runs the queries. In 2003, they didn't pop up as the macro
ran - only the report preview which was the last step in the macro. can't
figure out what the difference is in 2007.

 

[Jeff Boyce]

Have you tried basing the report solely on the last query in the chain
(rather than on the macro)?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.