/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 vote346 views1 answer
Vba table header name
VBA
3 votes336 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote332 views1 answer
Vbnet get file name from path
VBA
2 votes317 views1 answer
Vba uppercase first letter of each word
VBA
15 votes462 views2 answers
Xl vba dynamic string array
VBA
0 vote328 views1 answer
Remove frist letter from string vbnet
VBA
0 vote333 views1 answer
Type excel.application is not defined vb
VBA
0 vote324 views1 answer
Vba argument is set
VBA
0 vote348 views1 answer
Excel vba clear filter
VBA
1 vote326 views1 answer
Add a index column power bi
VBA