title: how to use VB code to insert into an Microsoft Access database
body: <p>I am very new to Microsoft Access. I need to write VB code to do a database insert on a button event click. The insert should take info from the form that the button is on.
  I know that you can get form info with this:</p>
  
  <pre><code>Form![tablename]![columnname]
  </code></pre>
  
  <p>but how would I take that info to insert into a different table? I saw this post <a href="https://stackoverflow.com/questions/6353015/how-to-insert-data-into-a-microsoft-access-database">How to insert data into a Microsoft Access Database?</a> but I think its only with .NET because I can't find the OleDbConnection object listed on the Access reference page <a href="http://msdn.microsoft.com/en-us/library/office/aa296940(v=office.11).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/office/aa296940(v=office.11).aspx</a></p>