Alert

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using A2K, I have a db (front-end, back-end) to log problems and solutions to
those problems. There will be a form at a control desk to enter the
problems, and a different form in a maintenance area to enter solutions to
the problems. Both forms will be open at the same time. What I would like
to be able to do is have a notice of some type to alert the maintenance area
that a problem entry has been made so they can begin to work on the solution
to the problem. Can a message be sent to another form and displayed while it
is open or, ideally, could a control on the maintenance form be made to start
blinking while it is open?
Thanks in advance for any help.
Dan Chapman
(e-mail address removed)
 
This will be tricky because the forms are on two different computers and they
will know nothing about each other. You may find a better method from one of
the many Access Gurus, but here is a possible solution:

create a table that could hold the information the maintenance area needs
from the control desk.
When the condition arises that you need to notify maintenance, write a
record with the required information to the table.
In the maintenance area form, set a timer to check the table to see if there
are any issues to process. If it finds a record, then do whatever you want
to do to make the user aware so he can deal with it. It should also delete
the record. In other words, when the On Timer event fires, if the record
count for the table is 0 then nothing to do, otherwise, do what needs to be
done and delete the record.
 
Back
Top