Electric Ant
New member
- Local time
- Today, 23:47
- Joined
- Oct 11, 2004
- Messages
- 7
I'm new to the forum so hello and thanks in advance for any help.
I don't have much experience of Access but can wing it. In the last two weeks have been working on a database specifically for data entry using Access 2000/XP so we can automate data checking and to have user friendly data entry forms.
It's in our protocol that we must double enter at least 10% of all data to check for errors. So I have one main table to contain data extracted by one user and a second identical table to contain data extracted by a different user. I want a way of flagging up any fields that don't match on a record by record basis.
I don't think Access has an automatic way of doing this so I'm thinking I need to write some code (gulp). Not done any VBA for Access before and not very familar with the objects, etc... but think I need to do a loop a bit like the following:
'loop1: for each record in table 1
'get the ID of this record
'find same record in table 2 using record ID
'loop 2: for each field in table 1
'get data in field in table 1
'get data in field in table 2
'if same then do nothing
'else write record ID, field name and data1 data2 into an array
'next field
'next record
Any other ideas or help would be very much appreciated...
I don't have much experience of Access but can wing it. In the last two weeks have been working on a database specifically for data entry using Access 2000/XP so we can automate data checking and to have user friendly data entry forms.
It's in our protocol that we must double enter at least 10% of all data to check for errors. So I have one main table to contain data extracted by one user and a second identical table to contain data extracted by a different user. I want a way of flagging up any fields that don't match on a record by record basis.
I don't think Access has an automatic way of doing this so I'm thinking I need to write some code (gulp). Not done any VBA for Access before and not very familar with the objects, etc... but think I need to do a loop a bit like the following:
'loop1: for each record in table 1
'get the ID of this record
'find same record in table 2 using record ID
'loop 2: for each field in table 1
'get data in field in table 1
'get data in field in table 2
'if same then do nothing
'else write record ID, field name and data1 data2 into an array
'next field
'next record
Any other ideas or help would be very much appreciated...
