drtrmiller
asked on
Compare Records in Identical Tables and Highlight Changes (Access 2007)
What is the best way to take two identical tables, one consisting of account specific records only, and another consisting of records from all accounts (the redundancy is a security implementation), and easily examine which records have been added, and which ones have been modified when comparing to the master table?
I want to be able to manually approve both individual and batch appends/updates (adding new records from the account specific table to the master table, or updating master table records to reflect changes in the account specific table) using this method, and preferably have a means, through a form/query combination or other means, of using conditional formatting to determine which specific fields have been modified in some instances, and entire records in others.
Thanks.
I want to be able to manually approve both individual and batch appends/updates (adding new records from the account specific table to the master table, or updating master table records to reflect changes in the account specific table) using this method, and preferably have a means, through a form/query combination or other means, of using conditional formatting to determine which specific fields have been modified in some instances, and entire records in others.
Thanks.
ASKER
I am clueless as to the nature of master/child. Are you saying I create a form where there is the "master" data and a subform containing "child" data? I am thinking I have many "children," so I just don't know how to make this work.
I was thinking I needed a query that could just show new/modified records and then I could handle the conditional statements through that form format, but how do I get a query to show new/modified records from Account A, B, and C (each with their separate table) to compare to a master account list (single table containing all records from A+B+C...)?
I was thinking I needed a query that could just show new/modified records and then I could handle the conditional statements through that form format, but how do I get a query to show new/modified records from Account A, B, and C (each with their separate table) to compare to a master account list (single table containing all records from A+B+C...)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could build a master/child setup, where your child records would navigate through as you move through your Parent records. You could then do a field-by-field comparison (assuming the tables are IDENTICAL in structure) something like this:
If Me.Field1 <> Me.YourSubform.Form.Field1
Me.YourSubform.Form.Field1
Else
Me.YourSubform.Form.Field1
End If
Note that YourSubform is the name of the Subform CONTROL on the parent form, and may or may not be named the same as the form you're using as a subform.