form controls

  • Thread starter Thread starter janliv1102
  • Start date Start date
J

janliv1102

I am interneing for a company working on their database is access. I have
been asked to put control in the database so once a certain field is updated
in the form it cannot be modified without an administrator. Does anybody have
any solutions on how this can be done/
 
You've not provided any description of how the database is being used. If
the users are opening the tables directly and working directly in them, you
probably don't have a(ny easy) way to do that!

If the users are using forms, you can exert much more control over what they
see and can do.

There is no single, simple way to exert that control ... so much depends on
your knowledge/experience with Access, the data design, etc.

More specific descriptions may lead to more specific suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Yes, users will be opening and using this table. I need the users to be
allowed to update this particular control but once it is updated they no
longer have access to the control and the only person that can modify or make
changes to the control is the administrator. I hope this is more clear.
 
I'm not aware of a way to exert that level of control if the users are
directly using the tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
oh yeah I have firgure out the code to make the control on the form password
protected. Just thought I would let you know that it iws possible
 
Back
Top