Mike & Doris Manning
mikedorism at adelphia.net
Thu Apr 1 08:56:32 CST 2004
By default, the Printer Dialogue box does go to the default printer unless the report has one specifically specified. As far as I know, you have no control over the Printer Dialogue box from within Access. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Geller Sent: Thursday, April 01, 2004 9:31 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Default Printer for Access Report Thanks, Doris, that was the problem. I'm wondering if, as a fail safe measure, can I write code that would make sure that when that Printer Dialogue box opens it is always set to go to the default printer? I'd want users to be able to pick a different option if they desired, but just as the default, that the print box would be set to go to the default printer. Where would I put the code? --Susan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike & Doris Manning Sent: Tuesday, March 30, 2004 12:03 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Default Printer for Access Report Open that report in design view and then click on "File" and choose "Page Setup". It is possible it get set accidentally when the report was designed. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Geller Sent: Tuesday, March 30, 2004 12:28 PM To: accessd at databaseadvisors.com Subject: [AccessD] Default Printer for Access Report I have a reporting tool built in Access (2002) that is essentially a wizard where users pick a report, set criteria and then see their output. There are nearly 100 reports in the app. When a user choses to print a report, the default printer that comes up in the print dialog box is the default printer set on their machine, EXCEPT for one of the reports. On that one report only, the default printer that comes up in the dialogue box is a different printer. All users get this different printer. I did not write any code or make any settings to indicate printer choice. What could be happening? How can I get this one report to print to the user's default printer? Note: The only way that users can print a report is with a toolbar PRINT button that I brings up the dialogue box. There is no file menu from the reports and there is no button with a printer icon that sends reports straight to the printer. --Susan Susan B. Geller Office of Information Systems College of Continuing Education University of Minnesota 306 Wesbrook Hall 77 Pleasant Street SE Minneapolis, MN 55455 Phone: 612-626-4785 Fax: 612-625-2568 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com