Password protect a control on a form?

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is there any way to password protect specific command buttons on a form
using A2K.
 
Well ...

sub cmdMyButton_Click()
if inputbox ("enter the password") <> "s3cr3t" then
beep
msgbox "no way, jose!"
else
' do stuff.
endif
end sub

If your database was an MDE, the users could not view the code to get the
password.

Of course, this is a >very crude method<, providing no way for authorized
users to change the password (for example). But maybe it would get you
started.

HTH,
TC
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Are password protected WiFi networks secure? 3
Excel Excel macro and passwords 3
Testing for Password on a Form 1
Password Protected Computers 4
Passwords on a Form 2
Opening an Access db within vba 1
button code to open specific excel document 2

Back
Top