Tracking Time a form is open

[R. Daniel Carlson]

Yet another addition my manager has requested for our call log...

The students that call donors are currently not tracked as to how long they
talk to a donor over the phone. We would like to have some way of monitoring
this - and I felt that the best way would be to record in minutes and seconds
how long a record is opened on the form. This would not be something that
would display on the form, but when the students print the end of day report
showing thier work, it would show up on the report for each record.

Any ideas??

 

[Trever B]

Hi Daniel,

Think you need to think a bit more about this one:-

It is no good just doing the form as you pehaps have many font end's and one
backend.

Try something like this.

Not sure hho is contacting who but if you could make it thke this:-

Student Contacting Donor.

make a table say "Contact Times"

Student Call Donors Start End
No No Date/Time Date/Time



Press a button on the form to make contact:-

1)
At this point you run an update date query so that any open Contacts for
this student
have an end Dtae & Time (Presume that can only talk to one at once)
2)
Add a new record showing student no & donor no and Start date & Time

3)

When student changes to another donor put end date/Time in first to seal the
record before

Or

Same if Closes Form

Hope this helps

Trev

 

[Trever B]

Hi Daniel,

Sorry last one went a bit screwey.

Think you need to think a bit more about this one:-

It is no good just doing the form as you perhaps have many font end's and
one backend.

Try something like this.

Not sure who is contacting who but if you could make it like this:-

Student Contacting Donor.

make a table say "Contact Times"

Student Call Donors Start End
No No Date/Time Date/Time



Press a button on the form to make contact:-

1)
At this point you run an update date query so that any open Contacts for
this student have an end Date & Time (Presume that can only talk to one at
once)

2)
Add a new record showing student no & donor no and Start date & Time

3)

When student changes to another donor put end date/Time in first to seal the
record before putting a new record in

Or

Same if Closes Form

Hope this helps

Trev

 

[R. Daniel Carlson]

Ok. I do already have a "timestamp" for when they save the record or change
records. I guess just taking that a step further would do the trick. Thanks