simple query

[colguy]

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

 

[DougP]

well this is miss keyed slightly
strFinalQuery = "select table.* from table where table .column like 'tom*'"

select * From from table where column like 'tom*'"


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.