run time error 3075 1

[tksy]

HI

I am gettinga run time error in´my code

Sub UpdateNulls()
Dim strSQL As String
Dim rs As DAO.Recordset
For Each tdf In CurrentDb.TableDefs
If Left(tdf.Name, 4) <> "Msys" And tdf.Name <> "Table1" Then
strSQL = "Select * From [" & tdf.Name & "] a Inner Join table1 On a.fall = table1.fall Where a.Status = 5"

Set rs = CurrentDb.OpenRecordset(strSQL)

Do While Not rs.EOF
For i = 0 To rs.Fields.Count - 1
If IsNull(rs.Fields(i)) Then
rs.Edit
rs.Fields(i) = 111111
rs.Update
End If
Next
rs.MoveNext
Loop

End If
Next
End Sub


I am getting runtime error on operator missing
a.fall = table1.fall

 

[PHV]

OOps, misunderstood the "first table" stuff.
You meant that 01UMWELT wasn't updated but the others ?
The Simplest way:
For Each tdf In CurrentDb.TableDefs
If Left(tdf.Name, 4) <> "Msys" Then
strSQL = "Select a.* From [" & tdf.Name & "] a Inner Join 01UMWELT On a.fall = [01UMWELT].fall Where [01UMWELT].Status = 5"
...


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tksy]

THanks that helped