Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 29th, 2011

 

There are several methods in MS Access where the concept of triggers can be put to use
From Tables, Forms, Reports You can create triggers at various levels and events. In fact MS Access makes this possible is a very user-friendly interface.

While creating a table in Design View, For each field you have the control to set Validation Rule and Validation Text this in itself can be made use of as a field level trigger.

In forms, MS Access provides a host of events that can be triggered such as
On Open
On Load
On Current
On KeyPress
On KeyDown
Before Insert
After Insert
Before Update
After Update
On Undo
On Delete
On Resize
On Unload
There are several such events wherein the concept of triggers can be put to use

Similarly in Reports one can incorporate triggers at various levels such as
On Open
On Close
On Activate
On Deactivate
On No Date
On Page
On Error