No Data event for reports

  • Thread starter Thread starter b_lwalker
  • Start date Start date
B

b_lwalker

One of the reports in my db can be opened with no data (filtered by
date, date selected by user). When this happens I would like to
display a message box to this effect and close the report.

However, due to formatting/ordering requirements I need to open the
reports in preview, and for some reason the No Data event executes 4
times on opening - and this prevents me from closing the report.
Any ideas on how to get around this?

Cheers,

Bruce Walker
 
If you cancel the NoData event the report does not open.

If you used the OpenReport action to open the report, you macro will then
give another error message. If you used the OpenReport method in code, you
can trap this error (2501) so it does not bother the user.

The NoData event should not fire multiple times.
 
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

Access Access Report Works on One Machine but not Another 3
Can't create a report from my query in Access 1
DATA NOT REFLECTING IN REPORTS 3
Command not available in MDE/ADE 2
Report Query Works 2nd Time, But Not 1st 14
On no data 2
Applying filter on report 2
2007 Report Toolbars 1

Back
Top