This is one step beyond the usual problem, which is to have a text or
memo field which can (in effect) be added to but not edited, and is
relatively straightforward to implement. If you seriously wish people
to be able to go back to notes entered on the same day and change them
but not have access to notes written on previous days, you have to be
a little more creative. I would do it something like this:
Memo Field called AllNotes in source Table
Memo Field called CurrNotes in source Table
Date Field called CurrNotesDate in source Table
Your form would display AllNotes in a locked (read only) TextBox and
CurrNotes in a regular (read/write) TextBox
The day's notes would be written in the CurrNotes TextBox and
CurrNotesDate would be set to Date() in that TextBox's (or the Form's)
AfterUpdate Event.
You would have code in the Form's OnCurrent Event to check on the
value of CurrNotesDate. If NewRecord is False and CurrNotesDate <
Date(), the contents of CurrNotes are appended to AllNotes, and
CurrNotes is cleared.
Details are left to the student!
Access 2003 Users will type in notes into a data entry
form. They want the ability to prevent users from going
back to a prior day's notes and editing/deleting them.
If they need to correct something, they want the user to
create a new entry in the log.
How can you lock out the editing for records entered
prior to today?
thank you,
Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
