April 16th, 2007, 06:46 AM
posted to microsoft.public.access
|
|
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!
|