How is disable menu choice?

[Leif]

I have several menus defined for Access 2010. However, only one is set with the visible property set to true.

The user is able to show and bring up the other menus by right-clicking in the menu area. How can I disable this so the user may not bring up these menus? An example is shown in the picture below. I don't want to give the user access to the "CPLAccess" and "Datasheet column removed" menus, but I do want to keep them so that I can make them visible via VBA.

 

[GohDiamond]

If these are user defined functions on a shortcut menu then you need to check who is logged in to the database(Network User) and build a security point into the customized function with a call to a security module where you determine who is allowed to see which menu.

Otherwise you can place security on forms used to display your datasets in each form VBA module.

Search the forum for setting up security in vba or forms to get some samples of how to do this. If you've never done it before you may need additional help which you can ask for here with a narrower focus after digesting some of those security topics.

Cheers!
Goh

 

[Leif]

This pop-up list is commandbars that were marked as menus in Access 2003.

Having done some additional research and experiments it appears that if I go to the options screen and Current Database/Ribbon and Toolbar Options and unselect "Allow Default Shortcut Menus" then I no longer get the menu choices when I right-click on the menu bar.

I'm not sure what effect this will have on other parts of my application. I'll need to investigate that.

 

[Leif]

That eliminated the right-click popup, also it also eliminated the use of the short cut menu on the database objects when I work in the navigator. That is no good.

Anyone have any idea how to eliminate the menu short-cut without remove other short-cut menus?

 

[GohDiamond]

Reinstate the Shortcut Menu as it was before.

On the specific form that the users have access to, find the ShortCut Menu Property on the FORM Property Sheet and set it to "NO"; OR change the Selected Name in the Shortcut Menu Bar or make it blank for the default menu.

Cheers!
Goh

 

[Leif]

Thanks for your response.

The problem is not on a form. The problem is the toolbar menu at the top of the screen (see pic on first post). I don't want that toolbar menu to allow a short-cut as shown. Is there a way to turn that off?

 

[GohDiamond]

OK, I'm judging from the looks of the QAT that you have, that it's NON-STANDARD, and therefore must be the names of some Macros that exist in your database. Although you may not be able to 'DISABLE' the shortcut menu that appears when you right click, you should be able to modify the macros that are run when selected. You should be able to rewrite those macros to check for the user and 'Disallow' use of any macro that is proprietary to the Admin or yourself.

What does your 'Admin Support' command do? Because I don't find Admin Support as the name of any command available for the QAT unless it's the name of a macro called Admin Support which does something like open a specific form from which something can be modified.

Gonna need more information about what these selections trigger
Goh

 

[Leif]

They are not macros. They are custom menus. I have their .visible property set to false, but they can appear by right clicking on the menu bar. The menu that does appear has its .visible property set to true.

I used several menus depending on the security level of the person logged in. Of course I don't want people to open menus to which they should not have access.

As I mentioned earlier, I can disable it. I do that by turning the option "Allow Default Shortcut Menus" to off (unchecked). However, this has a negative impact on my use of the shortcut menu for other features, such as in the navigation pane.

"Admin Support" is a custom menu offering several commands such as view current database users, compact and repair the database, etc. It is part of a custom menu I made, so you will not find it as part of any built-in feature.

 

[Leif]

I think I finally found the solution to my problem.

Under Access 2003 you simply need to uncheck the Tools/Startup option "Allow Toolbar/Menu Changes". That would disable the short-cut menu for the toolbar, but allow you to keep the "Allow Default Shortcut Menu" checked.

Unfortunately, this checkbox, for some reason, was dropped in 2010 (or perhaps 2007, but I went directly from 2003 to 2010). Fortunately, however, it is still accessible via VBA coding. I simply need to change the database property "AllowToolbarChanges" to False.