Date Time Stamp

[Guest]

I've got a form that is used to track deficiencies. It is then used to track
corrective actions. I want a date time stamp on the form that will update
when the record is updated so that we can track turn around times. I used the
Access help for attaching a date time stamp to a record via a setvalue macro.
I followed the instructions, added two new fields datemodified and
timemodified. I wrote the macro in line with the example. When I attempt to
save the record instead of seeing a current date time field populat in the
table, I get an error about automation operations... I can't find much out
about this, but suspect that access can't see the current date and time from
windows. Any suggestions?

Thanks

 

[Jeff Boyce]

Tom

I use Access to record CreateDate, CreatedBy, UpDated, UpdatedBy data for
each record.

I use the Date() function to get date-only, or the Now() function to get
date & time info.

I do this directly in the form, generally hide those fields (the user
doesn't care), and update them before saving the record.

Regards

Jeff Boyce
Microsoft Office/Access MVP