[AccessD] Default Printer for Access Report

I have found that printing a report (that is checked into SourceSafe, that
is, not updatable) to the Acrobat PDF printer will change the printer from
the default to the PDF printer.  Many times, but not all, the printer will
stay set to the PDF printer unless I go in and change it to the default
printer.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike & Doris
Manning
Sent: Thursday, April 01, 2004 9:57 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Default Printer for Access Report


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