Select String Follow
I have a select string in my VBscript, where I want to get data specified by some values in my label.
This works great:
rs.open "SELECT * FROM [Ark1$] WHERE [Modelnr:] = '" & Format.NamedSubStrings("subModel").Value & "' AND [Farve:] = '" & Format.NamedSubStrings("subFarve").Value & "' "
But when I add another WHERE statement, I get this error: Datatypes mismatch
The only thing I see that can be a problem, is the value in the text object and in my excel database is a number.
Do I have to specify this somewhere?
Please sign in to leave a comment.