Nothing query

  • Thread starter Thread starter Jarod
  • Start date Start date
J

Jarod

Is there a way in VBA to tell if a query produces no
records? Thanks for the help.
 
You might open a recordset based on the query and test if both BOF and EOF
are True.
 
Try:

DCount("*", "YourQuery")

It should give the number of rows returned by your Select Query, including 0
for no rows returned.
 
You must log in or register to reply here.

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

Export Query Output To Text File 1
Delete Query: Could not delete from specified tables 0
Union Query Access 2007 SP2 MSO 7
Why does MSAccess cut query after 2886000 records 1
Query to show 2 records from each unique entry in a field 2
Run a Query to Run a set of queries 3
Combine Duplicates in Query 0
Return Zero if No Records 1

Back
Top