Macro to display error message when no records found

O

owl37

Hi all,
I want to create a macro which displays an error message when a report is
run and no records are found.
Any ideas?
Thanks a lot.
 
O

owl37

Hi,
I have solved this problem.
I created the macro MsgBox
I opened the report and went into properties and the event tab
I used the event 'On no data' and assigned my macro using the dorp down list.
Hurahh for me!
 

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

Macro warning in word 1
Need Help with Macro Security 1
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Internal Data Integrity (Type 4) Details Needed 1
Save workbook without shapes 0
Improving Macro That Keeps First Letter 0
Mail Merge skipping records/sending one at a time 0
Word macro that can call cells out of Excel for a find and replace 0

Top