Creating a Access Audit Trail

Rating9.3Excellent

Hello Experts –

I have an audit trail module that is just not working correctly. It’s supposed to log changes on a form and put them into a table for later use. What I’m getting is a INTO error in my code and I can’t find out why. I need help on this one.

I’m including a sample database that has the code module and form. I you make a change to any field on the form the [b]BEFOREUPDATE[/b] event of the form has the call for the code to run. And that’s when I get the error message; [i][b]Syntax Error in Insert Into Statement 3134[/b][/i].

Thanks in advance, ***** [i][b]See Sample Database for code [/b][/i]*****

GeneBat

db-audit-trail.mdb
- 200 KB
Audit Trail Sample Database

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution

View This Solution - Start Your 30 Day Free Trial

Zone: general
Tags
Participating Experts: 1
Solution Grade: A

Replies

by: rockiroads

Posted on 2010-09-07 at 09:04:40ID: 35532301

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

by: rockiroads

Posted on 2010-09-07 at 09:06:33ID: 35532302

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

by: GeneBat

Posted on 2010-09-07 at 09:20:58ID: 35532303

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.