Print Dialog Macro

[Curaçaoboy]

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?

 

[DJN]

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]

This command will open the print dialog...

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.

 

[Curaçaoboy]

Thanksss!!!!

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

 

[KenHigg]

Cool -