Results 1 to 2 of 2
  1. #1
    Esmatullaharifi is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    40

    Question Need record of changing another records in database


    Hello Dears!
    I need any code or way that whenever any field of a record according to unique ID changed the code must save the changed field name and the current date in a specific field in another table (first field store the ID and the second one detail about changes) with add record mechanism. Suppose I have a table about the information of students with the name std_info and another info_report and when any changes make to the any field of std_info the field number and the unique ID to the table info_report. I want to use this system to record which user make changes to which records.
    Thanks,
    I looking forward to your help.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Search on "audit trail" or "audit log". One way:

    http://allenbrowne.com/appaudit.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Database changing records
    By lburgess in forum Access
    Replies: 9
    Last Post: 08-26-2014, 03:40 PM
  2. Replies: 1
    Last Post: 02-20-2013, 01:30 PM
  3. Changing multiple records
    By jcwhite in forum Access
    Replies: 3
    Last Post: 02-05-2013, 12:01 PM
  4. Is this the best way to handle changing records?
    By teresamichele in forum Access
    Replies: 17
    Last Post: 02-14-2011, 09:58 AM
  5. changing data in many records
    By cforce in forum Programming
    Replies: 1
    Last Post: 07-22-2010, 02:30 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