Disabling menu items?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy - 30 Dec 2003 01:05 GMT

How can I disable, for example, the 'delete record' menu
item from the Access application menu bar? My dB security
has delete permissions removed for non-admin users for all
forms, but the application menu bar still allows record
deletion - am i missing something? Thanks in advance,

Andy

Reply to this Message

ALESSANDRO Baraldi - 30 Dec 2003 13:14 GMT

> How can I disable, for example, the 'delete record' menu
> item from the Access application menu bar? My dB security
[quoted text clipped - 3 lines]
>
> Andy

You need of "Microsoft Office xx.xx Object Library" on your reference, so on
startup use this :
Application.CommandBars("Menu Bar").Enabled = False

Remember to Enable it on Close Application....!!!

Alessandro(IT)

Reply to this Message

Chris O'Neill - 30 Nov 2004 17:47 GMT

I like your solution. It doesn't seem to work for me though. It does recongnize the code, but nothing gets disabled. Do you have any suggestions? Where is the startup code written? I have been putting it in the startup forms open event...and it gets executed, but the menus still work.

thanks,
c-note

Reply to this Message