Print a report to mutiple printers

[ram]

Want to create a command button that will force print a report to multiple
network printers. Will need to store the list of printers in a table for
maintance purposes.

 

[Allen Browne]

Assuming this is Access 2002 or later, your command button could:
- OpenRecordset on the table with the names of the printers.
- Set the Printer object to each printer.
- OpenReport, using acViewNormal so it goes to that printer
- Loop for the next record (i.e. the next printer.)

That's withtout testing.

Earlier versions will need a different approach. Albert Kallal has a sample
database for Access 2000:
http://www.members.shaw.ca/AlbertKallal/msaccess/printch2k.zip
or Access 97:
http://www.members.shaw.ca/AlbertKallal/msaccess/printch97.zip