Customized Menubar Problem

[Marcel Stoop]

Hi everyone

I have two smaller problems concerning customized Menubars (Access2000)
which are more or less related to eachother.

1) From the customize toolbar screen, Tab "Commands" I have pulled the
"Print" command into my own created command Bar menu.
I noticed that this command result in printing without getting the normal
Print dialog in which you can choose the printer.

Is there a way to get this dialog?

2) To avoid this problem I decided to pull in to my own menubar a Build-in
Menu named "File". This also contains the "Print" command. This command
results in first opening the printer dialog. Just like I want to have it.
So I thought I was happy. But then I noticed that when I start modifing the
commands in this Build-in Menu "File" (new Icon, new commands, delete
commands etc) those changes have the same impact on the normal standard
Access menubar "File".

Is there a way of prevending this?

Cheers
Marcel

 

[Albert D.Kallal]

You can well steal command buttons (make sure you hold down the ctrl-key
when you drag and drop).

Thus, the above "drag and drop" will "copy" the icons, not damage the
original ones. (you REALLY need to do this!!).

Further, for the print button command, you can make your own button to show
the print dialog. Just have your button run the following:

The select object command is needed to fix a "focus" bug if you have a form
with a timer function.

For the code that pops up the printer dialog (so the user can change
printers etc).

You can use:

On Error Resume Next
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
DoCmd.RunCommand acCmdPrint

The select object command is needed to fix a "focus" bug if you have a form
with a timer function. (so, remove that above select object code if this
custom menu is not for your reports).

 

[Marcel Stoop]

Thanks for the help.