alarm

abbas mohammad khani · Mar 9, 2011

Hi
can i set an alarm for user When any one add a record in database .
thanks for your favor.

John W. Vinson · Mar 9, 2011

Hi
can i set an alarm for user When any one add a record in database .
thanks for your favor.

Not if they have access to the tables, no. Tables have no programmable events.

If the users can ONLY get to data via Forms you can put code in the Form's
beforeupdate event to issue an alarm, but only then.

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

David-W-Fenton · Mar 9, 2011

Not if they have access to the tables, no. Tables have no
programmable events.

Well, before A2010, they didn't.

If the users can ONLY get to data via Forms you can put code in
the Form's beforeupdate event to issue an alarm, but only then.

I'm not sure if you can issue an "alarm" with a table-level data
macro in A2010, but you can do other things, like write a record to
a log table.