No data to show

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top