Hi
This is a simple question
a query "select * from table where table.column like 'a*'" works good in access but when the same query is opened with adodb.connection gives the recordset.recordcount as 0 whatsoever
strFinalQuery = "select table.* from table where table .column like 'tom*'"
Dim SearchRs As New Recordset
Dim cnn As ADODB.Connection
Set cnn = CurrentProject.Connection
SearchRs.Open strFinalQuery, cnn, adOpenStatic, adLockReadOnly
MsgBox parentSearchRs.RecordCount
this gives a recordcount of 0
hope some one can help me out
This is a simple question
a query "select * from table where table.column like 'a*'" works good in access but when the same query is opened with adodb.connection gives the recordset.recordcount as 0 whatsoever
strFinalQuery = "select table.* from table where table .column like 'tom*'"
Dim SearchRs As New Recordset
Dim cnn As ADODB.Connection
Set cnn = CurrentProject.Connection
SearchRs.Open strFinalQuery, cnn, adOpenStatic, adLockReadOnly
MsgBox parentSearchRs.RecordCount
this gives a recordcount of 0
hope some one can help me out
