Very Computer

1. DAO code to compare two fields in two tables

Hi guys,

I am trying to compare two fields in two tables and then change the
value(boolean) of one field in one table based on the value in the other
table. I have written the following code which should work but does not.
Where am I going wrong?

Private Sub cmdfindactive_Click()

Dim dbs As Database
Dim rstnew As Recordset
Dim rstold As Recordset

Set dbs = CurrentDb
Set rstnew = dbs.OpenRecordset("accinfo")
Set rstold = dbs.OpenRecordset("accinfo_old")
rstnew.MoveFirst
rstold.MoveFirst
Do While Not rstold.EOF

    Do While Not rstnew.EOF

        If rstnew![area/org] = rstold![area/org] Then
            With rstnew
                .Edit
                ![active] = rstold![active]
                .Update
            End With
        Else

            With rstnew
                .Edit
                ![active].Value = False
                .Update
            End With
        End If

        rstnew.MoveNext
    Loop
rstold.MoveNext
Loop

End Sub

2. Seattle - DBA at a great startup!

3. Comparing two columns in two tables

4. dbcomboboxes duplicates

5. comparing two databases on two different servers?

6. Replication on INFORMIX ?

7. comparing and altering two tables,Databases

8. Reports to Text and Printing Source Code

9. Comparing two tables in different databases

10. newbie: Compare two Database Tables?

11. Compare two access databases, size of tables

12. Comparing two tables and appending data to destination table

13. Comparing table contents of two tables