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

Editing Records To modify a record, change its field values and call the Recordset's Update method. ' Find the record to modify. … ' Make the changes. rs!Name = new_name rs!Street = new_street … ' Save the changes. rs.Update To make a new record, use AddNew. ' Make the new record. rs.AddNew ' Set the field values. rs!Name = new_name rs!Street = new_street … ' Save the changes. rs.Update