Timer

[Mark]

Hi all,

I have a form, in which I would like to track the amount
of time (hours, minutes, seconds, milliseconds) a user has
the form open. I have found ways to set up a stopwatch,
but am not sure how to use that in my situation.

More specifically... I have a form in which a user enters
information... that populates a table. A second
form, "EditEmployee", is based off of a query that allows
edits to be made on any given record (upon opening the
form, "EditEmployee"... the user is asked to enter
employee ID... then the form is opened and the fields ar
filled with the record of the selected ID).

Is there a way I can track the time of how long the forms
are opened... and assign the time to each corresponding
record? So, I can have a running total of how long a
record has been opened.

Thanks for the help!!!!

 

[Wayne Morgan]

Here is a link that will show you how to track inactivity. You should be
able to modify it to get the time you want. Once you have the time, you
would place this in a hidden textbox (Visible=No, I assume you don't what
the users to see this, just you) that is bound to the time field in the
table/query using the form's BeforeUpdate or BeforeInsert event. Since the
textbox is bound, the value would then be saved to the table when the record
is saved. Reset the time to zero when you write it to the textbox.