Password in access

[Henrike]

hello,
could somebody help me how to create passwords in access? I want to have a securitypassword for some forms and reports. Is that possible? and how can I do it that it doesnt show the letters but just stars for the letters? so that its not visible...
thanks very much!

[MindBender77]

hello,
could somebody help me how to create passwords in access? I want to have a securitypassword for some forms and reports. Is that possible? and how can I do it that it doesnt show the letters but just stars for the letters? so that its not visible...
thanks very much!

you could design a small form (Modal) that would open on the OnLoad event of the main form.

In this Modal form, you could have a simple textbox and an exit button. The textbox would contain the Input Mask of "PASSWORD". This will prevent the keystrokes of the password from being displayed. Only astrisks will be visible.

If the correct password is entered the modal close allowing access to the main form. If the incorrect password is entered you could display a message like "Incorrect Password, Do you want to try again".

Hope this points you in the right direction,
JS

[Henrike]

you could design a small form (Modal) that would open on the OnLoad event of the main form.

In this Modal form, you could have a simple textbox and an exit button. The textbox would contain the Input Mask of "PASSWORD". This will prevent the keystrokes of the password from being displayed. Only astrisks will be visible.

If the correct password is entered the modal close allowing access to the main form. If the incorrect password is entered you could display a message like "Incorrect Password, Do you want to try again".

Thanks, I managed that it just shows asteriks, but the event thing doesn't work. So I type in Event OnLoad "MainMenu" and than it the passwordmanager should appear when I open the MainMenu right? that doesn't work so far...
An how can I tell the box which the correct password will be? Where do I type that in? And where do I type in a message like "incorrect password, do you want to try again"?
Sorry...I'm really not familiar with Access.
Thank you so much!

[MindBender77]

Thanks, I managed that it just shows asteriks, but the event thing doesn't work. So I type in Event OnLoad "MainMenu" and than it the passwordmanager should appear when I open the MainMenu right? that doesn't work so far...
An how can I tell the box which the correct password will be? Where do I type that in? And where do I type in a message like "incorrect password, do you want to try again"?
Sorry...I'm really not familiar with Access.
Thank you so much!

Note I notice this code will only work with a command button.

On the OnOpen event of your MainMenu, your going to need:

DoCmd.OpenForm "passwordmanager", acNormal
 

As for the password entry on the OnClick event of a command button in the Modal form:

Dim msg,style,title,response
 
If Textbox = "yourpassword" then
docmd.close
else
msg = "The password you entered is incorrect. Do you want to try again?"
style = vbYesNo + vbExclamation + defaultbutton2
title = "Incorrect Password"
response = msgbox(msg,style,title)
If response = vbYes then
textbox.setfocus
textbox = ""
end if
if response = vbNo
docmd.quit
end if
end if
 

Hope this helps,
JS