Re: How do display a countdown timer
- From: jagnval <jagnval@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 11 Mar 2009 06:47:01 -0700
Tom,
First off thank you for your help. I have the run the DateDiff and I have
the seconds until the ending bid date on a timer interval of 1 second, but I
can't get it reformatted into the format I want of hh:mm:ss. may be even
days, I would like for it to be like a countdown clock when the seconds
start at 60 and countdown to 0 and that would take off 1 min and so on.
"Tom van Stiphout" wrote:
On Tue, 10 Mar 2009 08:32:17 -0700, jagnval.
<jagnval@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am assuming you already have a field in your Items table to record
the EndOfBidding date/time.
In your form (I am assuming bound to the Items table) create a new
label, say lblCountdown.
Set the form's TimerInterval to for example 5000 so the timer ticks
every 5 seconds.
In the Form_Timer event write:
Me.lblCountdown.Caption = datediff("s", Now, Me.EndOfBidding)
This would give you the number of seconds until EoB. Use the Format
function if you want to format this value differently.
-Tom.
Microsoft Access MVP
I am creating an auction database to help in the removal of unused items at
my work place and need to display a countdown timer of how much longer items
are open for bidding, any help will be greatly appreciated.
- Follow-Ups:
- Re: How do display a countdown timer
- From: Tom van Stiphout
- Re: How do display a countdown timer
- From: Tom van Stiphout
- Re: How do display a countdown timer
- References:
- How do display a countdown timer
- From: jagnval
- Re: How do display a countdown timer
- From: Tom van Stiphout
- How do display a countdown timer
- Prev by Date: Re: How to DETECT if records corrupt in table.
- Next by Date: RE: Disappearing tables in Access 2002 split database
- Previous by thread: Re: How do display a countdown timer
- Next by thread: Re: How do display a countdown timer
- Index(es):
Relevant Pages
|
