Robin-
There's no way to do it in the table (you could do it in SQL Server with a Trigger). You'll have to put code in the Current event of the form you use to edit the table. When you encounter the record, lock all the editable controls.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
On Jun 5, 2014, at 6:23 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have a table which will not grow any more records. The existing
records, with one exception, will be edited.
How do I make that one exception incapable of change?
It cannot be the Key index field because some of the excepted fields
are null and must stay that way.
Many thanks,
Robin Chapple
------------------------------------
Posted by: Robin Chapple <robinski@westnet.com.au>
------------------------------------
Yahoo Groups Links
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar