Access form start time and end time

[psamu]

I would like to add start and end time in the access form. if the user open immediately need to start the time counter and when it saves the record end the time counter need to update for calculating the average time for updating a record. Thanks

 

[Micron]

There may be a simpler way, but here's one. Replace the control names with your own. I'm assuming the save event is triggered by a button. Each subsequent button click will increment the duration. If you want to start the clock again if user moves to a different record, then I have not accounted for that - you do not say what kind of form you have. Nor did you say if you want the result in seconds or minutes. If none of this works for you, you will at least now have a concept.
For your form open event:

Me.txtStart = Time
Me.txtEnd = ""

For your button click event:

Me.txtEnd = Time
Me.txtDuration = getDuration
Me.Refresh

In your form module:

Function getDuration() As Long
Dim lngStart As Variant, lngEnd As Variant
lngStart = Me.txtStart
lngEnd = Time
getDuration = DateDiff("s", lngStart, lngEnd) ' s for seconds
End Function

If you have issues, I will not be able to respond in a timely manner after today.

 

[psamu]

Thanks . I have continuous form. Field name as StartTime and another field name as EndTime. There are few filed user has to update. If user open a particular record and time start when user start updating the first field and the time end when user click on move to next record .