Hi,
I am getting error
"The connection cannot be used to perform this operation. It is either closed or invalid in this context"
due to LIKE OPERATOR
while trying to open a recordset as follows:
rsUnReconCb.Open "SELECT * From CBRECON WHERE CBReconciled = False AND ( CBTag Like '" & "%" & rs121Tag!cbtag1 & "%'" & " Or CBTag Like " & "'*" & rs121Tag!cbtag2 & "*' ) , AdoCon, adOpenDynamic, adLockOptimistic"
SELECT statement reads as follows:
SELECT * From CBRECON WHERE CBReconciled = False AND ( CBTag Like '*bom*' Or CBTag Like '*del*' )
Please someone rectify the statement.
I am getting error
"The connection cannot be used to perform this operation. It is either closed or invalid in this context"
due to LIKE OPERATOR
while trying to open a recordset as follows:
rsUnReconCb.Open "SELECT * From CBRECON WHERE CBReconciled = False AND ( CBTag Like '" & "%" & rs121Tag!cbtag1 & "%'" & " Or CBTag Like " & "'*" & rs121Tag!cbtag2 & "*' ) , AdoCon, adOpenDynamic, adLockOptimistic"
SELECT statement reads as follows:
SELECT * From CBRECON WHERE CBReconciled = False AND ( CBTag Like '*bom*' Or CBTag Like '*del*' )
Please someone rectify the statement.