Trigger e-mail when new data entered in table

[Lawlee]

How can I trigger a e-mail when new data is entered in a table without
a form?

Thanks

[Wayne Morgan]

Access has no way to do this by using just a table. There are no events or
triggers in Access tables.

--
Wayne Morgan
MS Access MVP
"Lawlee" <wi*****@tsamail.co.za> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

How can I trigger a e-mail when new data is entered in a table without
a form?

Thanks

[Larry Daugherty]

You can't. You should use forms for massaging data in tables.

HTH
--
-Larry-
--

"Lawlee" <wi*****@tsamail.co.za> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

How can I trigger a e-mail when new data is entered in a table without a form?

Thanks

[corey lawson]

Larry Daugherty wrote:

You can't. You should use forms for massaging data in tables.

HTH

Or, in this case, store the data in a true server-based RDBMS, even if
it's the MSDE. Except for MySQL, almost all of these RDBMS have
programmable triggers for tables (and views...) which would facilitate
what you want to do at the lowest level possible, i.e., do something
when data is inserted or deleted from a table.

The typical book example is adding information to a transaction
history/audit table...