block switchboard menu for some users

  • Thread starter Thread starter SG
  • Start date Start date
S

SG

Hi,

I'm using access 2002. In my access front end, I have a switchboard with a
couple of menus. Is it possible to block one of the menu?
Thanks,
Sarah
 
SG said:
I'm using access 2002. In my access front end, I have a switchboard with a
couple of menus. Is it possible to block one of the menu?
Click to expand...

If you need to find out the name of the current user, there's a
CurrentUser() function (search Access VBA help for it).

And to determine the current user's groups (lifted from
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
Question 22):

Function faq_ListGroupsOfUser (strUserName As String)
Dim ws As WorkSpace
Dim usr As User
Dim i As Integer

Set ws = DBEngine.Workspaces(0)
Set usr = ws.Users(strUserName)
For i = 0 To usr.Groups.count - 1
Debug.Print usr.Groups(i).Name
Next i
End Function

HTH,
Anno.
 
Back
Top