/VBA/How to use VBA to add new record in MS Access?

How to use VBA to add new record in MS Access?

Private Sub btnAddRecord_Click() 
Dim tblCustomers As DAO.Recordset 

Set tblCustomers = CurrentDb.OpenRecordset("SELECT * FROM [tblCustomers]") 
tblCustomers.AddNew 
tblCustomers![Customer_ID] = Me.txtCustomerID.Value 
tblCustomers![CustomerName] = Me.txtCustomerName.Value 
tblCustomers![CustomerAddressLine1] = Me.txtCustomerAddressLine1.Value 
tblCustomers![City] = Me.txtCity.Value 
tblCustomers![Zip] = Me.txtZip.Value 
tblCustomers.Update 
tblCustomers.Close 
Set tblCustomers = Nothing 
DoCmd.Close 
End Sub

Source: stackoverflow.com

Similar codes

0 vote334 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote329 views1 answer
Search in richtextbox vb.net
VBA
4 votes399 views1 answer
VBA Deep Clone Dictionary
VBA
1 vote351 views2 answers
Vba string length
VBA
0 vote365 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote347 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
1 vote332 views1 answer
Vba date to unix timestamp
VBA
0 vote323 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote322 views1 answer
Vba dictionary clear
VBA
0 vote334 views1 answer
Vbnet chart make 0 gridline line different color
VBA