Microsoft Access
--
Questions
--
Followers
Top Experts
ms access 2k10 navigation pane, how to freeze to acustom category
Have a split db app in ms access 2k10 that uses the Nav pane custom categories for various user groups to only see those options/tasks appropriate to their group. I know what user is logged in and would like to "freeze" their Nav Pane view such that they cannot change to any other view. This would be a much preferred approach over having multiple front-ends.
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
If you have a database built with A2003 or earlier that has a Switchboard form and Switchboard Items table, it would be simple to add a new column to the Switchboard Items table and you could use that to control what Items are allowed based on who is logged in. Newer versions of the Switchboard are controlled by embedded macros and so would be more difficult to customize.
Pat I'm using A2010/13
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Thank you
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.