Get username

[Guest]

Hi

I can make users into access and make groups
but how can i see the name on the user?

Alvin

 

[Guest]

Just use the variable named CurrentUser

"alvin Kuiper" schreef:

 

[Guest]

Thanks
its working
Maybe you also know if i can get the group name
like if the user is admin ot user

Alvin


"Dirk" skrev:

 

[Guest]

Yes but in that case we are speaking of groups rather than one group. A
function to get a user's groups by user name would be:

Function getGroupsByUsername(ByVal strUserName As String) As Collection
Dim objGroup As DAO.Group
For Each objGroup In DBEngine(0).Groups
getGroupsByUsername.Add objGroup.Name
Next objGroup
End Function

"alvin Kuiper" schreef:

 

[Douglas J Steele]

Since a user can belong to more than one group, it's not possible.

You can determine whether or not a user belongs to a given group, or you can
list all of the groups to which a given user belongs, though.

There's sample code for both in the Access Security FAQ
http://support.microsoft.com/support/access/content/secfaq.asp

 

[Guest]

Thanks
its working
Alvin


"Dirk" skrev:

Yes but in that case we are speaking of groups rather than one group. A
function to get a user's groups by user name would be:

Function getGroupsByUsername(ByVal strUserName As String) As Collection
Dim objGroup As DAO.Group
For Each objGroup In DBEngine(0).Groups
getGroupsByUsername.Add objGroup.Name
Next objGroup
End Function

"alvin Kuiper" schreef: