Hello again people. I've put my database onto the company's network recently. One of the requests I've had is that it alerts one group of users to any new records in a certain table. Is there a method I can use to check this table periodically for new records and then have a form pop up to let them know a new request has been made?
The database is being used as a Maintenance Management system and I want to inform the Maintenance Team of new work requests. I'm not a programmer so I'd like to be able to use a query or macro if this is possible. If it's not then point me at the information I'd need to write a short piece of code, it's well past time I started to improve my ability in this area....
My thoughts so far are this: -
Add a new field to my table
Create an update query to check for this field being null, if it is then open a form.
On the form I was going to put a button that would change the field value so that it would not be pulled out in future.
Use the 'on timer' property in the other forms to run the query.
This will obviously take some refining, if it will work, but am I thinking along 'sensible' lines?
Thanks in advance for the help.