Data type mismatch in criteria expression.

[Fary4u]

using " & variable & " ...
Syntax error (missing operator) in query expression
-----------------------------------------------------
'(orderID=5) and (productID=101) and (prodcolor=Medium) and (prodsize=300x300x300)'.

ocon2.Execute "DELETE FROM itemsOrdered WHERE (orderID=" & intOrderID & ") and (productID=" & intProdID & ") and (prodcolor=" & stprodcolor & ") and (prodsize=" & stprodsize1 & ")"
 

-----------------------------
if i use ' " & variable & " ' ...

Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
---------------------------------------------

ocon2.Execute "DELETE FROM itemsOrdered WHERE (orderID='" & intOrderID & "') and (productID='" & intProdID & "') and (prodcolor='" & stprodcolor & "') and (prodsize='" & stprodsize1 & "')"
 

[Fary4u]

Problem with Numeric and string value even doing the rite way but still giving the error ?

datafiled no: work fine| intOrderID = "7"
datafiled no: work fine| intProdID = "2"
datafiled Chr: work fine| stprodcolor = "Medium"
datafiled Chr: data mismatch| stprodsize = "400x400x400"
datafiled Chr: no value given| ncolr = "Black"
 
 
intOrderID = "7"
intOrderID = cStr(intOrderID)
intProdID = "2"
intProdID = cStr(intProdID)
stprodcolor = "Medium"
stprodsize = "400x400x400"
stprodsize = cStr(stprodsize)
ncolr = "Black"
ncolr = cStr(ncolr)
 
SQL = "DELETE FROM itemsOrdered WHERE (orderID=" & intOrderID & ") and (productID=" & intProdID & ") and (prodcolor=" & stprodcolor & ") and (colour=" & ncolr & ") and (size=" & stprodsize &")"
 

[Nicodemas]

Do not type cast the variables. You have already made them strings by wrapping them in quotation marks.

Your SQL statement will also fail because you must wrap any string variable in single quotes and any numeric variables must not be within quotes. Check your code for this.