ReadOnly Form

[Guest]

How would I create a password to access a form and also have it let you just
bypass the password and enter the form as a read only? I'm looking to create
something similar to the excel password box with the read-only on it. You
know how when you open an excel file that is password protected it asks you
to enter a password to edit otherwise click "Read Only". Can this be done in
Access? If so, how would I do this?

 

[Joseph Meehan]

How would I create a password to access a form and also have it let
you just bypass the password and enter the form as a read only? I'm
looking to create something similar to the excel password box with
the read-only on it. You know how when you open an excel file that is
password protected it asks you to enter a password to edit otherwise
click "Read Only". Can this be done in Access? If so, how would I do
this?

I have been watching this one for a while. I was hoping someone would
answer your question who has done this and might have some sample code.

You could have a procedure in the On Open event for the form that would
request the password and if the password is provided continue or if not set
the properties of the form to read only.

This would not be very secure, but as long as you are not trying to
really secure it, but rather just keep someone from accidentally editing, it
should work. You might use some event prior to update as well. That could
stop someone from updating it.

I have not tried any of these so I am doing some guessing.

Maybe my response might prompt someone else to respond.

 

[Guest]

Thanks for responding! I think your idea will work for what I need. I'm not
looking for security, just trying to prevent certain users from editing the
data in the form.
I'll look into this in more detail. Thanks again!