Remove menues from access via VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
yeah, that removes the custom file menu, but not if the user has own custom menus in acces?

Erik
 
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.
 
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."
 
Back
Top