Notify all users of a new record
Posted on 2011-10-24
I have a DB created in Access 2007 that has a user GUI and ADMIN GUI. The administrators can add and change records, the users can only view the records.
What I am looking for here is I have a table called ExMsgs_tbl which stores the information that users need to process requests. The users view the messages via a form (ExMsgsViewer_frm), which is simply a form with a listbox to display the messages as they are created, with some filtering capabilities via comboboxes.
What I am looking for here is when an admin adds a new record to the ExMsgs_tbl I would like all user that have the database open to be notified of the new message. I was attempting to use the on timer event of the MsgsViewer form to check every so often for a new record by doing a listbox record count and comparing it to the number of records in the table. If the numbers differed then a msgbox would display stating that there is a new message.
My problem is even though the event is on the form timer if the user click off of the screen then the form did not refresh and the notification will not show until the user refreshes the form manually.
There is not front/back end single DB accessed by about 8 people simultaneously.
I am capable of putting together a function or procedure if need by, but was not sure of the best way to move forward from here.
Any assistance would be appreciated.