[AccessD] How to access the print dialog box?

Docmd.RunCommand accmdPrint

should do it, open the report in Preview mode and then add that as the next line.

You can also make a custom toolbar that takes the File->Print button and makes that available.

There are a lot of good solutions to this one.

-Chris Mackin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Paul Baumann
Sent: Friday, December 03, 2004 8:51 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] How to access the print dialog box?


I am sorry, I should have been more specific...I would like to display
the printer dialog when printing a report from code so that the user
could then select a printer other than the default printer or perhaps
print to a file.

Paul

-----Original Message-----
From: Paul Baumann 
Sent: Friday, December 03, 2004 9:11 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] How to access the print dialog box?

Could someone tell me how to bring up the printer selection dialog box
when printing a report from access?

Thanks in advance.

Paul

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com