/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 vote119 views1 answer
Vba remove numbers from string
VBA
0 vote123 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote119 views1 answer
Vba declare 64-bit ptrsafe
VBA
2 votes110 views2 answers
Constructor vb.net
VBA
0 vote137 views1 answer
For each item in folder outlook vba
VBA
3 votes152 views2 answers
Vba date to string
VBA
0 vote130 views1 answer
Pivot data source not accepting table named range vba
VBA
22 votes245 views1 answer
Xlvba check for folder
VBA
0 vote118 views1 answer
Vbscript remove spaces from string
VBA
0 vote125 views1 answer
Remove last 8 characters from string vb
VBA