[AccessD] print report to a specific printer

Doug Murphy doug at murphyscreativity.com
Tue Oct 14 17:01:37 CDT 2003


Take a look at the 9/24/03 article at
http://www.augsd.org/Articles.html.  It is titled "Using the new
Printers Collection to control printing in an MDE".

Doug




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Tuesday, October 14, 2003 2:35 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] print report to a specific printer


In that case, I think you have only one choice, which is changing the
default printer temporarily and then changing it back.  An MDE isn't
going to let you open a report in design view, which is what you have to
do in order to change the printer and then save it.  Maybe someone else
has had success using the report's printers collection in an mde, but I
haven't tried it.

How were you planning to insure that the specific printer is available
to the target system?

Charlotte Foust

-----Original Message-----
From: Dale Kalsow [mailto:dkalsow at yahoo.com] 
Sent: Tuesday, October 14, 2003 1:11 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] print report to a specific printer


Sorry, I am using office XP and I be compling the application into an
mde.
 
Thanks in advance!

Dale

Charlotte Foust <cfoust at infostatsystems.com> wrote:

	You didn't mention the version of Access. AXP has a printers
	collection, although even there, I prefer to use the API calls
to get
	printer information. Keep in mind, though, that to do this, you
have to
	change the design of the report in code, so it doesn't work if
you have
	an MDE. Can you fill in some of the details?
	
	Charlotte Foust
	
	-----Original Message-----
	From: Dale Kalsow [mailto:dkalsow at yahoo.com] 
	Sent: Tuesday, October 14, 2003 12:29 PM
	To: AccessD at databaseadvisors.com
	Subject: [AccessD] print report to a specific printer
	
	
	I have a report that I need to send to a specific printer, that
may or
	may not be the user's default printer.
	
	Does anyone know how to do this using code.
	
	Thanks in advance!
	
	Dale
	
	_____ 
	
	Do you Yahoo!?
	The New Yahoo! Shopping
	
	text%2Csec%3Amail> - with improved product search
	_______________________________________________
	AccessD mailing list
	AccessD at databaseadvisors.com
	http://databaseadvisors.com/mailman/listinfo/accessd
	Website: http://www.databaseadvisors.com

  _____  

Do you Yahoo!?
The New Yahoo! Shopping
<http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3A
text%2Csec%3Amail>  - with improved product search
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list