[AccessD] Reports - No Data

John,

I often setup up a recordset using the same criteria that the report
uses.  If the recordset has no records, then I display a useful message,
otherwise the report displays.

One of my reports will print out a full sheet 'form' for each record in
the recordset.  It could be that many records will be printed.  In that
case, I use the number of records in the recordset to report to the user
how many sheets will be printed, and they can push Yes or No to say if
they really want to print that many.  (i.e. There are 132 records based
on your search criteria.  Do you want to print a sheet for each record?)

Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Monday, March 31, 2003 2:28 PM
To: AccessD
Subject: [AccessD] Reports - No Data


How do you handle reports with no data? I have an A97 app that I want to
make it more clear to the user that the report has no data and then not
display it to them.

I use the OnNoDate event to display a message box and set cancel to
true. Is there a better, more meaningful way?

JB

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com