CODEWITHSUNDEEP
ms-accessdrop-down-menuvbams-access-2013
jjjjjjjjjjj
jjjjjjjjjjj

Reputation: 447

Disable Access 2013 navigation pane options

I need to prevent users from modifying underlying tables and code in an Access form.

I found this excellent answer which works exactly as described. The form design is permanently hidden and Access Options are disabled.

However, if I click the dropdown arrow by the navigation pane header and select anything in Navigate to Category, I can still view (but not edit) all underlying tables, queries, and forms.

Is there a way to change or remove options in this menu?

Navigate to Category menu

Upvotes: 1

Views: 1729

Answers (1)

Dave B
Dave B

Reputation: 659

You can use this code:

DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide

The code should be initiated on the form load event. If you are using some sort of login system you might want to enable it for all users bar the DB Admin.

Upvotes: 1

Related Questions