Hi there,
I am trying out Access (2016) Triggers for the first time. Our email business rules agent system inserts records into Access tables depending on email content, and I am trying to get these inserts trigger a vba function within a module in the database (with parameters).
I have used the "After Insert" data macro, and this is working fine. But while it works great when inserting records manually in the table, happening when I leave the row to another row, the trigger is not fired when an outside application inserts a record. Probably since there is no "After" presence, and therefore no "After Insert" process that would fire the trigger. There is no "On Save" trigger or something like it.
Anyone have any idea how to tackle this?
Thanks!
Tezal
I am trying out Access (2016) Triggers for the first time. Our email business rules agent system inserts records into Access tables depending on email content, and I am trying to get these inserts trigger a vba function within a module in the database (with parameters).
I have used the "After Insert" data macro, and this is working fine. But while it works great when inserting records manually in the table, happening when I leave the row to another row, the trigger is not fired when an outside application inserts a record. Probably since there is no "After" presence, and therefore no "After Insert" process that would fire the trigger. There is no "On Save" trigger or something like it.
Anyone have any idea how to tackle this?
Thanks!
Tezal