View Full Version : Printing All reports in a database


jackeric
07-24-2008, 07:36 AM
As a follow-up on a previous question, I'd like to add a button to print all 13 reports defined for my database from my custom menu (Access 2007).

Better yet, I'd like to choose the period to print those 13 reports (conformity requirement).

I'm afraid you will say that I have to dig into VBA...

FoFa
07-24-2008, 12:15 PM
Create a form with the criteria (for user input/selection). Write a query/ies to use the criteria from the form. Create a macro that prints each report from a button the form. Make sure each report is based of one of the queries that use the form criteria.
Simple, easy, no VBA.

Of course with VBA you could feed the criteria to each report in the DOCMD command.