User Login That Disables Certain Buttons

[neuhur]

Hello Everyone,

Please help.

I created a form with an "add record" and "delete record" button. I need to create a simple login form for 2 users (user1 and admin1) that will disable able the "delete record" button when the user, "user1" logs in. Whenever the user, "admin1" logs in, then both "add record" and "delete record" buttons are enabled.

What is the easiest way to accomplish this? Thanks in advance for your help!




Thanks,
Neuhur

[Xipooo]

Well my first question is, do you plan on adding any more users in the future? Depending on how you answer that could go in two completely different directions.

[June7]

When user logs in, need to store their ID or privileges code somewhere so it can be referenced in subsequent procedures. I store value in a textbox on a form that never closes (main menu). Then when another form is opened, code in form Open event is like:

If Forms!MainMenu.tbxCode = "user" Then
Me.btnDelete.Visible = False
End If

[orange]

If you don't want to make the button invisible, you could disable it ( it would still appear but inoperable).

I'm not suggesting, just giving another option for consideration.

[Xipooo]

When user logs in, need to store their ID or privileges code somewhere so it can be referenced in subsequent procedures. I store value in a textbox on a form that never closes (main menu). Then when another form is opened, code in form Open event is like:

If Forms!MainMenu.tbxCode = "user" Then
Me.btnDelete.Visible = False
End If

You may also want to hide the login form so that no one accidentally closes it.

[neuhur]

Per the requirements, there will only be two users, "user1" and "admin1".

[neuhur]

That's a possible solution to test. How would I accomplish the enable/disable of the button based on what user logs in?

[June7]

See post 3.