Expand|Select|Wrap|Line Numbers
- sqltrans = "Select * from Transactions "
- sqltrans = sqltrans & "where [checked in date] IS NULL "
- sqltrans = sqltrans & "And [Checked out to]= """ & rspatrons!ID & """"
- rstrans.Open sqltrans, CurrentProject.Connection, adOpenDynamic, adLockOptimistic
error msg is datatype mismatch in criteria expression.
I tried the sql directly, I could succeed, so i assumed
it is something to do with the syntax.
how to testify null value by integrating to vba ?
how to solve the aforementioned problem ?
thank