/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 votes292 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
5 votes321 views1 answer
Excel vba right word from Long Integer
VBA
0 vote286 views1 answer
Vbnet line chart showing extra space
VBA
0 vote299 views1 answer
VBA is form loaded
VBA
1 vote282 views1 answer
Excel vba last row of range
VBA
1 vote314 views1 answer
How to put a gridpain in a vbox
VBA
0 vote317 views1 answer
Style percent not found vba
VBA
0 vote299 views1 answer
Send text to clipboard vb.net
VBA
5 votes274 views1 answer
Vba array worksheet.index
VBA
0 vote293 views1 answer
Vb get ip address
VBA