Test for empty recordset?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When you open a recordset, how do you test for the case where it has no
records?
 
If rst.EOF = True And rst.BOF = True Then
' there are no records in the recordset
End If

or


If rst.RecordCount = 0 Then
' there are no records in the recordset
End If
 
if rst .eof and rst.bof then
'recordset has no records
end if
 
Thanks Ken.


Ken Snell said:
If rst.EOF = True And rst.BOF = True Then
' there are no records in the recordset
End If

or


If rst.RecordCount = 0 Then
' there are no records in the recordset
End If
Click to expand...
 
You must log in or register to reply here.

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
Empty Recordset 1
ADO - delete/ update recordsets 5
Creating subroutine with Function using sql recordsets 1
checking .bof and .eof for empty recordset? 4
Create a tmp table from recordset 9
How do you set a recordset's bookmark? 5
Recordset problem 2

Back
Top