manndo
asked on
Automatically fire After Update event on all records in form using existing data
Here is my situation. I have existing data in a field called ITP Date. I have added additional fields which are calculated based on the data entered in ITP, (but again, the data is already there). Is there any way to get the new fields to update without rekeying the data into ITP?
Thanks.
Thanks.
Use DB trigger to further update other column upon the change of a specific column (in this case which is ITP date). Read
CREATE TRIGGER
CREATE TRIGGER
ASKER
The AFter Update Event is on the form. Re-entering the data into the table does not fire the After Update event, thus the other fields based on the After Update event are not calculated. The After Update event placed on the ITP field is this......
Me.[1st Review] = DateAdd("d", 90, Me.ITP)
Me.Redevelopment = DateAdd("d", 365, Me.ITP)
Neither the 1st Review field or the Redevelopment fields are updated after running Update query on the Table. Thanks again for your help.
Me.[1st Review] = DateAdd("d", 90, Me.ITP)
Me.Redevelopment = DateAdd("d", 365, Me.ITP)
Neither the 1st Review field or the Redevelopment fields are updated after running Update query on the Table. Thanks again for your help.
I have added additional fields which are calculated based on the data entered in ITP, (but again, the data is already there).what are the default values these fields??? are they NULL???
1. About triggers, you can create them to catch INSERT, UPDATE and DELETE events, but not for ALTER TABLE...
2. About your new fields if thes are NULL you can recalculate then...
3. After that you need to create a trigger to calculate new records, or do this at program level.
4. If you cann't do #3 you have to recalculate your fields before each data request, but only them who are NULL, in this case an index can speed up the process.
regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Jim. Your solution is what I was looking for on this one. It worked great. I really appreciate it. Yes. It was a one-time thing and from now on when data is entered on the form, the After Update event will update the fields. Thanks again.
Jim.