/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 vote223 views1 answer
Vba copy file
VBA
1 vote221 views1 answer
Vba login website
VBA
0 vote216 views4 answers
How to continue formula in below line in vba code
VBA
0 vote219 views1 answer
Vb run command
VBA
0 vote228 views1 answer
Vba multiple optional arguments
VBA
0 vote233 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote237 views1 answer
Vba code for cutoff time
VBA
2 votes218 views1 answer
Excel vba check if string entirely numeric
VBA
2 votes193 views2 answers
Constructor vb.net
VBA
0 vote212 views1 answer
Xlbycolumns is not declared
VBA