Okay,
I haven't gotten much help with any of this anywhere. Let's see if you guys can help me. Here is the situation:
I have a form named Trouble Tickets. In that form, I have a field named Alarm. The form also contains several other fields, including Date and Time. Then I have another form (a pop-up one) called Trouble Ticket Alarm. This is what needs to happen:
Someone enters a record into Trouble Ticket form. They set the alarm field to "Yes". Then, somehow, I need Access to pop-up the Trouble Ticket Alarm form every 6 hours stating the record "whatever the issue was" has been open for six hours, twelve hours, whatever, until the Alarm field is set to "No". Is this possible? I have even attempted to guess at a crude code outline:
On <some event, or maybe every 5-10 minutes?>
Run query on Trouble Ticket Table
Look at all records where Alarm = Yes
Check Time field for that record
If Time = <something like Time + 6, Time + 12, Time + 18, Time + 24, etc>
Then <pop up a dialog box that says "This Ticket (insert ticket detail section here) has been open for (however long it's been open).>
Stick on an "okay" button to close the box.
Can anyone make this thing work?
I haven't gotten much help with any of this anywhere. Let's see if you guys can help me. Here is the situation:
I have a form named Trouble Tickets. In that form, I have a field named Alarm. The form also contains several other fields, including Date and Time. Then I have another form (a pop-up one) called Trouble Ticket Alarm. This is what needs to happen:
Someone enters a record into Trouble Ticket form. They set the alarm field to "Yes". Then, somehow, I need Access to pop-up the Trouble Ticket Alarm form every 6 hours stating the record "whatever the issue was" has been open for six hours, twelve hours, whatever, until the Alarm field is set to "No". Is this possible? I have even attempted to guess at a crude code outline:
On <some event, or maybe every 5-10 minutes?>
Run query on Trouble Ticket Table
Look at all records where Alarm = Yes
Check Time field for that record
If Time = <something like Time + 6, Time + 12, Time + 18, Time + 24, etc>
Then <pop up a dialog box that says "This Ticket (insert ticket detail section here) has been open for (however long it's been open).>
Stick on an "okay" button to close the box.
Can anyone make this thing work?
