UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> User Groups    
 
   
alexf4
post Apr 25 2007, 11:21 AM
Post#1



Posts: 69
Joined: 14-March 06



Anyone know if there is a Method I can use to establish which group a user is a part of, something similar to the CurrentUser Method?
Go to the top of the page
 
freakazeud
post Apr 25 2007, 11:22 AM
Post#2


UtterAccess VIP
Posts: 31,413
Joined: 23-September 04
From: NC, USA


Hi,
check this article. It gives samples for what you want to achieve.
HTH
Good luck
Go to the top of the page
 
dallr
post Apr 25 2007, 01:46 PM
Post#3


UtterAccess VIP
Posts: 3,078
Joined: 4-November 04
From: The Land of the Access Ninja's


This would also help you might need to tweak it.
CODE
Function UserGroupListing()
Dim Grp As Group
Dim Usr As User
For Each Usr In DBEngine(0).Users
    Debug.Print "UserName:" & Usr.Name
    For Each Grp In Usr.Groups
        DBEngine(0).Users(Usr.Name).Groups.Refresh
        Debug.Print "--------Group:" & Grp.Name
    Next
Next
End Function

Dallr
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th December 2017 - 04:19 PM