We don't use Access (the program) but the database. Our code is VB and it interacts with the access database.
With that we implemented what you asked.
I would love some advice about something I'd like to do in Microsoft Access - I don't know if it's even possible yet!
I have a table in access, and would like to be able to track all changes made to any fields in the table. For example, if I change a field with the word 'cat' in it to the word 'dog', I'd like a separate table to automatically record the following:
Date of change
User who changed it
Change (eg "Changed 'cat' to 'dog')
I'd also like the option of adding:
Who authorised the change
Reason for change
I would really appreciate any help here - I know it should be possible with a bit of VB scripting, but I really don't know where to start.
Any help would be fantastic.