Don't Display queries with Zero Results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a number of Edit Queries that I execute as part of an automated
process. I only want to display to the user the Edit queries that have
results. I have done this in the past but cannot find the code I used to not
display queries that had no results. Can someone please point me in the
right direction.

Thanks!
 
You haven't done this in the past, because it isn't possible. Queries have
no inherent "smarts", which just means they can't monitor their own
resultset, and they certainly can't act on stuff. If you want to only
display a query that has results, you have to use it as the RecordSource for
a report, and use the report's NoData event.

Private Sub Report_NoData(Cancel As Integer)
MsgBox "There's nothing to show"
Cancel = True
End Sub

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
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

Query Returning Multiple Results 1
How to display multiple IIf results in one column 1
Display Query Results on top of a Form 1
Run query based on results of previous query using code 4
Update Field from Query Result 1
Display all results, even zeros, nulls, and blanks 3
Close query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top