MUltiple Queries

[Guest]

Before I create a report I need six different queries to run. How do I get
all six queries to run without haveing the "yes / no" promts poping up? I
have already unchecked the boxes in the "edit/find" in the options.

 

[Guest]

If using a macro to run all 6 queries Set Warnings to No at the beginning
Action of the macro and please don't forget to Set Warnings to On after all 6
queries run.

 

[Guest]

That worked but how do I keep the data sheets from opening? After I run the
queries I have it open a report that displays data from all six queries. i
only need to see the report and not the queries.

 

[John Spencer]

Are these ACTION Queries? That is do they add, delete, or modify records in
tables?

If they aren't action queries, then there is no reason to run them before
you open a report. The report should execute any queries it needs to run
and do it in the background.