How to un-hide the tool bar menus?

[techexpressinc]

In making my switchboard and display screen ready for the user I hid the top menu and tool bars, with the important drop-down of compact and repair.
I cannot get them back?

I read this posting "Hide all Access Toolbars and Menubars"
http://www.access-programmers.co.uk/forums/showthread.php?t=97578

I think I put this code in some place:
"
This will hide all menu bars and tool bars
<<CODE>>
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
<<CODE>>

Weird that the non-showing of menu bars is in all my Access DB-s, now. The code must have updated my Access application not to show in all DB-s.

Any help in getting my tool bar back will be appreaciated!

Thx
Russ

 

[vbaInet]

Reverse the process by changing the FALSE to TRUE perhaps?

 

[techexpressinc]

Re: How to un-hide- They are back Yippe!!

It was a little tricky. I am worried about turning them off. That it will effect more than just the one DB. It will effect the person's PC for all DBs.

I will probably just use the max screen option and stay away from turning off the menu tool bar for now.

Attached is a screen print of the fix. I installed the fix in the event for the open for the switchboard.
Russ

 

[vbaInet]

You could use these as well:

CurrentDb.Properties("AllowFullMenus") = False
CurrentDb.Properties("AllowShortcutMenus") = False
CurrentDb.Properties("AllowBuiltInToolbars") = False
CurrentDb.Properties("AllowToolbarChanges") = False

Then on the LOAD event of the form set the menu bar to the menu bar you created?

Me.Menubar = "MyCustomisedMenuBar"

 

[techexpressinc]

I am slightly confused. When I did my code to hide the tool bars, it was effecting not just the one Database. But all the databases I open. Does this sound right?
Thx
Russ

 

[vbaInet]

The container of the CommandBars is the Application. If you're referring to the Application then it would affect the whole Access application. This was why I mentioned using the CurrentDb properties and changing the form's menu bar property.

 

[techexpressinc]

Good .. wow - I was surprised the command crossed DB-s. I would think usually you want to only impact the DB you are working on. Not every DB the person opens.

Thank you for your help and follow-up.
Russ

 

[vbaInet]

No problemo. Let us know how you get on.