macro to only output if there are records in tbl
I have a macro that outputs a report to print. I dont want it to output if there are no records, because I dont want to waste paper. Please advis开发者_StackOverflow中文版e. I am familiar with Access, but do not know VBA. thank you very much, Nathaniel
Use the reports On No Data event to display a message and then quit. This can be done using Macros. Start at the reports property sheet and click on the Event tab.
精彩评论