Enable / Disable MS Access Button

[sinvier]

I need help with a vba code to only allow people who are logged in as Admin to be able to open a button called Manage Users and at the same time grey it out for people who log in as User. Thanks in advance for the help!

MS ACCESS 2013

[Seth Schrock]

Do you mean logged into Windows as Admin or do you have a login system for your database?

[twinnyfo]

sinvier,

Take a look at this thread and see if it provides you any additional guidance (User Permissions in MS Access).

[sinvier]

I figured it out, thanks though and Twinnyfo that was a good read. Thanks.

If strCBOPass = strPassword And strUsertype = "Administra tor" Then

DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "Main_Form"

ElseIf strCBOPass = strPassword Then

DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "Main_Form2 "