Updating a recordset

14-Oct-2019 02:36

The saved record will display in the list box immediately.-If you want to change category information, double click any record in the list box, make changing the category information(only category name is changeable) then click Update command button. -If you want to delete any record in a table, double click that record and click Delete command buttons.There is no content lost, all data is in the translation server, we just remove it from the repository.

See the figure below: - Save command button is used for adding new record to a table.

For the four command buttons Move First, Move Last, Move Next and Move Previous, we do not demonstrate in setting the properties and coding again.

To learn how to move records in recorset, visit: moving records in Recordset object.

Open Recordset("tbl_Employee Credentials") With Alias Comparison RS . EOF Dim Checked Cleared As Boolean Checked Cleared = False With rs .

Update End With Checked Cleared = True Else If CStr(Alias Comparison RS(Field Checked).

See the figure below: - Save command button is used for adding new record to a table.For the four command buttons Move First, Move Last, Move Next and Move Previous, we do not demonstrate in setting the properties and coding again.To learn how to move records in recorset, visit: moving records in Recordset object. Open Recordset("tbl_Employee Credentials") With Alias Comparison RS . EOF Dim Checked Cleared As Boolean Checked Cleared = False With rs . Update End With Checked Cleared = True Else If CStr(Alias Comparison RS(Field Checked). Move Next Loop If Field Checked Cleared = False Then Debug. Close Set rs = Nothing End Function Thank you very much for the link!