Printing reports to different printers

[SUZYQ]

I have a nightly process that imports data and then prints out several
reports. I have a non-networked local printer attached to my PC where
I want to print most of the reports on white paper. However, I do have
a set that needs to print out on yellow paper. I'd like to load yellow
paper in one of the network printers that has multiple trays. How do I
designate that these reports go to that network printer and print from
a specific tray?

Thanks,

 

[Mike Labosh]

I have a nightly process that imports data and then prints out several

reports. I have a non-networked local printer attached to my PC where
I want to print most of the reports on white paper. However, I do have
a set that needs to print out on yellow paper. I'd like to load yellow
paper in one of the network printers that has multiple trays. How do I
designate that these reports go to that network printer and print from
a specific tray?

In Access, printer bindings are stored with the report. I have always
thought this to be kind of dumb, but you can exploit it to your advantage.
Open your reports in design view, and for each one use the File -> Print
Setup dialog to point each report to whatever printer you want and then
re-save the reports. They should then print to the designated printer.

--
Peace & happy computing,

Mike Labosh, MCSD

"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS!"
~~ General Barringer ~~