Checking for empty/null results

A

Adam

A report is created when a button is pressed in my Access
97 database application. This report retrieves its data
from a query that runs in the background. I want to check
to see if that query came up with an empty set, and if it
did show a messagebox indicating no data, otherwise, show
the report like it does now. I want to implement this so
a report with no data won't appear; thus limiting user
confusion.
 
V

Van T. Dinh

You can use the NoData Event of the Report.

Check Access VB Help on the NoData Event.
 

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

Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Consolidating multiple records into one record 0
including null values in a sum query (non-SQL programmer) 2
Crosstab query results and null vs. zero values 1
Checking for, then listing Null/empty fields in a message box 0
Empty But Not Null 8
Account for null values on a report 2
Changing a 'Static' report to a 'Dynamic' one 5

Top