MUltiple Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patrick - 12 Sep 2006 15:50 GMT

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.

Reply to this Message

Jerry Whittle - 12 Sep 2006 15:56 GMT

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.

Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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.

Reply to this Message

Patrick - 12 Sep 2006 16:02 GMT

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.

> 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
[quoted text clipped - 3 lines]
> > 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.

Reply to this Message

John Spencer - 12 Sep 2006 16:51 GMT

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.

> That worked but how do I keep the data sheets from opening? After I run
> the
[quoted text clipped - 12 lines]
>> > I
>> > have already unchecked the boxes in the "edit/find" in the options.

Reply to this Message