Custom Toolbar

[CanWest]

I have created a custom toolbar that will be displayed on all of my reports. I want to have a button that displays the print dialog box rather than simply sending the report to the default printer. I remember seeing a button that had the word print followed by three ... but it does not seem to be available in the list of commands. Any help would be appreciated.

 

[Trevor G]

If you have created your toolbar you need to attach a command to get the dialog box, the code for the dialog box is

Application.Dialogs(xlDialogPrint).Show

 

[CanWest]

II have no clue how to do that.

 

[Trevor G]

I take it you are using Access 2003 or below as you have stated you have created a Toolbar, if so upload a sample of the database so I can place it on a 2003 machine and add the control and upload it back to you.

As I am using 2007/2010 most of the time now I need to refresh the steps to do this.

 

[CanWest]

It is a split db do you need both halves

 

[Trevor G]

If possible, or copy some of the relevant things into a new database

 

[CanWest]

Ok I am uploading a sample db. Please check the report that has a custom toolbar called Print

 

[boblarson]

Ok I am uploading a sample db. Please check the report that has a custom toolbar called Print

See if the attached revised works for you.

 

[CanWest]

Actually I am looking for just the opposite. I need the print dialogue box to appear

 

[Trevor G]

What you need to do is open then report up, then where you have placed your toolbar drag to the other side of the screen as we have to customise the File Menu.

Then select your toolbar and right click to select Customise.

The Click the file menu, once it opens you hold down the Control Key and don't let go, you now go down to the print and then drag that into you toolbar, once done let go of the control key, close the customise area and your done.

I have attached your database with the print option so it shows the dialog box.

 

[CanWest]

Oh my god

That was so incredibly simple. I should have thought about that one myself. I teach people how to do a drag and drop copy using the control key. Thank you so very much. Here I am looking for a solution in code and it is a simple as copy and paste. Thanks again

 

[Trevor G]

Pleased to read you now have your solution without coding.