Setting Up Record Auditing in UI Builder

Step 1: Open the Audit History Setup form

MS Access Record Auditing Step 1

Step 2: Choose the table you want to track adds/changes/deletes

MS Access Record Auditing Step 2
Note that you can add auditing to subforms displayed on a parent form as well. Simply select the name of the subform.
Important
UI Builder auditing cannotsupport multi-value lookup fields. If your table contains a multi-value field an error may occur when trying to create your audit table.

Step 3: Select the form to which you want to add auditing

MS Access Record Auditing Step 3

Step 4: Leave the audit table name 'as-is' unless you are an advanced user

MS Access Record Auditing Step 4

Step 5: Select and copy (Ctrl+C) the VB code provided in the box

MS Access Record Auditing Step 5

Step 6: Open your form in Design view and select the "View Code" button in the Ribbon

MS Access Record Auditing Step 6

If you are adding auditing to a subform, make sure you paste the VB code into the subform form, not the parent form.

Step 7: The VB Editor will open

MS Access Record Auditing Step 7

Step 8: Paste the code into the top as shown below using Ctrl+V. The click "Save" to save your changes.

MS Access Record Auditing Step 8
If your form already has code within it, check to make sure there isn't already an event named Form_AfterUpdate, Form_AfterInsert, or Form_AfterDelete. If you do, then you will want to paste the If...Then statement provided by UI Builder into the respective existing VB subroutines. Contact support if you need help.

Step 9: Activate Auditing

MS Access Record Auditing Step 9
Copyright © 2017 OpenGate Software Inc. All Rights Reserved.

MS Partner