G Guest Nov 5, 2005 #1 When you open a recordset, how do you test for the case where it has no records?
K Ken Snell [MVP] Nov 5, 2005 #2 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 = 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
G Guest Nov 6, 2005 #4 Thanks Alex. Alex Dybenko said: if rst .eof and rst.bof then 'recordset has no records end if Click to expand...
Thanks Alex. Alex Dybenko said: if rst .eof and rst.bof then 'recordset has no records end if Click to expand...
G Guest Nov 6, 2005 #5 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...
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...