Results 1 to 3 of 3
  1. #1
    nnn is offline Novice
    Windows 11 Access 2016
    Join Date
    Aug 2022
    Posts
    1

    Audut Trail for tracking changes done in form along with the logged in Username via Login form

    Hello,



    I want to create Audit Trail for the Ms Access Forms where it tracks the changes done to the form with formname, date/time, changes done along with who did the changes via login form.

    Could any one please help me in the code for the same? I need it urgently.

    Thanks

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    3,501
    Not thought to google?
    Allen browne's site has some audit trail code, another person is martin green I think.
    https://www.access-programmers.co.uk...-trail.324261/
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,503
    nnn,

    Some clarity please. You say "changes done to the form" which sounds like design changes to a form??
    Typically an audit trail is for tracking changes to data values in the underlying tables.

    Be cautious of the Martin Green version--see this.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 47
    Last Post: 05-10-2021, 01:59 PM
  2. Access - Login Form and Store ID/Username
    By RiskIt in forum Access
    Replies: 3
    Last Post: 01-07-2019, 03:08 AM
  3. Replies: 3
    Last Post: 03-17-2014, 10:23 AM
  4. Username and passwod login using Form
    By Tom1 in forum Programming
    Replies: 4
    Last Post: 07-04-2012, 12:29 PM
  5. Replies: 3
    Last Post: 06-22-2012, 04:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums