two seprate passwords. One for admin the other for users

[Guest]

When a user clicks on the icon a switchboard comes up just for the users. When an admin clicks on the icon the same switchboard comes up but with additional button just for the admin. How do I do this?

Please help

 

[Joan Wild]

Assuming you've implemented user security, you can determine if a user is a
member of a group, and set the visibility of the button on the form.

I'd also suggest you create your own 'switchboard' form, rather than use the
switchboard manager.

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

--
Joan Wild
Microsoft Access MVP

When a user clicks on the icon a switchboard comes up just for the users.

When an admin clicks on the icon the same switchboard comes up but with
additional button just for the admin. How do I do this?

 

[Joan Wild]

You've confused me. You've implemented security and you have an Admins
Group and a DataEntry group.

I understood that you wanted a button on your main form to only show for the
Admins Group.

Paste the function from the security FAQ into a standard module.

In the Open event for your switchboard form you would put
If faq_IsUserInGroup("Admins", CurrentUser()) then
me!YourButton.visible = true
Else
me!YourButton.visible = false
End if


--
Joan Wild
Microsoft Access MVP

I have built the switchboard from scratch and set the button property. Why

would the code have anything to do with the security for which I am trying
to accomplish? Sorry it is late and I am tired.

 

[Guest]

ok this code will work but I must have "admins" as my workgroup? What is this code reading from. Very sorry for pinhead thoughts.

 

[Joan Wild]

Admins is not the workgroup. A workgroup file is one with a mdw extension -
its name would be whatever you named it.

You said you had an 'admins' group and a 'users' group. I hope that you
didn't use the built-in users group, but created the security groups you
needed.

'Admins' 'DataEntry' are the names I used in the example. Substitute the
names of the groups *you* created in your workgroup.

--
Joan Wild
Microsoft Access MVP

ok this code will work but I must have "admins" as my workgroup? What is

this code reading from. Very sorry for pinhead thoughts.