New Record Alert for Users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

timetraveller - 16 Nov 2005 22:19 GMT

We want to have an existing maintenance database alert particular individuals
when a new record has been added to the database so the correct person can do
the work requested on the new record. Several people will have access to the
database to be able to check, but we would like a message to pop up at the
correct workstation alerting the individual. Can this be done in Access 2003
or do I use another Microsoft program to do so? I have a rudimentary
knowledge of Access (and computers in general), so answers need to be as non
techy as possible. Thanks!

Reply to this Message

RobFMS - 16 Nov 2005 23:15 GMT

At a simplistic approach, make sure that every record that is added to the
database has a date/time stamp field.

On the front-end side database (also known as the client side database),
have a table/field that tracks the last time the user "checked" for new
records. If there exists records that are newer than the date/time stamp on
the user's side, then the user can be alerted of the new records.

Hopefully I explained that well enough.

HTH

Rob Mastrostefano

Signature

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

FMS Advanced Systems Group
http://www.fmsasg.com/

> We want to have an existing maintenance database alert particular
> individuals
[quoted text clipped - 9 lines]
> non
> techy as possible. Thanks!

Reply to this Message