Hello,
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 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?
