U UTK Engineer Bound Local time Today, 05:39 Joined Oct 13, 2004 Messages 17 Nov 11, 2004 #1 In my DB, i have three different groups with permissions. What i want to do is hide the menu bar and DB window when any one from two of those groups logs on, but not the third. Is there some code i can write for this? Is it even possible?
In my DB, i have three different groups with permissions. What i want to do is hide the menu bar and DB window when any one from two of those groups logs on, but not the third. Is there some code i can write for this? Is it even possible?
ghudson Registered User. Local time Today, 08:39 Joined Jun 8, 2002 Messages 6,194 Nov 12, 2004 #2 If you are using Access security with user workgroups and permissions then this will work... If CurrentUser = "Clerks" Then 'do this ElseIf Currentuser = "Managers" Then 'do that Else 'do nothing End If Check out this thread for hiding tool bars... hide all Access tool bars and menu bars
If you are using Access security with user workgroups and permissions then this will work... If CurrentUser = "Clerks" Then 'do this ElseIf Currentuser = "Managers" Then 'do that Else 'do nothing End If Check out this thread for hiding tool bars... hide all Access tool bars and menu bars