Access History

message from krei on 19 May 2004
Is there any way to get history of changes like it`s done
in EXCEL(there it`s called "History worksheets"),
without any programming efforts?
 
Cheryl Fischer replied to krei on 19 May 2004
Access 97: How to Create an Audit Trail of Record Changes in a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;183792

Access 2000: How to Create an Audit Trail of Record Changes in a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;197592

There are many ways to create an audit trail of changes to records,
depending on what kind of info you want in the audit trail, whether you want
to maintain it in the same table or in a separate table, etc. For another
look at this subject, here is a link to an excellent article by MVP Allen
Browne:

http://members.iinet.net.au/~allenbrowne/AppAudit.html
 
=?Utf-8?B?Vmlj?= replied to Cheryl Fischer on 19 May 2004
Great info. Was looking for that same information.

I do have a question do. Will this also work if you makes changes in a sub form etc where the data is stored in a separate table with the relationship establised?
 
Cheryl Fischer replied to =?Utf-8?B?Vmlj?= on 19 May 2004
Presuming that you add a field (Updates) to the table to which your subform
is bound, a bound control named Updates to the subform and add
=AuditTrail() to the BeforeUpdate event of the form which is serving as the
subform, it should work the same. Test it out.
 
Rick Brandt replied to krei on 19 May 2004
No.
 

Archived message: Access History (MS Access Error Message)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.