ssukumar
April 24th, 2001, 12:55 PM
Hey guys,
I've asked about this before but got no response...I'm trying to mimick trigger functionality in MS Access 97. Someone told me the best way to check for addition of new records and modification to existing ones is to use the ValidationRule property of a table and call a user-defined function, which would act as the trigger function. I haven't been able to figure out how to call a VBA function defined in a module from the ValidationRule....is it even possible? Any suggestions on a better way to do this? Also, for deletes, there doesn't seem to be a way to handle it within Access at all... By the way, I have to detect ALL changes, so the user may NOT be using any forms.
Thanks again,
Sonny
I've asked about this before but got no response...I'm trying to mimick trigger functionality in MS Access 97. Someone told me the best way to check for addition of new records and modification to existing ones is to use the ValidationRule property of a table and call a user-defined function, which would act as the trigger function. I haven't been able to figure out how to call a VBA function defined in a module from the ValidationRule....is it even possible? Any suggestions on a better way to do this? Also, for deletes, there doesn't seem to be a way to handle it within Access at all... By the way, I have to detect ALL changes, so the user may NOT be using any forms.
Thanks again,
Sonny