Condit Macro: test for query being empty

B

BtwOSU

Does anyone know the syntax, in the conditional column of
a macro, to test for a query yielding no data?

I have a macro that "sendobjects" several queries. If a
particular query yields no data, I would like to not send
the empty query.

I would appreciate any help!

Thanks!

BtwOSU
 
S

Steve Schapel

BtwOSU,

Try this as the Condition for your SendObject action:
DCount("*","YourQuery")>0
 

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

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Word VBA - Want to test if Full Name is NOT Present in document 0
SendObject Macro 11
Type Mismatch in Macro with empty string/null value 7
Using Query Field to name SendObject file 3
Needing to run automatically 62 append queries 6
Macro Condition that references result of a query? 6
Use Macro to Filter records in Subform on open 0

Top