printing multiple reports at once

[neil webb]

hi there

we have a simple sales database in access 97 which has reports set up for printing out job cards, delivery notes, delivery control cards etc... what i would like to know is if it is possible to set up a command button to print all of these reports at once instead of having to press 5 buttons.

my knowledge is very basic so a step by step (idiot proof) expanation would be very much appreciated!!!

for example at present if i want to print a complete set of paperwork out i have to :-

press the job card button which asks me to enter the order number (autonumber) then print it off

this procedure is then done another 4 times for the other reports/paperwork

HELP please

regards

Neil

 

[Michael J Ross]

Easiest way will be to look at and edit the Event Procedure on the On Click proprty of your button.

You will need to define each report using Dim the first one is Dim stDocName As Report (already exists in the Event procedure), your next report will be Dim stDocName1 As Report, then Dim stDocName2 As Report for the next etc.

Then reference each of the stDocName to the name of the report as shown in the existing Event Procedure and under each one put in the DoCmd.OpenReport stDocName, acPrint, DoCmd.OpenReport stDocName1, acPrint,DoCmd.OpenReport stDocName2, acPrint etc.

Hope this helps