Help with edit log using macro

[justin0312]

Hi, I got an edit form where user can edit the saved record. May I know how do I use macro to update the record and save a log of who edit and when the user edit? The user will need to login to edit and I already have set a tempVar to store the username with the login details.

I created a table to store the edit log. tbleditLog with the following fields
ID
Student_ID
EditedBy
DateTimeEdited

 

[theDBguy]

Hi. There are a few discussions here on the same topic with sample code and databases. Let me see if I can find a link for you.

 

[theDBguy]

Hi. Sorry for the delay. Here's a link to an older thread that might have some information you could use.

(1) Audit trail, tracking user changes with data macro and USer login from form? | Access World Forums (access-programmers.co.uk)

 

[justin0312]

Hi. Sorry for the delay. Here's a link to an older thread that might have some information you could use.

(1) Audit trail, tracking user changes with data macro and USer login from form? | Access World Forums (access-programmers.co.uk)

Thanks. I think is a little too complicated for me as I have very little knowledge one Access

 

[MajP]

I think the @theDBguy interpreted this to mean you only wanted to do this using Data Macros. This can be done if that is the only way you want to do it, but as you saw that can be complicated. Data macros have the advantage of updating regardless if changes are done on a form or directly in a table. There are a ton of easy examples out there using VBA; however, these are limited to form events and will not update based on changes made directly in tables or queries. Here are some.

Tracking data changes in Access – Home — DataWright Information Services

A simple solution for tracking changes to Access data | TechRepublic

When you have a lot of users changing data, it's easy for things to go wrong. But if you keep an audit trail of data input changes, you'll be able to determine which operators are consistently making mistakes (or not). You can also quickly fix problems before erroneous data wreaks havoc. This...

www.techrepublic.com

Creating An Audit Trail In Microsoft Access | Database Solutions for Microsoft Access | databasedev.co.uk

Audit Trails in Microsoft Access: What is an audit trail? Well...in simple terms, it is a tracking system. Audit trails are extremely useful for administrators because they can view (remote) changes to the system that they control. In Access, implementing a tracking system, or even a small...

www.databasedev.co.uk

These are all pretty easy to implement
1. Build the table.
2. Drop the code into a standard module.
3. Call the module from any form's before update event.