Identifying user groups

[danikuper]

I've got a database where different forms show up depending on the user who logged in by using the CurrentUser function.

Is there a way to identify the group to which the user belongs? I couldn't find any function to be used in a macro or event that will give me that value...

thanks!

 

[Mile-O]

You could store a list of the users' usernames in a table and their access levels or forms that they can open, or something, and a lookup can determine what form to open.

Just a suggsetion...

 

[Autoeng]

Use this

If InStr(UserGroups(), "whatevergroupyouspecify") <> 0 Then

Autoeng

 

[danikuper]

Humm... I tried your code but it doesn't seem to work. I'm getting an error message "Compile error: Sub or Function not defined".

Any ideas?

thanks!

 

[Autoeng]

Post the event code where you tried it.

Autoeng

 

[ghudson]

Check this out...

Sample Functions to Check User and Group Information

The functions will work for Access 97 and newer.

HTH

 

[danikuper]

That's a great resource! I'll check what they say and see if it works... will post my results in this thread.

thanks!