Time countdown

[Stockwell43]

Hello,

I have a database that was designed for Auctions. What I would like if
possible, is to place a timer of some sort on the form. I somehow want to set
the amount of time I want the auction to run, click a button to start the
countdown (after I start the clock I will hide the button) and then have the
clock run so everytime the form is opened it will show the remaining time
left. Is this doable and how difficult would it be?

Thanks!!!

 

[Stockwell43]

Thanks Daniel,

Am I not able to place the timer on the Auction form with a text field?
Also, what coding would I use? I am still kind of new to Access.

Thanks!!!

 

[Daniel]

This can be done.

basically you'll need to create a simple form and initialize a variable for
your time to 00:00:00. Then using the timer event set it to run every second
(set the Timer Interval 1000 = 1 second) and code it to update your variable
by 1 second and update the control on your form with the new value.

you can create a countdown timer the same way but initializing your variable
to your total time and using the timer event to substract 1 second at a time.

Daniel

 

[Daniel]

download and review the following sample database (clock and timer). it
should answer your questions.

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#clocktimer

Daniel

 

[Stockwell43]

Excellent site!

Thank you for your Daniel!

download and review the following sample database (clock and timer). it
should answer your questions.

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#clocktimer

Daniel