Toolbar and Menu Bar

[CanWest]

I have followed the instructions in post http://www.access-programmers.co.uk/forums/showthread.php?t=100810&highlight=menubar

In the onOpen evet in my splash screen I have place

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
Next i

And on the onOpen event in my report I have placed

DoCmd.ShowToolbar "Print", acToolbarYes

Where print is the name of my custom toolbar. However the custom toolbar never shows up. Any ideas

 

[Trevor G]

How do you get to the report, through a command button if so why not add the code behind the button rather than the report event.

 

[boblarson]

Where print is the name of my custom toolbar. However the custom toolbar never shows up. Any ideas

Why not just set the report's Toolbar in design view:

 

[CanWest]

Hello

Thanks for your input but neither solution seems to work. Because I have disabled all toolbars and menus with the first piece of code selecting a custom toolbar in the report properties has no effect.

 

[boblarson]

Hello

Thanks for your input but neither solution seems to work. Because I have disabled all toolbars and menus with the first piece of code selecting a custom toolbar in the report properties has no effect.

Obviously. So if you want a tool bar you can't do that. You will have to do things another way. So, are you wanting no toolbars or menus for most items and then for only select items you would have them? If so, I would create a blank menu/toolbar which you can then assign to each form/report and set these start options:

Allow Full Menus, Allow Built-In Toolbars, Allow Default Shortcut Menus

to NO by unchecking the checkboxes.

 

[boblarson]

Although you probably don't have to set the default for each form/report to a blank one if you remove the defaults in the startup options like I showed.

 

[CanWest]

Ok but how do I get the custom toolbar and blank menubar to be visible on my report when the first code has turned all toolbars and menubars off. Do I use the opposite code on open to show all toolbars and menubars and the reverse it on close. That seems a bit cumbersome.

 

[boblarson]

Ok but how do I get the custom toolbar and blank menubar to be visible on my report when the first code has turned all toolbars and menubars off.

You missed what I said. You need to REMOVE that code. You can uncheck the default menus and toolbars and you can give them blank ones, except for the places where you want some. But if you use that code, then you are turning everything off including your custom ones. So don't do it.