It says that to get rid of a "type mismatch" error I should add the DAO.lib. But I already had it and I always got the error. Set oSQL = "SELECT * FROM TableInfo WHERE Caption Like '" & strTarget & "'* "
The last ampersand is the type mismatch.
Type mismatch error
- Thread starter eme126
- Start date
It says that to get rid of a "type mismatch" error I should add the DAO.lib. But I already had it and I always got the error. Set oSQL = "SELECT * FROM TableInfo WHERE Caption Like '" & strTarget & "'* "
The last ampersand is the type mismatch.
the star/wildcard should be within the quotes, should it not?
edit: clarification: it should be within the single quotes, i.e. :
i think that would cause a type mismatch..
edit: clarification: it should be within the single quotes, i.e. :
Code:
strSQL = "SELECT * FROM tblSomething WHERE Field LIKE '" & strTemp & "*';"i think that would cause a type mismatch..
