Data type mismatch...
Posted on 2003-03-29
I'm trying to open a Recordset using a SQL query, my code is like this:
rsSeg.Open "SELECT * FROM Seguimientos WHERE Fecha=#" & fecha & "# AND Hora=#" & hora & "# AND NoCliente='" & Val(lista((indice * 3) + 2)) & "'", DB, adOpenKeyset, adLockOptimistic
Both Fecha and Hora are date types.
Lista is a string array.
The thing is, I always get the "Data Type mismatch in criteria expression" error, even though I have tried several changes.
I'd be glad if u could help me.
Thanks in advance.