password protect command button

[mic907]

Is it possible to password-protect a command button? In other words, is there a way to require a user to enter a password upon clicking a button, in order for that button to carry out its specified function?

The obvious reason behind doing this would be to only allow only certain users to have specific functions; if it isn't possible, is there a alternative way to do this?

 

[KeithG]

You could have the button open up a username/password form where they can supply the username/password.

 

[mic907]

how is that accomplished?

 

[mic907]

this also might be difficult because I need the command button to set a field equal to a certain value for a particular record

 

[pbaldy]

If InputBox(...) = "ValidPassword" Then
  'Do your thing
Else
  MsgBox "wrong password"
End If

 

[mic907]

also how can i hide the values typed in under the password textbox (ie: how can I make it so that when a person types in a password, the entry is shown as '*'; ie: '********' as opposed to 'password')

 

[pbaldy]

Normally I would have said you can't format an input box, you'd have to create a form and use the input mask, but I remembered this (ghudson's post 4 in particular):

http://www.access-programmers.co.uk/forums/showthread.php?t=115564