By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,805 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Locking records

P: n/a
G
I'm using Access 2000. I have a form that users will use to fill out various
fields. I would like create another form or datasheet where the manager can
simply tick off ( there is a column field for this tick) records which will
effectively lock that record. So that a normal user cannot alter/change any
field of that record. Its simply associating that tick to freezing the
record.
I don't necessarily want to introduce the logon restrictions that access can
facilitate.
thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mon, 16 Feb 2004 07:09:23 +1100, "G" <sk**@optusnet.com.au> wrote:

Perhaps a one-liner like:
Me.AllowEdits = Not chkTickmark
in the form's Current event will do.
But if managers are still allowed to take the Tickmark off, this code
will have to be smarter.

-Tom.
I'm using Access 2000. I have a form that users will use to fill out various
fields. I would like create another form or datasheet where the manager can
simply tick off ( there is a column field for this tick) records which will
effectively lock that record. So that a normal user cannot alter/change any
field of that record. Its simply associating that tick to freezing the
record.
I don't necessarily want to introduce the logon restrictions that access can
facilitate.
thanks.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.