Access History

  • Thread starter Thread starter krei
  • Start date Start date
K

krei

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?
 
krei said:
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?
Click to expand...

No.
 
Not without programming efforts. If you are willing to do a little
programming, here are links to some examples:

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
 
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.

--

Cheryl Fischer, MVP Microsoft Access



Vic said:
Great info. Was looking for that same information.

I do have a question do. Will this also work if you makes changes in a
Click to expand...
sub form etc where the data is stored in a separate table with the
relationship establised?
 
Back
Top