Toolbar programming

S

Sandy H

I have a custom toolbar that has a print button on it. I want the print
setup dialog to appear when this button is pressed but can't find a way to
make this happen. When customising the toolbar, you can add the print button
and the properties for this are identical to those on the File->Print menu
item. If anyone knows how to get the print setup to appear from a custom
toolbar, I would love to know.

Thanks in advance
Sandy

PS I have double posted this because the first newsgroup I sent it to
doesn't appear to be valid.
 
P

PC Datasheet

Function RptPrint()
On Error Resume Next
DoCmd.RunCommand acCmdPrint
End Function

Set the Action property of the Print button to:
=RptPrint()

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
 
Top