select specific printer for report

[Guest]

I am trying to select a specific label printer for a report in Access 2007.
In Page Setup, I can pick the printer, but then the info doesn't stay put
after I leave the dialog box and preview the report. What's happening? It
worked in previous versions. Anyone have a fix?

 

[krissco]

I am trying to select a specific label printer for a report in Access 2007.
In Page Setup, I can pick the printer, but then the info doesn't stay put
after I leave the dialog box and preview the report. What's happening? It
worked in previous versions. Anyone have a fix?

After selecting the specific printer via Page Setup, you can (if it
works for you) compile your database to a .MDE - this will make it so
that anything code-related (reports included) can not be changed (that
includes printers).

-Kris

 

[Allen Browne]

Yes, smitty, this is a bug in Access 2007. :-(

AFAIK, this has not been fixed yet.

If it's any help, there is a way to create a custom property for the report
to hold the printer name you want it to print to. You then set the Printer
object before opening the report, and reset it afterwards. You can copy the
code to do this from the sample database in this article:
Printer Selection Utility - Users assign printers to reports
at:
http://allenbrowne.com/AppPrintMgt.html