Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
recordset edit method in ADO?
- Thread starter VBUser77
- Start date
- Thread starter
- #3
- Thread starter
- #6
If you are just editing a record in an ADO recordset, use Update method:
rst.Update "name of field", "value for field"
If you are going to make the same change to more than one record, consider opening a recordset using a select query sql with only records you need to change. Then add code to make the changes:
Do Until (rst.EOF)
rst.Update "field name", "value"
rst.MoveNext
Loop
Hope this helps.
Jeff
rst.Update "name of field", "value for field"
If you are going to make the same change to more than one record, consider opening a recordset using a select query sql with only records you need to change. Then add code to make the changes:
Do Until (rst.EOF)
rst.Update "field name", "value"
rst.MoveNext
Loop
Hope this helps.
Jeff
- Status
Similar threads
- Locked
- Question
- Locked
- Question