How do I limit who can enter data into a field, manager's approval

L

Leslie

I want to limit who can enter data into the field where a manager will put
their name to signify they have approved the request, that manager should
only be able to pick there own name from the list? Or a check box and the
manager logged into the database's name would pop up as approval. This
database is used by several product lines with different managers approving
for their product line.
 
M

MacDermott

For an elegant, scalable solution, learn about and implement Access
security, using an MDW file. Note I put "learn about" first - that's not
trivial.
For a "quick fix", assuming your managers each work consistently from a
single machine, you could create an entire separate front end MDB file, only
give it to managers, and only put it on the "approved" checkbox on it. If
need be, you can use fOSUserName() from www.mvps.org/access/apis to capture
the name of the machine.

HTH
 
D

Douglas J Steele

I always recommend very strongly against using environment variables for
this purpose, as they're trivial to reset. Far better is to use the API call
 
Top