Earl C Phillips
Volunteer Programmer
- Local time
- Today, 08:03
- Joined
- Jul 18, 2008
- Messages
- 40
I am a volunteer programmer in a regional food bank to feed the hungry. I wrote a volunteer-scheduling application to keep track of the 4000 volunteers every month. Someone is altering the tables directly rather than through the forms. How can I capture the delete event directly too a table or row and capture who is doing it, or stop the deletion? I have a function that captures the ID of whoever is in the system but cannot figure how to capture the event procedure for when a table or row is deleted. When I find out how, I will write the record and the ID doing it to a journal file to capture their identity.
I already have a journal in place for creations and deletions of records from within the forms. Any suggestions would be appreciated.
I already have a journal in place for creations and deletions of records from within the forms. Any suggestions would be appreciated.