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

The Fields Collection The Recordset object's Fields collection contains a Fiel object for each of the currently selected Recordset's fields. You can access values by field name, collection key, or collection index. rs!Name rs.Fields("Name") rs.Fields(0) ' Takes about 85% as long. Important Field Object Properties: Value Name Type