Unanswered: Toolbars controlled by Security Groups
I have a database with security set up by groups. I would like to create specific toolbars for accessing forms based on Security Groups. This I can do but I have no idea how to show only the toolbar for the person who is logged in. Help would be greatly appreciated.
another consideration is separate FEs. That is pretty common for me. I have an 'Admin' FE that keeps leaves in all tools but a User FE where it is stripped down.
now getting into multi FEs becomes a hassle if development isn't complete - as you will end up with 2x or 3x the work for each change.
I don't know if there is a way to 'call' in a custom tool bar based upon a value. So let's say you have a log in screen that establishes a value for the user....then when other forms are opening during the OpenEvent (or Load) it looks at that value of the login screen and then dynamically calls in a custom tool bar. That may be possible. It would be sexy.
Select Case CurrentUser()
DoCmd.ShowToolbar "Menu Bar", acToolbarYes
DoCmd.ShowToolbar "AdminTools", acToolbarWhereApprop
DoCmd.ShowToolbar "Menu Bar Admin", acToolbarNo
DoCmd.ShowToolbar "Menu Bar Users", acToolbarYes
DoCmd.ShowToolbar "AdminTools", acToolbarNo