This sample illustrates one way to produce a simple audit trail table containing: machine name, login name, user name (access security), record number, field name, original value, new value, and a date/time stamp. It tracks all changes made to a record in either the form or subform. It also tracks when new records are inserted and when records are deleted and the values of the deleted fields. It does not work properly for deleting if Cascade Deletes is set. It will show the deletes from the main form, but not the subform. Code is contained in Module1 and is called from each text box on each form. There are no doubt many improvements that can be made. This is just for illustration purposes.
Download
Access 97 (58 KB): AuditTrail97.zip
Access 2000 DAO (59 KB): AuditTrail2k.zip
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Top 10 benefits of Access 2010 1 Get started faster and easier than ever before . Harness the power of the community in Access 2010. Buil...
-
During the era of scientific management, Henry Gantt developed a tool for displaying the progression of a project in the form of a specializ... -
Trainer: Don Jones Videos: 20 Time: 6 hrs This series shows you how to build Web applications for Windows, using version 4 of the .NET Fra...
-
A concise, focused study aid aimed at preparing you for PMP certification The Project Management Profressional (PMP) certification is the... -
Product Description Fast answers to frequently asked questions Excel 2007 essentials at your fingertips! If you like your answers quic... -
Video learn for Project management , PMP CBT nuggets , I would like to thank this company about what they added value This is introduction...
-
Project management Essay Lets discuss about project management , the project management is Skills and techniques, project management sk...
-
Description:The PMBOK® Guide–Fourth Edition continues the tradition of excellence in project management with a standard that is even easie... -
This sample is a useful template for an application. It has a number of standard forms for maintaining reference tables, viewing reports,...
No comments:
Post a Comment