Page / Printer setup in Access reports

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

Guest

I have a problem with printer setups within an Access project
Our client has specific requirements for some reports in the system to be printed out double-sided and/or on letter head
It is easy to select the printer and paper tray etc when at the client site, and the settings are saved with the appropriate report
The problem is, when the Access project is opened at our office (where the printer does not exist) Access obviously cannot find the printer, so the settings revert to "default" automatically, and I am not able to stop it
Is there any way around this? Can I stop Access from checking for the printer and changing settings automatically
Or maybe there is a way to specify a printer and specific settings through VB
Anyway help would be appreciated

Thanks
Michael
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In Access 2003 (XP) (maybe ACC2000) there is a Printer object that can
.... I don't know what - never used it. Perhaps you can change the
default printer (DeviceName) using this object.

In ACC97 you have to fiddle around w/ the PrtDev. See this article on
how to Change Printers from Code:

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

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQB6laoechKqOuFEgEQKrPgCfaxyW226euXnBzCeish9cPxCYbO0AoJDA
jKBDLwrsiruVIg+jYwXjQAeP
=DrzX
-----END PGP SIGNATURE-----
 
Back
Top