alarm

  • Thread starter abbas mohammad khani
  • Start date
A

abbas mohammad khani

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

John W. Vinson

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging Qry into Table 2
Alarm 2 2
getting data from a text file 5
can I use IF statement to call a VBA function ? 2
Dynamic Naming of Form Button 3
Counts number of entries per day in query 4
select worksheet and run macro 7
ALARMS ON DUE DATE? 4

Top