/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

2 votes187 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote196 views1 answer
Make your computer talk vbscript
VBA
0 vote193 views1 answer
Not allow form to be resized
VBA
0 vote176 views1 answer
Vbnet check if string is only symbols
VBA
0 vote175 views1 answer
Remove frist letter from string vbnet
VBA
-1 vote178 views1 answer
Text to speech vb.net
VBA
0 vote167 views1 answer
Vbnet add new ecel sheet
VBA
0 vote240 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote189 views1 answer
Loop through each cell in dgv vbnet
VBA
1 vote180 views1 answer
Add control vb
VBA