Question - how to remove tool bar options when application is open

[Murphy]

under the HOME options in Access 2007, I want the XDelet option to be greyed out so no one will have the ability to use it while in the specidied database. Can this be done?

 

[the_net_2.0]

under the HOME options in Access 2007, I want the XDelet option to be greyed out so no one will have the ability to use it while in the specidied database. Can this be done?

making an executable file will remove it (and all menus, for that matter). I don't believe using the commandbars collection will do it in 07 versions, because the structure is different (I think).

you can also uncheck the "allow full menus" option in the options menu. that takes it away in 07 versions, but the shift bypass key is still available to bring it back if used.

 

[Dairy Farmer]

Why not remove the Ribbon comletely and create buttons for the actions you would like the user to have.

Private Sub Form_Open(Cancel As Integer)
    DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Sub

Or create your own Ribbons using the USysRibbon table.

 

[Murphy]

Thank you the Net 2.0 and Dairy Farmer, rethinking this particular database, Dairy Farmer, you have a good idea, removing it completly will be just fine. No one needs to use any of the options available in the tool bar, I already have all the buttons they need to use in the database forms. Thank you for that information, and the net 2.0, that too will work on some of my other databases where they can use the tool bar but being able to remove some options is great. Not all users will know about the shift key trick so I dont think that will be a concern. Thanks again for your ideas.

 

[Dairy Farmer]

Not all users will know about the shift key trick so I dont think that will be a concern.

ALWAYS make your app, at least, an accde. Even better is to rename your accde to accdr. This forces The app to open in Runtime which disables the Shift and F11. Users can still rename the file accde though. Just one more layer to ward off the EBKAC errors.

 

[Murphy]

thank you Dairy Farmer,
I tried adding the code you suggested and it still allows the tools to be available. I am not an expert in Access but I do know some things, I am still learning the VBA side of it. I opened the main form in design mode and thought that is where the code should be applied, is there a main area this code should be to work on all menu items? I noticed the one area I dont want the ability for the user to delete still has it available.