G
Guest
Can I put a password on a form that will give access to certain fields? I am
trying to eliminate some additional databases. Please assist!
trying to eliminate some additional databases. Please assist!
Jeff Conrad said:Here are some instructions I have posted in the past:
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("PassWord2")
Where PassWord2 is the new password you would like
to have. Hit Enter.
A number will be displayed in the window. Write it down.
(it could be a negative number as well)
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.
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html
in message: