Countdown Timer

[Tony]

I would like to create a text or label field on a Form that can display a countdown (Months, Day, Hours, Minutes, Seconds) based on a predetermined date.

I've viewed several threads w/respect to countdown timers and DateDiff VBA codes/modules and to the novice user, they all seem very complicated.

If able, could anyone provide a simple step by step on how to: .....

Thank you for your help,

Tony

 

[DCrake]

What are you counting down? and do you want it to be constant every time you open the database or not? More info would help.

David

 

[Tony]

Yes, the countdown would have to be continuous as oppose to starting over every time I open up the form.

I'm counting down the time for our family vacation.

 

[neileg]

You can use DateDiff to calculate the difference between Now() which returns the current system date and the date of your holiday. You will need to refresh this calculation so that it is kept up to date. Be warned that refreshing it too frequently will hog your system resources so that having a display down to the second is a bit optimistic.

Having said all of that, I'm sure you could get a bit of shareware to do this in a much more efficient way than in Access.

 

[DCrake]

A might trivial I suggest but you would need a constant date that is the date of your vacation and use the forms timer control to change the interval between Now() and the date of your vacation. depending on how often you want it to update depends on the timer interval on your OnTimer Event. 1000 = 1 second.

David

 

[Tony]

Gentlemen,

Yes I understand there are several other ways in Lieu of the countdown, but it's the countdown field on a form using MS Access that is the requirement. Thank you for the suggestions, however, as indicated earlier, details explaining the how to.. would be very much appreciated.

R,

 

[neileg]

So this is a school or college assignment? I can't think why else you would feel that an Access is the only option.

 

[Tony]

Not a school assignment Sir. Just tring to create an extra feature on a form. Thanks for your help though.

R,