Need Help on Print Dialog!

[Tomki]

Helo everybody.

I have a form on which I have a Command Button which Preview a certain Report, and also on that form there is the other command button which prints directly that Report. Also, I've created a Private Menu Bar with different functions.

The question is:

How can I add the code on the Command Button (which is supposed to print a certain Report) so every time I click on that command button the Print Dialog Appears?

Or

How can I add the Print command from the File Menu to my Private Menu Bar.

 

[rich.barry]

I persume the Menu Bar you mention is the one up the top of the screen.
Modifying this is done by Right clicking, Customise, then go to the Command Tab and scroll down the File category to get to print, and drag it up onto your menu bar.

To get te print dialog from code, the easiest is probabily to use SendKeys "^P". This basically presses Ctrl P on the keyboard for you.

 

[ghudson]

Check the help files for ShowPrinter Method. That looks like it has the option you want to use via code.

HTH