Display length of time

[Guest]

I want to build a form that shows data for 7 records and have a field that
displays the running age in minutes for each record since it's creation.

Is there a timer function that will do this??

Bed 1: John Doe: 0900:

Then a field that is counting the seconds and the minutes from the time the
record was created.

If this makes sense to anyone that would offer an idea I would appreciate it.

Thank you

 

[Guest]

Hi Jeff,

Use the On Timer event on your form and set the timer interval to 1000 (1
second). Record the date/time created and then you could use the DateDiff
function to return the difference between now() and the date/time created.

Hope this helps.

Damian.

 

[Guest]

U Da Man! Great thought I didn't have.

so the timer interval is set to 1000

is the timer event a form refresh???

Thank you

 

[Guest]

Hi again Jeff,

I assume it does cause a refresh to be called, as you don't explicitly need
to call a refresh to your control after updating it.

Damian.

 

[Van T. Dinh]

You use the Form_Timer Event to run your code, be it a Requery, Refresh or
Recalc method.

Check Access VB Help for the differences between ReCalc, Refresh and Requery
methods of the Form object.