Password question, please help :)

[Alberta Rose]

I have a switchboard with three buttons on it. I would like to password
protect one of the buttons because it is for administrator use only. How do
I do this?

Thanks.

 

[Beetle]

Use something like the following in the button's Click event code.

If InputBox("Enter a password") = "YourPasswordHere" Then
'the procedure code for the button goes here
Else
MsgBox "Invalid password. Operation cancelled."
End If

 

[Daniel Pineault]

Take a look at

http://support.microsoft.com/kb/209871/en-us

everthing you need is there.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.