Just the full form of .BOF and .EOF

[Guest]

Could any one can explain me the following, which I am unable to understand :

If rs.BOF = False Then
rs.MoveFirst

**What does .BOF stands for

If rs.EOF = False Then
rs.MoveFirst


Thanks & best regards.


Irshad.

 

[Alex Dybenko]

BOF - stands for begin of file

better to write:
If rs.BOF = False and rs.EOF = False Then
rs.MoveFirst
end if
this will avoid error if recordset is empty


Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

 

[David C. Holley]

..BOF Beginning of File
..EOF End of File

Typically, if you're looping through a recordset you would use a
While...wend or other type of loop as in

While rs.EOF = false
{code}
rs.EOF
Wend