K
Kay
Hi
I have created a reminder in my database. I have created a reminder
table with the fields alarm id, alarm date, alarm time and alarm
message. I use a form to enter the alarm details into my table. I have
used the following code in my form timer event:
If Me.AlarmDate = Date And Me.AlarmTime <= Time() And Me.Reset = False
Then
MsgBox ("A Job is Due") & vbCrLf & _
("ALARM ID = ") & AlarmID & vbCrLf & ("ALARM MESSAGE = ") &
AlarmMessage & vbCrLf & ("Please tick the reset box on the alarm form
to reset the alarm")
If the alarm time is passed, the alarm message is shown after every
update so I have used a reset checkbox to stop an alarm that already
has
gone off. The problem I have is that a message is only shown for an
alarm that the focus is set on. By that I mean If alarm id 123 is
displayed in the form, then the alarm message will only be shown for
that alarm when the time has come. What I need it to do is to shown
the message for any alarm not just the one that is being viewed.
Any help will be much appreciated
I have created a reminder in my database. I have created a reminder
table with the fields alarm id, alarm date, alarm time and alarm
message. I use a form to enter the alarm details into my table. I have
used the following code in my form timer event:
If Me.AlarmDate = Date And Me.AlarmTime <= Time() And Me.Reset = False
Then
MsgBox ("A Job is Due") & vbCrLf & _
("ALARM ID = ") & AlarmID & vbCrLf & ("ALARM MESSAGE = ") &
AlarmMessage & vbCrLf & ("Please tick the reset box on the alarm form
to reset the alarm")
If the alarm time is passed, the alarm message is shown after every
update so I have used a reset checkbox to stop an alarm that already
has
gone off. The problem I have is that a message is only shown for an
alarm that the focus is set on. By that I mean If alarm id 123 is
displayed in the form, then the alarm message will only be shown for
that alarm when the time has come. What I need it to do is to shown
the message for any alarm not just the one that is being viewed.
Any help will be much appreciated