423,846 Members | 1,959 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,846 IT Pros & Developers. It's quick & easy.

How do you create a timer button that changes colour

P: 1
I am working on a 2007 copy of access database. I need to add a button which when clicked turns green for 59 minutes then turns red on 60 minutes. This button should stay red until clicked again when it restarts the countdown. There will also need a way to turn the button back to grey.
This will be used to track responders welfare when operating in adverse weather conditions and will be used to prompt a phone call.

Would appreciate any help. My knowledge of access is small and VBA non existent.
1 Week Ago #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,121
You will need VBA. You'll need to code an Event Procedure on the form's timer.

Why don't you start by expressing what you think your logic should be in pseudo-code (ordinary English).
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.