Re: effect of trigger in Access?
- From: "Pat Hartman\(MVP\)" <patsky@xxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 14 Jan 2006 21:59:42 -0500
You can do what you are asking with Access but you can't use a trigger. You
need to use a form or control event. Depending on your actual requirements
one of the following four events will work for you:
1. Form's AfterUpdate event
2. Form's BeforeUpdate event
3. Control's AfterUpdate event
4. Control's BeforeUpdate event
The Change event of a control is inappropriate for this task since it runs
for EVERY character typed in the field. So if your field has 5 characters,
the change event will run 5 times whereas the before and after update events
run only once per change.
"Kevin" <kevind@xxxxxxxxx> wrote in message
news:43c89768$0$58052$742ec2ed@xxxxxxxxxxxxxxxxx
> With Access 2000 or 2003, is there a trigger or onChanged method? I
> would like to be able to do a mailto if certain fields change in my db.
>
> Thanx.
.
- References:
- effect of trigger in Access?
- From: Kevin
- effect of trigger in Access?
- Prev by Date: Re: effect of trigger in Access?
- Next by Date: Re: Outlook Voice Notes
- Previous by thread: Re: effect of trigger in Access?
- Next by thread: outlook
- Index(es):
Relevant Pages
|
