Hi can i set an alarm for user When any one add a record in database . thanks for your favor.
A abbas mohammad khani Mar 9, 2011 #1 Hi can i set an alarm for user When any one add a record in database . thanks for your favor.
J John W. Vinson Mar 9, 2011 #2 Hi can i set an alarm for user When any one add a record in database . thanks for your favor. Click to expand... 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
Hi can i set an alarm for user When any one add a record in database . thanks for your favor. Click to expand... 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
D David-W-Fenton Mar 9, 2011 #3 Not if they have access to the tables, no. Tables have no programmable events. Click to expand... 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. Click to expand... 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.
Not if they have access to the tables, no. Tables have no programmable events. Click to expand... 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. Click to expand... 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.
