Go to: Articles List

How to know if no records were returned:

 'Do database connection
 sql = "select this from that where this = 'whatever'"
Set RS = Conn.Execute(sql)

 'Do this test
 If RS.BOF And RS.EOF Then
      'No records were returned
 Else
      'Loop through to show records
 End If
      By testing to see if the you are at the beginning and the end of the file
you will be able to tell if no records were returned.