Hola amigo con gusto contesto tu pregunta es algo sencillo el codigo es el siguiente:
Dim conConnection As New ADODB.Connection
Dim cmdCommand As New ADODB.Command
Dim rstRecordSet As New ADODB.Recordset
conConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & _
App.Path & "\" & "basedatos.accdb;Persist Security Info=False;"
conConnection.CursorLocation = adUseClient
conConnection.Open
With cmdCommand
.ActiveConnection = conConnection
.CommandText = "INSERT INTO tabla (campo1,campo2,campo3,campo4,campo5,campo6,campo7)" & _
"VALUES (" & Form1.Text1.Text & "," & "'" & Trim(Form1.Text15.Text) & Mid(Combo1.Text, 9, 1) & "'" & ",'" & Form1.Label17.Caption & "'," & Form1.Text13.Text & ",'" & Form1.Text12.Text & "','" & Combo1.Text & "','" & Combo2.Text & "');"
.CommandType = adCmdText
End With
With rstRecordSet
.CursorType = adOpenStatic
.CursorLocation = adUseClient
.LockType = adLockOptimistic
.Open cmdCommand
End With
conConnection.Close
Set conConnection = Nothing
Set cmdCommand = Nothing
Set rstRecordSet = Nothing
espero te sirva mucho amigo, Gracias