Hi all --
What would be the best way to time stamp a form when someone enters data into a particular field?
Thanks in advance
Lawrence
Hi all --
What would be the best way to time stamp a form when someone enters data into a particular field?
Thanks in advance
Lawrence
Not sure what you mean by 'time stamp a form'.
Can use DefaultValue property to automatically save current date/time into a new record.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
While in Design View of the table Object, go to the field's properties. In the Default Value property place
Now()
for original/initial entry - that means creating the new record: you can simply have a field (time/date type) and set its default to be: =Now()
if you are talking about an edit - then this gets more involved; in the form you can use the OnDirty or the AfterUpdate event which would span all fields of the record....or if you want to tie it to a specific field you can do it in the AfterUpdate event of that field..... but that timestamp field is going to be overwritten each time....so you'll only know the last edit and not any prior edits.... attempting to track all edits requires writing to a separate log table & this becomes quite involved and generates potentially lots of data records so you want to really be sure it is worth the effort when you consider this.....