Allen already did explain.

In your code, where you have the code to append a new record, you need to
include code so that it also sends the message to give you the notification.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"rach" wrote in message
...
thank you,
can you explain me how can i design it at the interface level ?


No. Access lacks triggers. There is no event that fires at the engine
level
when a new record is added.

You will therefore need to design it at the interface level, so that when
your (browser-based?) interface appends a new record, it also sends the
(email?) message to give you the notification.

Alternatively, you would need to leave Access running, with a form open,
and
use the Timer event of the form to periodically check for new records and
SendObject to fire the email.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"rach" wrote in message
...
hi,
I want to know if i can get an information massage when a new record
enters
to my database,
1. when the access program opens.
2.when the access program close.
remark! the records coming from the intra-net, not from the access
program.

my access version is 2003

thanks!