Form Security

[lmossolle]

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!

 

[Douglas J. Steele]

You can, but it won't be very secure.

See http://support.microsoft.com/?id=209871 for one approach.

 

[scs]

I also wanted to know how to do this. So thanks for the info. I got it to
work for my form but I can't get anything but the error message RunTime
Error 13 Type Mismatch when I try and determine the keycode for new
passwords by typing ?KeyCode("TestString") in the immediate window? How do
I determine the KeyCode for a text string like password?

 

[Arvin Meyer [MVP]]

Try locking controls:

http://www.datastrat.com/Code/LockIt.txt

based upon who the current logged on user is:

http://www.mvps.org/access/api/api0008.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Douglas J. Steele]

Did you copy and paste the code, or did you type it? If you typed it, are
you sure you typed it correctly?

I just copied the KeyCode routine from that webpage, and it worked fine for
me.

 

[scs]

Here is the only part from the web site I don't get?
Do I have to be somewhere special in the code when I do this?

20. To determine what the corresponding KeyCode is for a particular
string, type the following in the Immediate window and then press ENTER:
?KeyCode("TestString")




How do I change the password? Let's say for example I want to change the
password from PASSWORD to PassWord2. I don't understand how to change it at
all.

 

[Jeff Conrad]

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:

 

[scs]

Thanks got it!

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: