Time reminders

  • Thread starter Thread starter Vasya via AccessMonster.com
  • Start date Start date
V

Vasya via AccessMonster.com

How do I set up time reminders in my Access.
When the time comes close to the certain point, my record changes color or
something similar?
 
I used that once, but we used it on a certain form.
you can set the time interval (and I can't remember the name of the other
proprty you need to set, if you interested I'll find out) on your form to
check the time every 1,2.... minutes, what ever you choose, so when the time
come the field will be colored.

if format(time(),"hh:mm")="23:36" then
me.myfield.backcolor=111111
endif
 
Back
Top