From have someone run them at the same time every week
To creating a macro that runs each of the reports and then quits. Then use a
scheduling program to open your MDB with a command line that calls the macro.
If you have specific requirements, you need to let us know.
What I had imagined was a command button on my form with the date parameters
to control the five reports that someone without access knowledge (I'm a
beginner)could press and it would open each report, print it then close.
Could I do this with code? If this is not the best way I would appreciate any
input
thanks for your help
You can create a couple text boxes on your form for entering the dates. Then
add a command button that opens your first report. Modify the code to include
the dates in a where condition and add the other reports. If you can't figure
this out, complete the first two sentence in this reply and come back with:
- the code that was created by the wizard
- the names of your date text boxes
- the names of your other reports