Run query based on results of previous query using code

[H J]

I have a database with 6 queries, currently I have to manually run each of
these, but I want to automate them by clicking a button and letting them all
do their job.

The problem is that on one of them, I need to review the results before
proceeding with the next one. But, I only need to review the results if
there are any, if the query comes up empty, all is good and I can continue.

How can I code this so that if the query A returns no results, query B runs,
if query A has results, then those results are displayed and query B does
not run (I do not need to run query B until query A has no results).

Thanks.

 

[Bob Barrows]

I have a database with 6 queries, currently I have to manually run
each of these, but I want to automate them by clicking a button and
letting them all do their job.

The problem is that on one of them, I need to review the results
before proceeding with the next one. But, I only need to review the
results if there are any, if the query comes up empty, all is good
and I can continue.

How can I code this so that if the query A returns no results, query
B runs, if query A has results, then those results are displayed and
query B does not run (I do not need to run query B until query A has
no results).

Are you using ADO, DAO or RunQuery to run these queries?

 

[Skip]

How about (air code):

DBEngine(0)(0).Execute "QueryA", dbFailOnError
If StatusMsg(DBEngine(0)(0).RecordsAffected = 0 then
DBEngine(0)(0).Execute "QueryB", dbFailOnError
Else
docmd.OpenQuery "QueryA"
End If

 

[H J]

Thank you, this method worked perfectly (after I installed DAO)... I tested
with 0 values, and with values, both ways work as expected.

Thanks,

 

[Skip]

Good to hear. Thanks for the feedback.

Thank you, this method worked perfectly (after I installed DAO)... I
tested with 0 values, and with values, both ways work as expected.

Thanks,