Log time spent on each record
Guy Kerr
contact customers on behalf of other companies and as such are open to being
audited to make sure we're following protocol. Our latest audit exposed the
fact we have no way of knowing how long we are spending on each customer.
We're looking for a way to log how long our agents are "on" a record in the
database. I was thinking of using the On Timer event to initially write a
record (then update the same record when the timer hits again) to the logging
table every 10 seconds or so I can see how long the record was active. This
doesn't seem like a very clean solution so I thought I'd ask some advice
first.
I was looking at the the other Events but wasn't sure which would be best.
Any advice would be much appreciated.
Guy
Tony Toews [MVP]
Form close event.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/
Douglas J. Steele
they start by noting it in the form's Current event. When it fires again (or
the form closes) means they've moved to another customer.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Guy Kerr" <Guy...@discussions.microsoft.com> wrote in message
news:F19C3C59-F339-454C...@microsoft.com...
Tony Toews [MVP]
>It depends on the design of your form, but you might keep track of the time
>they start by noting it in the form's Current event. When it fires again (or
>the form closes) means they've moved to another customer.
Hmm, yes, my solution assumes that they are using a continuous form
with some filtering on top and then opening a details form where they
can do some updates.
matilda
Ο "Guy Kerr" <Guy...@discussions.microsoft.com> έγραψε στο μήνυμα
news:F19C3C59-F339-454C...@microsoft.com...