Re: Bring up Print Options from Custom Toolbar Button

Tech-Archive recommends: Speed Up your PC by fixing your registry

You can copy the File, Print item from the main menu to your custom menu (via Ctrl-drag), however if you turn off 'allow built-in menus' in Tools, Startup, you'll find that File, Print will disappear from your custom menu.

Instead of copying from the built-in menu to your custom menu, use a function, and assign it to the OnAction property of your menu item.

Public Function PreviewPrint()
DoCmd.RunCommand acCmdPrint
End Function

--
Joan Wild
Microsoft Access MVP
<cpocpo@xxxxxxxxxxx> wrote in message news:1178802649.752475.244190@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello.

I have a custom toolbar for my database.

When I use my "Report Switchboard" with command buttons, they all
Preview their respective reports. When I hit the custom toolbar Print
button, it prints the full report instead of allowing a choice to
print certain pages or select printer.

What I would like is when the toolbar Print button is pushed for a
particular report being previewed, it would bring up the Print option
box similar to what comes up using the normal Access menu (File>Print)
(Printer selection, print range, and number of copies). The same
button should also work whether a form or report is the thing on the
screen.


Any ideas?

V/R

LostGuy

.

Quantcast