/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 vote240 views1 answer
Delete all controls in an area vb
VBA
0 vote235 views1 answer
Vbs run with cscript
VBA
0 vote205 views1 answer
Style percent not found vba
VBA
0 vote210 views1 answer
Vba check 32 or 64 bit
VBA
0 vote244 views1 answer
Sendkeys vba selenium
VBA
0 vote209 views1 answer
How to set location and size of new from vb
VBA
0 vote207 views1 answer
Vba word pdf table to excel
VBA
0 vote287 views1 answer
Application.ExecutablePath VB.NET
VBA
1 vote219 views1 answer
Excel date to unix timestamp
VBA
1 vote224 views1 answer
Add rows to datagridview vb.net
VBA