form control restrictions

[Nawab]

There is a control on a form that I want to give only certains users
permission to enter data. Basically this field if to be signed by a
manager. I want to perhaps ask for a 4 digit pwd or something when this
field gets focus. Can this be done with macros, or do I have to use VB
for it. Not familiar with VB, please advise.
Thnx
Nawab

[Larry Linson]

"Nawab" wrote

There is a control on a form that
I want to give only certains users
permission to enter data. Basically
this field if to be signed by a
manager. I want to perhaps ask for
a 4 digit pwd or something when this
field gets focus. Can this be done
with macros, or do I have to use VB
for it. Not familiar with VB, please
advise.

You could ask for the code using an Input Box, in the Click event of the
Control. That, I am sure, could be done with a macro. The problem, of
course, is how you are then going to check that the password is a valid one.
What you describe is a kind of "security lite" that will be easy to break.
Even Access' own security is not foolproof, but it would be much harder to
break than your own password list.

It does sound like something more complicated than simple macros. Because
macros do not support error handling, I haven't used any for years except
AutoExec and AutoKeys, so perhaps someone with more recent experience can
give you a "macro solution".

Larry Linson
Microsoft Access MVP