No data to show

G

Guest

Hi!

I have a macro that shows a message when there is no data to show in a
specific report. The second part of this macro should close the the report
and thereafter open a main menu. This macro worked fine until we installed
SP3 (Office 2002). The error message says this macro sets an nonvalid value
to any of the OnClose, OnOpening etc (except =OnNoData) and therefore the
instruction could not be executed.

A lot of strange things have happened since we uppdated with SP3, both Excel
and Acces. Would be very grateful for some help or explanation.
 
C

Chris Reveille

I there is no data why do you open the report. Just inform
the user and bypass the report? in your macro conditions
for your OpenReport action put
DCount("*","ReportQueryName")>0

Chris
 

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

Why doesn't this work!!!... 1
Error returned 1
Events won't trigger if locked for edit and if opened from IE 4
VBA code won't run, even with Macro Security set to Enable All Macors 9
Report / Subreport with No Data - don't print Statement 1
Error opening subform 3
Query will only show data for first record 1
Device Manager Shows Up Empty i.e. Blank Then MMC Error Data Box 13

Top