Custom Toolbar

[Vassago]

I'm trying to create a custum toolbar for the reports in one of my databases. I'm running into a problem when trying to do a print button. I want the print button to bring up the Print dialog box so the user can select the number of pages, etc. Is this doable? Every button that I've seen so far does a straight print without prompting the user. Thanks in advance!

Vassago

 

[Vassago]

Nevermind, thought of a way to do this. My mind is working great today. Thanks to anyone trying to help.

In case anyone was wondering how I did this, I set the print button on the toolbar to run a macro with the Sendkeys function. I set the macro to send the keys "^(p)" which makes it bring up the dialog box.

Vassago

 

[Rich]

or use the print out method

 

[Vassago]

I thought of that, but I need the actual print dialog prompt. Does the Printout method do this? I couldn't find a way to make this happen without cheating using SendKeys.

Thanks!

Vassago

 

[bradcccs]

Vass,

I use AccXP and it is possible to have the Ctrl+P print option on a custom toolbar (and thus I imagine it would work in Acc2000 also).

View / Toolbars / Customize

Then add the "File" Menu from "Built in Menus"
Expand the new "File" menu, and then drag the "Print Ctrl+P" option to your custom toolbar.

This will give you the print option you require.

However, it will also remove the ctrl+p print option from the file menu.

To get the option back on the File menu, when in customize mode, right click the file menu and select "reset".


To differentiate between the Ctrl+P button and the straight print button (other than the tooltip displaying the printer name), you could right click the new print button and select "image & text" as the display style. (See attached)

Hope this helps for future projects.

Brad.

 

[R. Hicks]

Use:

DoCmd.RunCommand acCmdPrint

This will open the Print Dialog Box.

If the Report is to be sent directly to the printer and you want the Print Dialog Box to open ... go to the location below for instructions:

Make Print Dialog Box appear when printing a Report

HTH
RDH

 

[Vassago]

Bradcccs. That suggestion worked perfectly. I never thought of that. Thanks a lot!

Ricky, yours works as well, but doens't gray out the print button when a non-printable document is opened, since it would be running a macro. Thanks for the suggestions though, this will probably come in handy later.

Thanks everyone!

Vassago