title: How do I get the auto number after an INSERT in Ms Access?
body: <p>I have the following query in VBA:</p>
  
  <pre><code>DoCmd.RunSQL "INSERT INTO table (value) VALUES ('example')"
  </code></pre>
  
  <p>( with an auto incremented primary key called <code>id</code>)</p>
  
  <p>How can I get the auto incremented id generated by this insert?</p>