<div>
If adding by DAO code, the simplest way is to use the bookmark (Or at least that is what I do)<br />

<pre><code id="code-20-41777254-1">Dim rs as Dao.Recordset
Set rs=Currentdb.openrecordset(&quot;SomeTableOrQuery&quot;,dbopendynaset+dbSeeChanges)
rs.addnew
  rs!Field1=1
  rs!Field2=&quot;Santa clause&quot;
rs.AddNew
rs.Bookmark=rs.LastModified
msgbox &quot;Primary key is:&quot; &amp; rs!PrimaryKeyFieldName</code></pre>
</div>


If adding by DAO code, the simplest way is to use the bookmark (Or at least that is what I do)


Dim rs as Dao.Recordset
Set rs=Currentdb.openrecordset("SomeTableOrQuery",dbopendynaset+dbSeeChanges)
rs.addnew
  rs!Field1=1
  rs!Field2="Santa clause"
rs.AddNew
rs.Bookmark=rs.LastModified
msgbox "Primary key is:" & rs!PrimaryKeyFieldName

<div>
Hi <br />
<br />
Thanks i was looking for a code that would wrap two SQL inserts into a transaction .
</div>


Hi

Thanks i was looking for a code that would wrap two SQL inserts into a transaction .

<div>
<div class="content wysiwyg-content">
I am trying to find a search work which describes the scenario of running code but have not been successful <br />
<br />
Scenario : <br />
Insert a new row into a table <br />
Retrieve auto number from above and insert this value from above . <br />
There are no unique record except for time stamp . Do I use some Dbo code that can record the auto number recorded in the first insert by simply using Dbo commands . I am sure I have used it before but have lost my work . <br />
<br />
In addition what syntax would you use to wrap the code so no inserts are partially done and if so it will roll back both inserts . <br />
<br />
Thanks
</div>
</div>


I am trying to find a search work which describes the scenario of running code but have not been successful 

Scenario : 
Insert a new row into a table 
Retrieve auto number from above and insert this value from above . 
There are no unique record except for time stamp . Do I use some Dbo code that can record the auto number recorded in the first insert by simply using Dbo commands . I am sure I have used it before but have lost my work . 

In addition what syntax would you use to wrap the code so no inserts are partially done and if so it will roll back both inserts . 

Thanks

Access Vba find auto number

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.