Link to home
Start Free TrialLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

Audit Trail, Data Accesss Macros

Experts,

I have an audit trail in my db now but it stopped working.  I went to AJB's website as I followed the procedure to implement and it states 2010 is better at creating an audit trail through the use of Data Accesss Macros (sorta like "triggers" as AJB states)

I use 2010 and I am interested in knowing how to implement an audit trail in 2010 using the Data Accesss Macros.  It seems as though the trigger method is similar to AJB's procedure.  

website:
http://allenbrowne.com/appaudit.html

Thank you
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pdvsa

ASKER

oh that seems simple enough.  i suspect an Append query would be developed on one of the buttons.  

How do you get the buttons to show like yours?  

thank you

User generated image
Avatar of pdvsa

ASKER

Would this work in a split table structure where a BE is on the network?
<<oh that seems simple enough.  i suspect an Append query would be developed on one of the buttons.  >>

 If only it were that simple.   You actions in a data macro are quite restricted and running a query is not an option.   You have to use the CreateRecord action and set each of the individual fields.

<<How do you get the buttons to show like yours?  >>

Change the view to datasheet view.

Jim.
Avatar of pdvsa

ASKER

I actually reverted back to AJB's method.  The data macros seemed to be too complicated for me.   thank you
<<I actually reverted back to AJB's method.  The data macros seemed to be too complicated for me.   thank you >>

 Their not simple to work with that's for sure and the editor, one step at a time?  Yuck.

Jim.