Unanswered: 80040E07 - Data Type Mismatch in Criteria Expression??
i keep getting this error:
80040E07 - Data Type Mismatch in Criteria Expression
when trying to execute the following code:
For i = 0 To (intLength - 1)
thePosition = CInt(arrItems(i))
strSQL = "SELECT ItemPosition FROM tblOrder WHERE ItemPosition = " & thePosition
**.Open strSQL, conPubs, adOpenDynamic, adLockOptimistic
.Fields("ItemPosition") = CInt(i)
i'm using an access db where ItemPosition is of type "number" (specifically Integer). arrItems is a single dimensional array of strings...and the for loop is working correctly. it gives me the error on the ** line.