Print from custom toolbar

[Guest]

Hi all,
I've created a custom toolbar that opens with my reports (Access 97). The
only print button available sends the report to the printer without prompting
for any user input eg: Number of copies, which printer etc...
Can anyone suggest a way to have this toolbar show a button that opens the
Print... dialog box before sending the report to the printer?
Thanks in advance,
Dave

 

[Marshall Barton]

I've created a custom toolbar that opens with my reports (Access 97). The
only print button available sends the report to the printer without prompting
for any user input eg: Number of copies, which printer etc...
Can anyone suggest a way to have this toolbar show a button that opens the
Print... dialog box before sending the report to the printer?

Create a public function in a standard module that uses
this:

DoCmd.RunCommand acCmdPrint