View Single Post
  #3  
Old April 16th, 2007, 06:46 AM posted to microsoft.public.access
Rach
external usenet poster
 
Posts: 17
Default information massage when a record entered to the DB

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!