ADO Tips & Tricks 1) Connection Object a) Opening the Database b) Executing Commands c) Executing Queries d) Closing the Database 2) Recordset Object a) The Fields Collection b) Editing Records 3) Tools a) One Column Queries b) ComboBox Example c) One Row Queries d) Multi-Column Queries e) Getting Field Names f) ComboBox Example, 2 4) A Useful Example a) The SELECT Clause b) The WHERE Clause c) The Query Download Example Programs

Recordset Object A Recordset represents data returned by a query. Important Methods: Open MoveFirst Delete GetRows Close MoveLast AddNew MoveNext Update MovePrevious CancelUpdate Important Properties: BOF EOF If BOF and EOF are both True, the Recordset is empty.