Re: How do display a countdown timer

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Wed, 11 Mar 2009 06:47:01 -0700, jagnval
<jagnval@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Do some simple math. First calculate the hours by doing an integer
division:
dim secs as long
secs = datediff(...)
dim h as integer
h = secs \ (60*60)

Get the remainder:
secs = secs - h * 60*60

Repeat this for minutes and seconds. Format as a string.

-Tom.
Microsoft Access MVP


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.

.

Relevant Pages

  • Re: How do display a countdown timer
    ... Use the \ to get an integer division: ... can't get it reformatted into the format I want of hh:mm:ss. ... start at 60 and countdown to 0 and that would take off 1 min and so on. ... Set the form's TimerInterval to for example 5000 so the timer ticks ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How do display a countdown timer
    ... can't get it reformatted into the format I want of hh:mm:ss. ... start at 60 and countdown to 0 and that would take off 1 min and so on. ... In your form (I am assuming bound to the Items table) create a new ... Set the form's TimerInterval to for example 5000 so the timer ticks ...
    (microsoft.public.access.tablesdbdesign)
  • Re: timers
    ... i am trying to make so the label will countdown 3hrs in the Hr:Min:Sec format ... oops forgot to say 1 button starts the timer and the other stops it ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Setting field properties in code
    ... format that the user has defined in the Windows Control Panel, ... >> Sub StandardProperties(strTableName As String) ... >> Dim tdf As DAO.TableDef 'Table nominated in argument. ... >> Dim ind As DAO.Index ...
    (comp.databases.ms-access)
  • Re: Conditional format problem
    ... an Excel 5.0/95 format file, ... Anyone know how to save in a later Excel format from Access? ... Dim oXL As Object ... Dim strCondition1 As String ...
    (microsoft.public.excel.programming)