Access Menu "Customize" item

[jeff]

Hi

I have a small Access app in which I need to disable the menu bar
<right-click> customize setting or even the <right-click> in total on the
menu. This is because I have a customized menu bar and dont want users doing
customization during them opening forms etc.

Is there an easy way to disable this at startup in code or otherwise?

cheers
Jeff

 

[Albert D. Kallal]

In the tools->start-up....

just un-check the box that says

[] Allow Default Shortcut menus.

And, another way is to build your own short-cut cut menus ..and specify that
for the form.....

 

[jeff]

Thanks for the reply Albert, but that dosent do what im after...maybe you
missed the issue. Its not the shortcuts menu for forms im talking
about...its the standard Access menu rightclick shortcut which allows you to
turn on/off enabled toolbars and to "Customise" the toolbars.
The setting in the Startup does not disable this...well for me anyway!

cheers
Jeff

 

[Albert D. Kallal]

Ah, ok....

It sounds likey you much want to lock things up....

In the tools->startup, uncheck the otpion that says:

[x] Allow tool bar, menu changes.

if you un-heck the above..then users can't change the menu...

I some more tips that follow::::

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[jeff]

thanks again Albert,

I do all the necessary things to secure the application and have a
customised menu bar for running the app. what I wanted to do was just
disable the right-click customise item via code on my startup form. I have
used

Application.CommandBars.DisableCustomize = True

which works a treat!!

thanks mate!
jeff