Remove menues from access via VBA

E

Erik

Hi (again)..

i have managed to remove the file menu etc from access via code, but sometimes a too menu (ex the form menu) apears anyway.. how can i loose this too.. i use this code to lose the menu bar

DoCmd.ShowToolbar "Menu Bar", acToolbarN

hope somone got a sugestion!!

Erik
 
E

Erik

yeah, that removes the custom file menu, but not if the user has own custom menus in acces?

Erik
 
F

Fuentes

Dim usermenu As Object
On Error Resume Next
For Each usermenu In CommandBars
If usermenu.BuiltIn = False Then usermenu.Visible =
False
Next

try this, if BuiltIn = False is a user Menu custom menu.
 
J

Jonathan Blitz

Is there a way I can use this to selectively enable/disable entries in a
user defined menu?

I have a menu bar in wich some of the entries are only valid at certain
times. I don't want to remove those entries - just "grey them out".


--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a menu on Access 2007 form 0
Menu-bar missing when launching Excel 9
how to programatically remove recent files from file menu ? 2
Click Excel custom menu item via MFC automation 0
Removal of menu bar in access 2007 with module coding 2
Startup form - how to call DoCmd.ShowToolbar "Menu Bar", acToolbar 2
Report: Merge it to Word via VBA 0
Can I modify the default shortcut menu in access 2007? 3

Top