Call update method from Recordset : Recordset Add Update Delete « Access « VBA / Excel / Access / Word






Call update method from Recordset

 
Public Sub ADOUpdate()
  Dim rs As ADODB.Recordset
  Dim strSQL As String
  
  Set rs = New ADODB.Recordset
  strSQL = "SELECT CompanyName, Address, City FROM tblCompany WHERE (CompanyName = 'Liams Diner')"
  
  rs.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
  
  With rs
    !CompanyName = "Diner"
    .Update
  End With
  rs.Close
End Sub

 








Related examples in the same category

1.Add new a row to recordset
2.Adding a New Record to a Recordset
3.Use AddNew and specify the field information
4.Use AddNew method from Recordset and two arrays to add a new row
5.Adding a New Record to a Table
6.Modifying a Record
7.Performing Batch Updates
8.Delete row for a certain criteria
9.Deleting a Record
10.Call delete method in Recordset
11.Check the Recordset affected