/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 vote145 views3 answers
Write to text file vb.net
VBA
-1 vote137 views1 answer
Text to speech vb.net
VBA
1 vote159 views1 answer
Sort using vba
VBA
0 vote145 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote137 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote141 views1 answer
Change "location" of binding navigator vb
VBA
0 vote149 views1 answer
Switch pictures with buttons vb.net
VBA
4 votes142 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote135 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote95 views1 answer
Excel autofilter vba
VBA