Empty Recordset

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
If you're using OpenRecordset to open it, try:

Set rs = db.OpenRecordset(SQL)
If rs.BOF And rs.EOF Then
' It's empty
Else
' It's not empty
End If

If you have something else in mind, please give more details.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO test for empty recordset 3
checking .bof and .eof for empty recordset? 4
My Dates are Zeros 3
Processing Crosstabs in ADO 1
Data Access Page Development Questions 1
Checking a value in a recordset 3
A2007 ADO Recordset Clone 1
Creating a recordset 8

Back
Top