Can Access 2K Specify Printer?

[David Habercom]

I know this question must have come up in this group before: can I direct a
report to a particular printer with a VBA command? By some other method?
Thanks.

David Habercom

 

[Rick B]

Sure. While in design view, go to the Page Setup and click the "page" tab.
Then use the Printer box near the bottom of the screen.

Rick B

 

[HFloyd]

The VBA Solution...

To use VBA code to accomplish this, see this page:

http://www.mvps.org/access/reports/rpt0009.htm

Heather

Floyd Innovations LLC
http://www.floydinnovations.com