Results 1 to 2 of 2
  1. #1
    ScubaSteve is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2017

    Countdown Timer w/ Reset on Button Click

    Hi everyone, I'm trying to make a data entry form in MS Access 2016 for quality spot checks that need to be performed every 15 minutes. The problem I ran into was trying to make a countdown timer that signals when a new spot check is needed. I wanted the timer to start at 15 minutes and count down from there (15:00), the text color to turn red at the 2:00 mark, the form back color to turn red if it reaches zero (or flash red), and for the timer to reset on the click of the submit button.

    The text box that I want the timer in is called "txtTimer" and the button made to save the record is named "Submit".

    I appreciate your help on this.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    On a form,put 2 text boxes,
    txtClock, txtTarget

    txtClock shows the time.
    txtTarget shows the time of the next time.

    in the form property, TimerInterval=1000. (1 second)
    in the OnTimer event, put the code....
    sub form_OnTimer()
    txtClock= DateAdd("s",-1,txtClock)
    if txtClock= txtTarget then
       TxtTarg = DateAdd("m",15,txtTarget)
       TxtClock= #00:15:00#
    End if
    end sub

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 01-23-2014, 01:00 PM
  2. countdown timer and progress bar
    By yigitki in forum Programming
    Replies: 5
    Last Post: 11-16-2011, 01:20 PM
  3. countdown Timer
    By yigitki in forum Programming
    Replies: 16
    Last Post: 11-11-2011, 11:24 AM
  4. Simple 30 second countdown timer on Access 2003 form
    By Mediaman09 in forum Programming
    Replies: 2
    Last Post: 09-21-2011, 09:55 PM
  5. Pause / Wait / Countdown / Timer
    By DevGreg in forum Programming
    Replies: 0
    Last Post: 11-17-2009, 04:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums