Form Timer

  • Thread starter Thread starter Lonnie
  • Start date Start date
L

Lonnie

I am using a form to log calls, the form stays open till
the call is over, it would be good to keep track of how
long the call was. I have a start time already AND HAVE
TRIED ON EXIT AND AFTER UPDATE but they don't seem to
work. Can anyone help. Thanks in advance.
 
You would need to use BEFORE UPDATE. AFTER UPDATE fires after the record
has been written.

You would need code in your BEWFORE UPDATE event that will put the current
time in the "call ended" field or similar.

If your record includes a "call started" and a "call ended" then you can
calculate duration in your queries, reports, and forms.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Understanding Timer Pause code 4
during the execution of a function. 2
Copy record info into new form 0
Countdown timer 1
Access Access Open and Close a Timer Form running on an open database on another computer 0
Timer of Form 4
Timers and code... 1
Access how to open existing database from another database using Access - VBA 0

Back
Top