A
Adrian
Access 2000
Using something like:
Private Sub Report_NoData(Cancel As Integer)
MsgBox "No data could be found to fill this report.", vbInformation
Cancel = True
End Sub
If I print preview a report with no data then I get the message box and the
report does not open.
If I try and print the report I get the windows printing message with the
'no data could be found ..' message box on top, which I can close and then
the application freezes.
If I remove the 'no data could be found' message box and put a debug on
Cancel = True, the code will halt if I preview the report, but if I send to
print it freezes before the code halts.
This happens on all reports.
Any help gratefully received.
Adrian
Using something like:
Private Sub Report_NoData(Cancel As Integer)
MsgBox "No data could be found to fill this report.", vbInformation
Cancel = True
End Sub
If I print preview a report with no data then I get the message box and the
report does not open.
If I try and print the report I get the windows printing message with the
'no data could be found ..' message box on top, which I can close and then
the application freezes.
If I remove the 'no data could be found' message box and put a debug on
Cancel = True, the code will halt if I preview the report, but if I send to
print it freezes before the code halts.
This happens on all reports.
Any help gratefully received.
Adrian