Print Dialog Macro

C

Curaçaoboy

Guest

• Nov 22, 2004

• #1

Hi,
I made a report for my Access Database. But I want to create it in a way that when the user request for that specific report, a print dialog will appear automatically asking him on which printer should the document be printed.
Is that possible with a Macro?

 

D

DJN

Guest

• Nov 22, 2004

• #2

You can't do it through a macro. You need some VBA. Try this web site.

http://www.mvps.org/access/reports/rpt0009.htm

David

 

ghudson

Registered User.

Local time

Today, 05:10

Joined

Jun 8, 2002

Messages

6,194

• Nov 22, 2004

• #3

This command will open the print dialog...

Code:

DoCmd.RunCommand acCmdPrint

Ensure that you trap for error # 2501 [if the user clicks the Cancel button].

You could open the report in the print preview mode and then call the print dialog or give the user a toolbar button to call it when needed.

 

C

Curaçaoboy

Guest

• Nov 23, 2004

• #4

Thanksss!!!!

GHUDSON Thanks!!!
IT Works perfectly!!!!!!

 

KenHigg

Registered User

Local time

Today, 05:10

Joined

Jun 9, 2004

Messages

13,327

• Nov 23, 2004

• #5

Cool -