Printing Reports

[Keith]

Is it possible to specify which printer a report prints to on a network?

 

[Elana]

I was just asked the same question today and I cannot find any information on how to do this with VBA. (Maybe I just don't know how to look!) The question has been asked before in this forum, but the only answer given was to make a separate copy of the report for each printer device you want to print to, then set the printer through the File/Print menu...all subsequent prints will be to that specific printer. I don't like this solution and must believe there is a more elegant one to be had...hope someone out there in AccessLand can give us an idea.

 

[DS]

Have a look at the PrtDevNames property in MSAccess Help. I think you'll find the answer in there somewhere! Not sure myself yet how it works.

Good Luck
DS