BleepingComputer.com: Access macro help

I was wondering if anyone could help please

in Access is there a way to create a macro that is linked to a report? eg. i hav a query that i've linked to a report, but sometimes there are no results in the report, so a blank report just shows. is there a way that instead of the blank report appearing when there are no results, there is a message box that says 'no results' or something along those lines?

thanks

Most likely, but I'm not sure, if you put a calculated field in the footer of the report and the calculation says something like 'if number of records=0 ... put out "No records".

i have another issue now. I've mail merged between access and word but now i dont know how to create a button with a macro to run the mail merge. the mail merge is dependent on a parameter query.

could anyone help me out please.
thanks

Hi...

You could write some VBA code to display a msgbox for your blank report. On the report there is an event called 'OnNoData'. If you add code to this event, when your report is blank, you can display a msgbox with something like 'no data found'.