View Full Version : Data entry timing


belsha
01-22-2003, 08:44 AM
In the thread "timing an event " it was discussed how to time how long a person played snooker and figure their total time. My question is if I have a form and want to start a timer when the person begins to enter and end it when they exit the form, then send the record number and time spent entering it to a table, how would I code that? Thanks!

llkhoutx
01-22-2003, 03:37 PM
One simple way is noting the time when the form is opened (executing the NOW() function on the form OnOpen event or (record) OnCurrent event) and when a record updated (event OnAfterUpdate), and subtracting the two. Be careful of date rollover, that is, going from one day to the other.