Hello everybody,

I have a syntax error in this code:

With adoRS

db.Execute "DELETE from MyTable WHERE format(ID," & Chr(34) & "mm/dd/yyyy HH:MMS" & Chr(34) & ")=" & varD

.MoveNext
If .EOF Then .MoveLast
End With

varD is DateTime type variable.

I've tried without formatting, still have an error. Can anybody help me out? Thanks.

First step is making sure the defined recordset is good... Have you tried putting this in a select query yet?

SELECT * from MyTable WHERE format(ID," & Chr(34) & "mm/dd/yyyy HH:MMS" & Chr(34) & ")=" & varD

I' ve tryed this in Access:

Select * from MyTable where ID=#1/15/2004 13:15:5#;

and it works fine. When I substitute:

varD = .Fields("ID") ' varD is DateTime type
db.Execute "Select * from MyTable WHERE ID=#" & varD & "#"

It gives me an error: Missing operand.