/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 vote227 views1 answer
Vbnet check if string is only numbers
VBA
-1 vote207 views2 answers
How close excel through visual basic
VBA
1 vote232 views2 answers
Get all column names from excel vba
VBA
5 votes224 views1 answer
Excel vba right word from Long Integer
VBA
31 votes291 views1 answer
Excel vba function to convert column number to letter
VBA
1 vote231 views1 answer
Excel vba array remove first
VBA
0 vote238 views1 answer
Group controls programmatically vb
VBA
0 vote235 views1 answer
Vba file chooser
VBA
0 vote248 views1 answer
How to enter Vbox manage commands
VBA
1 vote217 views1 answer
Vba declare api 64 bit 32 bit
VBA