Printing Multiple Reports from a form (Access 2000)

Topic

New Reply

I have a database for storing manufacturing data and notes about customer orders. When the order is complete, the users need to print several reports that are tied to a common order number. I think I can do this by creating a form with an unbound text box for entering the order number, then setting up option buttons tied to each applicable report (not all reports are applicable to all orders). I just don’t know how to actually execute the print job based on only the option buttons selected. Also, some reports require more than one copy.

Reply | Quote

Replies

For two copies of a report try this:
DoCmd.SelectObject acReport, “nameof report”, True
DoCmd.PrintOut , , , , 2
Can you give some more info about the options?

Reply | Quote

The option buttons would be different reports that could be selected for a given order. Right now I have 9 different reports that may need to be printed for a given order. Usually not all 9 are required, I was hoping to have the user select the reports desired by clicking the option button for that report. Then all I would like them to be have to do is click one print button that spit out all the different reports selected, whether that is 2 or 5 or 7. Does that help?

Reply | Quote

You can let the “Print” button run code or a macro that runs based on conditions. Check each option button, and if true print the applicable report. Only options checked will generate a report.

Reply | Quote

Right, that is what I’m looking for. I don’t know how to write the code, that is the help I’m looking for. I can understand the code when I see it, but I’m still learning how to write from scratch. Too much work, not enough time to self train.

Reply | Quote