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.