M
Mike Waters
Hello,
I currently am using a macro to print out several
reprots that I use on a regular basis. When the macro
runs, it sets criteria for the report before printing it.
This works fine if the query they run off of is blank.
The problem is from time to time I run the query with
certian criteria in it, and if I forget to save it blank
again, when I run the macro for the report, I don't get a
correct report. I can't seem to get a macro to set the
criteria in a query to blank fields before running the
macro. If anyone has any suggestions, please E-mail me at
(e-mail address removed)
Thank you,
Mike
I currently am using a macro to print out several
reprots that I use on a regular basis. When the macro
runs, it sets criteria for the report before printing it.
This works fine if the query they run off of is blank.
The problem is from time to time I run the query with
certian criteria in it, and if I forget to save it blank
again, when I run the macro for the report, I don't get a
correct report. I can't seem to get a macro to set the
criteria in a query to blank fields before running the
macro. If anyone has any suggestions, please E-mail me at
(e-mail address removed)
Thank you,
Mike