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