Change Password for a Protected Form

[LaVelle Blackwell]

Hello Everyone:

I used Microsoft Knowlege Base Article - 209871 to Create
a Password Protected Form.

Now, I would like to make up my own password instead of
using the default password given in the article.

How do I go about making this happen?

Thanks,

LaVelle...

 

[Jeff Conrad]

Hi LaVelle,

Assuming you have done everything correctly, open the
module in Design View and then go to the immediate window
by hitting CTRL-G on the keyboard.

Type this line of code in the immediate window:

?KeyCode("mypassword")

Where mypassword is the whatever password you would like
to have. Hit Enter.
A number will be displayed. Write it down.
Close the module.
Open up the TABLE that you created for this and enter that
number into the field called KeyCode (The password mask
will hide the actual number you put in.)
The password should now be changed.

Incidentally, I've created custom forms to handle this.
Makes it a lot easier.

Hope that helps,
Jeff Conrad
Bend, Oregon