Printer Options for Reports in MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way of offering the User to set a default printer for an MDB
file without bothering Windows settings ? Also by extension, can the User be
given an option to choose a specific printer for any Report ?
The idea is,
Once the User sets his options, his/her preferences have to be saved until
the User wishes to change the same and any Report with a Specific Printer
option will go to that printer only and others to the default printer of the
database, without bothering to ask the User about which printer to choose
each time (s)he goes to print.
I want to include this option in the Custom Report Menu of the FE of MDB
file. Windows settings should not be changed because Users have other
applications (not Access) which use the Windows settings.
 
If you are using Access 2002 or later, this is a relatively simple matter,
by setting the Application.Printer object.

Take a look at:
Printer Selection Utility
at:
http://allenbrowne.com/AppPrintMgt.html

The free utility illustrates how to create a custom property for the report,
to remember the particular printer the user wants, code to automatically
send it to that printer when it opens, and a custom toolbar that lets the
user preview the report and remember which printer to use for it.
 
Thanks Alex and Thanks Allen,

You're simply great. Actually, I'm sort of addicted to this NewsGroup that I
find myself running to you whenever I'm hit with a problem - and my appetite
is further increased with the great stuff I get here !
 
Back
Top