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

On Wed, 9 Mar 2011 01:56:14 -0800 (PST), abbas mohammad khani
<(E-Mail Removed)> wrote:

>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/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in
news:(E-Mail Removed):

> On Wed, 9 Mar 2011 01:56:14 -0800 (PST), abbas mohammad khani
><(E-Mail Removed)> wrote:
>
>>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.

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.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/