J
Jackson via AccessMonster.com
Hi,
I've just started a new DB. The main form has a control Clock that simply
displays the current time and date to the second. It is live, as I put the
Timer Interval as 1000 and the On Timer procedure as [Clock] = Now
A few things:
1) I have a subquery that has records with a date and time (today's records)
and as they get say 15 minutes away from occuring I want to somehow alert the
user. Blinking text/blinking colours were my first thought and/or message
boxes. Any thoughts on how to go about this? I included a field TimeDiff in
my form which calculates the time diff between each record and the clock.
2) The timediff field doesn't update as a new minute ticks by. I thought I
could just put Me.Requery in the AfterUpdate property of my form but this
doesn't work, any thoughts as to how I accomplish this?
Any help would be most appreciated!
Regards,
Jack.
I've just started a new DB. The main form has a control Clock that simply
displays the current time and date to the second. It is live, as I put the
Timer Interval as 1000 and the On Timer procedure as [Clock] = Now
A few things:
1) I have a subquery that has records with a date and time (today's records)
and as they get say 15 minutes away from occuring I want to somehow alert the
user. Blinking text/blinking colours were my first thought and/or message
boxes. Any thoughts on how to go about this? I included a field TimeDiff in
my form which calculates the time diff between each record and the clock.
2) The timediff field doesn't update as a new minute ticks by. I thought I
could just put Me.Requery in the AfterUpdate property of my form but this
doesn't work, any thoughts as to how I accomplish this?
Any help would be most appreciated!
Regards,
Jack.