Solved

Same Code - Different results

Posted on 2011-03-02
2
275 Views
Last Modified: 2012-05-11
Hi,

..I have tried multiple fixes here but no joy .. 3 hours later..

I have written an audit trail.
There is an additional "memo" field on each record "Auditmemo".
 (Uses OldValue etc).

The audit trail works perfectly on form "AA_ThisWorks". (Note the unique record ID in grey on left of screen).  
The before update event of form is "=audit()".

All good so far!
However, when I try to use this audit trail on another form or table  ... the following happens.

PROBLEM: See AA_ThisFails
If there is more than one change to a single record then ONLY the last change is recorded in the "Auditmemo" field,

WHY ??  This works fine in AA_ThisWorks

(The Audit buttons on the screen may help to understand my problem).
I have hidden some forms/tables from view for simplification


All Help greatly appreciated on this one .... it has been frustrating me for hours.



Database1.zip
0
Comment
Question by:Patrick O'Dea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 35017190
test this

modified codes in the function audit
Database1.accdb
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 35019375
Perfect - thanks once again
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question