Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
Please consider donating $1 per sample downloaded, find out why here. If downloading multiple samples, please donate once for all of them.
Amazon Honor System  Click Here
to Pay Learn More
Access 97, 2000, 2002 (XP) (Forum Locked Forum Locked)
 RAL Forums : Access 97, 2000, 2002 (XP)
Subject Topic: AUDIT TRAIL UNBOUND ACCESS 2000 Post ReplyPost New Topic
Message << Prev Topic | Next Topic >>

Joined: 27 November 2004
Location: Canada
Posts: 1
Posted: 27 November 2004 at 11:17am | IP Logged Quote CKENTEBE

I would like to know if anyone can help me with an audit trail for unbound Access 2000 forms. In my Application, I have about 10 forms and need to track changes (time of change, old value, new value) . All I have found is Audit trails for bound forms.
Any help appreciated.
Back to Top View CKENTEBE's Profile Search for other posts by CKENTEBE Send Private Message Add to Buddy List
Moderator Group
Moderator Group

Joined: 23 January 2003
Location: United States
Posts: 203
Posted: 29 November 2004 at 7:44am | IP Logged Quote Rog3erc

Sorry, I've never done an audit trail on unbound forms.  Still, it shouldn't be too different.

Just some thoughts:

When you fill your form, write the values into variables.  When you go to save, compare the values of your controls to the values of the variables and write out the ones that are different to a table.  If you are adding a new record or deleting an old record, of course you will write the whole thing to the audit table (or text log).

Does that help some?

--Roger Carlson
Back to Top View Rog3erc's Profile Search for other posts by Rog3erc Visit Rog3erc's Homepage Send Private Message Add to Buddy List

Sorry, you can NOT post a reply.
This forum has been locked by a forum administrator.

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

Powered by Web Wiz Forums version 7.01
Copyright ©2001-2003 Web Wiz Guide