Print from custom toolbar

D

Dave

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
 
M

Marshall Barton

Dave said:
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?
Click to expand...

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

DoCmd.RunCommand acCmdPrint
 
Top