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.

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?

Show quoteHide quote

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



Show quoteHide quote

Access-New User-Help!!
Security nightmare - 2 mdw's mixed up
Diff Workgroups, Same DB, diff Security
log on screen in Access?
Programatically hide and unhide the database window
can't run report from crystal reports
Self-Signed Certificate how to export?
Access 2000 Security - Workgroup, Owner, User Permissions etc., H
search form not working properly
MS Access 2003 - Owner