Query Problem in VBA

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I have a query, which in the query builder runs fine. I
place that same query into VBA and open it using a
recordset object. In VBA it returns nothing. There is
criteria in the query which his a string value. I surround
the criteria with '" & criteria & "'. I done this in many
places within the database with no problem. Here the
recordset returns no records. I know this because
recordset.recordcount = 0.

Why! Any suggestions would be greatly appreciated!

Kevin
 
Kevin said:
I have a query, which in the query builder runs fine. I
place that same query into VBA and open it using a
recordset object. In VBA it returns nothing. There is
criteria in the query which his a string value. I surround
the criteria with '" & criteria & "'. I done this in many
places within the database with no problem. Here the
recordset returns no records. I know this because
recordset.recordcount = 0.

Why! Any suggestions would be greatly appreciated!
Click to expand...

Kevin -

I posted a response in your original thread. Please followup in that
thread.
 
Back
Top