table triggers?

  • Thread starter Thread starter Joe Clark
  • Start date Start date
J

Joe Clark

Is there a way to write some code that's triggered on an INSERT or
DELETE from a table? I remember having read about something like that
a while ago but I can't figure out how to do it now...
 
hi Joe,

Joe said:
Is there a way to write some code that's triggered on an INSERT or
DELETE from a table? I remember having read about something like that
a while ago but I can't figure out how to do it now...
Click to expand...
There are no triggers in Access.

The closest to an trigger you can use is the Form_BeforeUpdate() event.


mfG
--> stefan <--
 
Joe Clark said:
Is there a way to write some code that's triggered on an INSERT or
DELETE from a table? I remember having read about something like that
a while ago but I can't figure out how to do it now...
Click to expand...

You code in *form* events, not tables, so you could use "On Delete" or
"Before Insert" ...

HTH - Keith.
www.keithwilby.com
 
The Access UI doesn't offer a way to do triggers on tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top