Auto Email Alert / Notification

Hi Folks

Any idea how to create an auto-alert mail and notification if certain data (with certain criteria) enters the table ?

Im using MS access 2010

so for example:

If there is new entry with wherein NAME column and AGE column is filled then it should send an email to specific email id [email protected] and a notification in the Access DAta base.

The preference would be an email but if only notification comes then also its fine.

This mechanism should run after 15 minutes every-time.

Create an afterupdate event for the two fields and employs the Send Object function. You should not be entering data directly into a table, but using a form whereby you can employ the afterupdate event.

There is no way for this to happen or occur unless you use a form. It is unadvisable to allow users direct access to your data in the tables. Ask any developer in Access and they will tell you the same thing. A form is the method you need to use. Then you can employ the VBA events that allow this type of situation to occur.

Tables are for storing data only. They are not used to manipulate data. That is done in queries and forms.