Create a password Form

[heman85]

Hello.
I try to create a form for this module http://support.microsoft.com/kb/209871

This is a module from Microsoft to create a password code to enter into a form.

I need create a Form for add a Form what I want to protect and to set and change that existing password. Password is generating by a code using this module "microsoft link Module". Pls open the link to see the module. http://support.microsoft.com/kb/209871

Thanks for help me.

 

[khawar]

Attached a sample for password protecting forms and reports

Just import the module "ChkPassword" and table "tblPasswords" in your database

open table "tblpasswords" and enter the name of form or report you want to protect

then in the on open event of report or form you want to protect enter the code below

    If Password(Me.Name) = True Then
        Else
            DoCmd.CancelEvent
    End If

Check the sample for reference

 

[heman85]

Working PERFECT THANKS MAN

1 more think... Can I set The Password Popup to open a Expecific Password Form?

Or How Can I Edit the Popup Windows Asking for password?

Pls Let Me Know Thank You So Much

 

[khawar]

You can edit the input box in the module

 

[JackBauer]

i can't open that Zip file from my computer and im having the same question that heman85 has. Could you tell me how to change the default password to something else?
thanks much.

 

[khawar]

go to table "tblPasswords" passwords are saved there along with the names of the objects which are protected

 

[JackBauer]

Could you elaborate? In the tblPassword, the keycode is masked with the original code of 2818. Should i change it to something else?

 

[khawar]

ofcourse you can change it

 

[JackBauer]

i changed the Keycode to something else. However, when the form that promts for password opens, i can't type in the new password. Please help... thanks.

 

[khawar]

I am not able to understand where you are getting the problem

Its very simple add the object name and password to open in the table which you want to protect and if it is already in the table change the password there to remove the password simply delete the entry from the table

thats it

 

[JackBauer]

this is what i have: tblPassword, frmPassword (with textfield "Text0" and command button "CheckPassword", and the form that i want to protect "HR only".
In tblPassword, i have objectname: HR Only and keycode: 2818 with input mask password.
So when i open the form i want to protect "HR only", it prompts for password with the "frmPassword". In there, i type: PASSWORD, which is the default password. However, i want to change that to something else.
I tried to change that in tblPassword, but it didn't work. Please help, i apologize for the questions.

 

[khawar]

Upload your ammended sample

 

[JackBauer]

Attached is the sample database. The keycode that i entered is 2818. The default password is PASSWORD. I'd like to change it so something else. Thanks much for your help.

 

[JackBauer]

Khawar,
I posted my sample database as you requested. When you get a chance, please take a look and let me know what i'm missing.
Thanks much.

 

[khawar]

If you have downloaded my solution it was different it was based on inputbox rather then form to prompt password

 

[khawar]

Download the ammended file

 

[heman85]

Another question...
How can I set the inputbox format to *****
Right now If you type on the inputbox Show text I want to hidden the text with *****

Pls help Thanks

 

[JackBauer]

select "input mask" should do it.

 

[JackBauer]

see attachment

 

[WayneRyan]

Jack,

Just hacking around with this.

The KeyCode for "HR Only" should be 2693.

Change it in tblPassword and you should be ok.

Wayne