Countdown timer

[Deltic]

I would love to be able to display a countdown timer on my form that
shows how long to go before the 2012 olympics, the timer would need to
have a facility to put in a time and date that the games start then to
display the days , hours minutes left. Is this possible ?
Thanks

 

[fredg]

I would love to be able to display a countdown timer on my form that
shows how long to go before the 2012 olympics, the timer would need to
have a facility to put in a time and date that the games start then to
display the days , hours minutes left. Is this possible ?
Thanks

I don't remember the exact day and time the 2012 Olympics starts, but
let's say it's 08/20/2012 7:00 PM

Copy the Diff2Date function from

http://www.accessmvp.com/djsteele/Diff2Dates.html

and paste it into a module.

Then you can call it from an unbound control on a form:

=Diff2Dates("ymdhns",Now(),#8/20/2012 7:00:00 PM#)

Each time you open or refresh the form (by navigating to the next
record) , the years, months, days, hours, minutes and seconds will
appear.

3 years 11 months 19 days 10 hours 34 minutes 47 seconds