Kayleigh
Member
- Local time
- Today, 07:35
- Joined
- Sep 24, 2020
- Messages
- 706
I am looking to keep a detailed record of all records which have been input/edit/deleted in VBA code.
One approach I considered is creating an array of the field names and another array of the values and iterating these arrays to call the audit function. However this would mean that I would need to add considerable extra code to all VBA functions.
Are there any more effective methods to achieve this goal?
One approach I considered is creating an array of the field names and another array of the values and iterating these arrays to call the audit function. However this would mean that I would need to add considerable extra code to all VBA functions.
Are there any more effective methods to achieve this goal?