Password on opening a form

[Groundrush]

Does anyone know how to password protect forms on a database without having to put a password on the whole database?

thanking you in advance

 

[llkhoutx]

Prior to or OnOpen, prompt user for the password,if it's good open your form, otherwise give a message that user access is not allowed.

 

[Groundrush]

Thanks, but how do you create a password for a form only? the security in tools secures the whole database.

 

[Hayley Baxter]

Use a command button and put this code behind it.

Private Sub Command1_Click()

Dim strPasswd

strPasswd = InputBox("Enter Password", "Restricted Form")

If strPasswd = "Type your password here" Then

DoCmd.OpenForm "FrmAmendDatabase", acNormal

Else

Beep

MsgBox "Only members of the Admin Group can amend this database application"

Exit Sub

End If

End Sub

Hope this helps
Hayley

 

[cwash]

Hayley, when you say to put the code behind the button, does this mean a new line of code and do away with the Command0_Click()line or add your new line of code below the Command0_Click() line?

I'm new and wanting to understand.

Thanks

 

[Fuga]

cwash, I think the line you´re talking about corresponds to Hayley´s first.

Fuga.

 

[cwash]

Fuga, thanks for the help. I got it to work. But...when I type in the password, I see the password spelled out! This would not be any good if someone is standing over my shoulder! So, how do you get it to NOT show the word but rather the ***'s.

TIA

 

[Fuga]

Don´t know that, but maybe you can make the text invisible?

Fuga.

 

[cwash]

How would you do that?

 

[Hayley Baxter]

A post on how to do this came up just recently. Try here: http://www.access-programmers.co.uk/ubb/Forum4/HTML/006931.html

Hayley

 

[DBL]

I've got a password sample. If you want it, email me and I'll forward it on.

 

[Groundrush]

thanks for your help

 

[DW]

DBL

I would really appreciate your example also.

Would you mind mailing it to me.

Thanks

DW

 

[cwash]

DBL, I'd like the sample also if I could.
How do I get your email?

Thanks

 

[DBL]

You can get my email address from the envelope icon on my posting.

dawn.lawson@1stclass.uk.com