
November 2nd, 2009, 09:01 PM
|
 |
Contributing User
|
|
Join Date: Jan 2007
Location: Northern California
|
|
Quote: | Originally Posted by wealy92 Hi
I have a situation where users can only edit forms if they are within 24 hours of entry (or within that day). I assume this is possible but what would be the easiest solution, keeping in mind my programing language is very limited. Thanks in advance,
Mike  |
You will need to store the date/time when the record was entered, so you can compare it with the date/time when someone attempts to edit it. You could design the form with its Allow Edits property set to No. Then, in the onCurrent event of the form, you could compare the date/time stored in the current record with the current date/time from the system (just Date() ) and only set the Allow Edits property to Yes if it meets your requirements.
You will certainly have to write some VBA code in order to do this, but it is pretty simple code.
__________________
Experience is the thing you have left when everything else is gone.
|