ADO - EOF&BOF

In ADO (ActiveX Data Objects), the BOF and EOF properties are used to determine whether the current record position in a Recordset object is before the first record or after the last record.

1. BOF (Beginning of File)

Meaning: Indicates whether the current record position is before the first record in the Recordset.

Syntax:

If rs.BOF Then
    ' Code to handle when before first record
End If

When True:
- When the Recordset is empty (no records at all).
- When you move before the first record, for example, using:
```
rs.MovePrevious
```
  while already on the first record.

2. EOF (End of File)

Meaning: Indicates whether the current record position is after the last record in the Recordset.

Syntax:

If rs.EOF Then
    ' Code to handle when after last record
End If

When True:
- When the Recordset is empty.
- When you move past the last record, for example, using:
```
rs.MoveNext
```
  while already on the last record.

3. Common Usage Example

In ADO, it’s common to check for both properties before processing records:

Set rs = conn.Execute("SELECT * FROM Employees")

If rs.BOF And rs.EOF Then
    MsgBox "No records found!"
Else
    rs.MoveFirst
    Do Until rs.EOF
        MsgBox rs("EmployeeName")
        rs.MoveNext
    Loop
End If

4. Key Points

BOF and EOF are Boolean properties (True or False).
Both are True when the Recordset is empty.
You typically check If rs.EOF in loops to detect when you’ve reached the end of records.
Moving before the first or after the last record sets these flags to True.