User or Group information from access automation objects in macro window

[Alan Cantor]

Hi, your help is much appreciated.

I'm writing an Access 2002 db that has it's own mdw user/group definitions.
After a user logs on and is using one of the forms, they have the option to
check a box.

Basically, I would like to give the ability to check this special box to
admin users and NOT regular New Data Users. How do I do this?

My thoughts were to use the vb (alt-f11) macro code builder to check the
(Access.Users.CurrentlyLoggedOnUser.Group - pipe dream eh?) access
automation object somehow to extract the group or the username or the
userlevel (anything) from within the CHECKBOX_ONCLICK event. You know..
something like...

sub checkboxname_onclick()
'this ? ...
if user.level < 1 then
msgbox("you're hosed")
end if
'or this ? ...
if user.group <> "adminGroup" then
msgbox("too bad buddy")
end if
end sub

Basically, my question is .... IS this a way to access the
currently-logged-on-user information programmatically from the access
automation objects available in the F2 object browser?

Thanks for your help,
Alan Cantor

 

[Joan Wild]

There is a function in the security FAQ you can use to determine if a user
is a member of a particular group.
http://support.microsoft.com/?kbid=207793

 

[TC]

Alan

Joan has given you the answer.

Just a tip. If 'Access.Users.CurrentlyLoggedOnUser.Group' did exist - which
it doesn't, as you know - it would not really be an "automation" object. It
would just be part of the normal Access object model. "Automation" is where
you run Access from within some other program, & reference the Access
objects, methods & properties from within that other program. So it is best
not to use the term "automation" when referring to normal Access objects,
used within Access in the normal manner.

HTH,
TC