[AccessD] Controling Printers thru code

Controlling printers thru code basically sucks in version of Access
prior to 2K2.  You need to use the PRTDEVNAMES and PRTDEVMODE
structures, which involve some horrible API calls. (and, since they
operate in a report's design mode, they only work in regular MDBs, not
runtime MDBs, or MDEs.)  
Start here http://www.mvps.org/access/reports/rpt0009.htm if you feel
like torturing yourself.  
I know there are lots of fans of the older versions on this list, but to
be able to code 
 * Set rpt.printer=<printer object> * in either an mdb or mde, made
AccessXP a worthwhile upgrade for me.

Steve


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeff Barrows
Sent: Thursday, May 13, 2004 11:23 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Controling Printers thru code


Thanks for the idea, but I am going to have to go with seperate reports
to print and fax, at least for now.

	-----Original Message----- 
	From: Andy Lacey [mailto:andy at minstersystems.co.uk] 
	Sent: Wed 5/12/2004 5:09 PM 
	To: 'Access Developers discussion and problem solving' 
	Cc: 
	Subject: RE: [AccessD] Controling Printers thru code
	
	

	Jeff
	If you use Outlook then Zetafax has an Outlook extension which
allows you to
	behave as if you're sending an email (e.g. SendObject) but by
addressing it
	to a fax number it gets sent as a fax. We use it all the time
and it's way
	easier than setting printers.
	
	-- Andy Lacey
	http://www.minstersystems.co.uk
	
	> -----Original Message-----
	> From: accessd-bounces at databaseadvisors.com
	> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
	> Jeff Barrows
	> Sent: 12 May 2004 17:20
	> To: AccessD
	> Subject: [AccessD] Controling Printers thru code
	>
	>
	> How do I control which printer a report is going to thru code
	> in Access 97?  In some instances, I need the report to go to
	> ZetaFax, and to do this I need to set the report's printer
	> default to go to the Zetafax Printer.  What I need to be able
	> to do is change the printer selection back to the Windows
	> Default Printer, thru code, so that the users never have to
	> do it manually.
	> 
	> Any help greatly appreciated.
	> 
	> TIA
	> 
	> Jeff Barrows
	> --
	> _______________________________________________
	> AccessD mailing list
	> AccessD at databaseadvisors.com
	> http://databaseadvisors.com/mailman/listinfo/a> ccessd
	> Website:
	> http://www.databaseadvisors.com
	>
	>
	
	--
	_______________________________________________
	AccessD mailing list
	AccessD at databaseadvisors.com
	http://databaseadvisors.com/mailman/listinfo/accessd
	Website: http://www.databaseadvisors.com