Audit trail for Unbound forms

Luthius

Active Member
Joined
Apr 5, 2011
Messages
306
Guys
There are a couple of good examples in the internet on how to implement an audit trail database.
But unfortunetaly are examples for bound forms/controls.
I'm developing a database with unbound forms/controls.
I cannot use the property OldValue on unbound controls so I cannot implement the audit trail.

What is the best thing to do?
-Create a class modules with objects that can "clone" the values when the form is opened?
-Create arrays to collect the old values and then compare with values of each control when I trigger the Save button?

I really dont know what to do.
I cannot bound these forms/controls in my project.

Some Audit Trails examples (Bound forms)
https://hitechcoach.com/index.php/downloads-mainmenu-28/audit-trail

http://www.datawright.com.au/access_resources/tracking_data_changes_in_access.htm
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

JonXL

Active Member
Joined
Feb 5, 2018
Messages
417
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
What will you be auditing?
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
2,019
Office Version
  1. 365
Platform
  1. Windows
You can probably use temp tables, bind the controls to the temp and use old value property and auditing code. Write record (update) back to main table IF the record is altered and flush the temp table on form close. I did play around with what I recall was a table/field level audit feature that I seem to recall was built in, but that was a while ago and not very impressive. I cannot recall how to turn it on.

Note
- I am not referring to continually creating/deleting any tables.
- deleting temp tables in a shared db is tricky - better that each user has their own fe (always preferred approach anyway) and the temps are local.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,519
Messages
5,602,141
Members
414,505
Latest member
quoctrungvu99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top