can a timer be set to see how much time has elapsed between now and when a record was first opened.
S Sharon Jan 27, 2005 #1 can a timer be set to see how much time has elapsed between now and when a record was first opened.
M [MVP] S.Clark Jan 28, 2005 #2 When the form is opened, in the Open Event you can assign the current timestamp to a global variable or custom property of the form. e.g. gdtmStart = Now() Later, when you need to do something, you can compare that value. e.g. msgbox("Elapsed Time (in minutes) was: " & DateDiff("n", gdtmStart, Now()), vbinformation)
When the form is opened, in the Open Event you can assign the current timestamp to a global variable or custom property of the form. e.g. gdtmStart = Now() Later, when you need to do something, you can compare that value. e.g. msgbox("Elapsed Time (in minutes) was: " & DateDiff("n", gdtmStart, Now()), vbinformation)
