Password Protect form

I have a command button on a from that opens up a second
form. Is there any way that i could add password
protection to this button to stop others opening up this
form. Any help would be much appreciated

Cheers

A simple code based solution would be to prompt the user to enter the
password using an input box and then compare what they enter to a hard coded
password in code. Of they match open the form. If not electrocute them, I
mean don't open the form. You could event use a small custom form instead of
an input box, then you could use the Password input mask to show just
asterisks so others don't get the password by looking over someone else's
shoulder.

If the right password is entered you could than pass that to the opening
form as an open argument and add additional checks OnOpen to make sure it is
the correct password. That would prevent someone opening the form directly
from the database window.

Of course is users have access to the code and know what they are doing they
could get around it, but if you are using only to "encourage" people to not
open the form it will work fine. Also if you are running in runtime mode
they won't be able to get to the code. You could convert the database to an
MDE to prevent access to code, but that is only recommended if you maintain
a separate copy for further development work as MDEs cannot be modified

Tony Vrolyk

wrote in message
...
I have a command button on a from that opens up a second
form. Is there any way that i could add password
protection to this button to stop others opening up this
form. Any help would be much appreciated

Cheers

You could implement User-Level security and then not grant certain users
access to the 'protected' form. Why reinvent the wheel by coming up with
complicated password scemes and coding events? Just use the built in
security.

An added advantage is taht you sign in one time when you open the database
and your security permissions are set. No need to constantly type in
passwords everytime you try to open a form or run a report.

Rick B


wrote in message
...
I have a command button on a from that opens up a second
form. Is there any way that i could add password
protection to this button to stop others opening up this
form. Any help would be much appreciated

Cheers