Record time data entered on a specific field

[franklinbukoski]

I have a tracking system where my employees enter dates tasks were
accomplished. I would also like to know the time these dates are being
entered in the database, and they enter about 10 different dates altogether
(the process goes to 10 different organizations).

This will be used to assess efficiency between organizations and find
bottlenecks, but simply getting the employees to enter times with dates has
proven unreliable. How do I take the human factor out of this and meet the
intent of having a precision tracking system?

Please help!

 

[Douglas J. Steele]

You can put code into the form's BeforeUpdate event to record the date the
update is being performed (and who's performing it, if you like)

 

[franklinbukoski]

Thank you Doug, I'm still new to Access, how do I do that?

 

[Douglas J. Steele]

Try going to
http://search.microsoft.com/search/search.aspx?view=msdn&st=a&c=0&s=1 and
put

access beforeupdate

in the All of these words box. That'll bring up a number of references that
you can check out.

Post back if you still have questions after that.