Switchboard Security

[Olu Solaru]

Is there a way to restrict users from clicking on a command button on the
main switchboard.

Scenario:
I have created two groups, manufacturing and regulatory.

On my switchboard I have approximately 10 command buttons. Out of these
command buttons, I would like for the Manufacturing Group to only be able to
click on the Close command button, Reports Menu Command Button, and Add New
Lot Number Command button, once the users ( Manufacturing) log into the
database.

 

[Olu Solaru]

I was looking at going into the Private Sub Form_Current() , but the only
problem is that I used the Switchboard Manager to design my Switchboard,
could this make a difference?

 

[Joan Wild]

Ditch the Switchboard Manager created switchboard and create your own
unbound form for this.

You have more flexibility in what goes on the switchboard, and for things
like limiting access to particular groups, it is easier.

I would suggest you just hide the buttons that certain groups shouldn't see,
as users might get annoyed with being presented with a button, and then told
they can't get there.

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

Then in the On Open property for your form, create an event procedure with
something like:

If faq_IsUserInGroup("Managers",CurrentUser()) = True Then
Me!cmdSomething.Visible = True
Me!cmdWhatever.Visible = True
End If