Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Audit Log

Discussion in 'Information Technology' started by Sue Wilkes, Jul 28, 2006.

Tags:
  1. Sue Wilkes

    Sue Wilkes
    Expand Collapse
    Guest

    sI think I have created correctly the login tips provided by Allen Browne
    however I'm having a few problems with it working correctly. Firstly it only
    shows 'Edit To records for those records created prior to the audit log
    setup, those entered after it do not show any changes. Secondly it only
    shows 'Edit To' Log and never Edit From' records for either previous or new
    entries. Any help would be greatly appreciated.
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Temporarily disable the error handler, by adding a single quote to the first
    line in each procedure, i.e.:
    'On Error GoTo ...

    Now the code will fail, and you can see which line contains the error, and
    track down why the write is not succeeding.

    For example, you might have a unique index on a field in the audit table
    that prevents subsequent records for the same value from being entered.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Sue Wilkes" <Sue Wilkes@discussions.microsoft.com> wrote in message
    news:AD2AC5C3-9C09-4B94-A037-EEA6D17F50C0@microsoft.com...
    > sI think I have created correctly the login tips provided by Allen Browne
    > however I'm having a few problems with it working correctly. Firstly it
    > only
    > shows 'Edit To records for those records created prior to the audit log
    > setup, those entered after it do not show any changes. Secondly it only
    > shows 'Edit To' Log and never Edit From' records for either previous or
    > new
    > entries. Any help would be greatly appreciated.
     

Share This Page