Audit trail for Unbound forms

Luthius

Active Member
Joined
Apr 5, 2011
Messages
324
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
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
What will you be auditing?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,491
Messages
6,113,963
Members
448,536
Latest member
CantExcel123

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
Back
Top