<div>
There are many ways...<br />
<br />
One is to use a function that simply adds 1 to the highest number<br />
<br />
Function NextNumber() as long<br />
&nbsp; &nbsp; NextNumber=Dmax(&quot;YourIDFie<wbr />ld&quot;,&quot;YourT<wbr />able&quot;)+1<br />
end function.<br />
<br />
This may not be perfect for a multi-user environment...<br />
<br />
So lets see what other experts post... <br />
<br />
JeffCoachman
</div>


There are many ways...

One is to use a function that simply adds 1 to the highest number

Function NextNumber() as long
    NextNumber=Dmax("YourIDField","YourTable")+1
end function.

This may not be perfect for a multi-user environment...

So lets see what other experts post...

JeffCoachman

<div>
Thanks Jeff, but you are correct. &nbsp;This is a multi-user environment and this method may cause problems. &nbsp;Are there other options for doing this?
</div>


Thanks Jeff, but you are correct.  This is a multi-user environment and this method may cause problems.  Are there other options for doing this?

<div>
yes.<br />
<br />
I have a UniqueID field in my SQL table. &nbsp;It is type uniueidentifier and a primary key.
</div>


yes.

I have a UniqueID field in my SQL table.  It is type uniueidentifier and a primary key.

<div>
So are you saying if you add a record in Access, the SQL autonumber is not created?
</div>


So are you saying if you add a record in Access, the SQL autonumber is not created?

Ident.PNG

<div>
Thanks for chiming in mbizup...<br />
As you know SQL is not my strong point...<br />
<br />
;-)<br />
<br />
Jeff
</div>


Thanks for chiming in mbizup...
As you know SQL is not my strong point...

;-)

Jeff

<div>
Thanks for the help on this one.
</div>


<div>
<div class="content wysiwyg-content">
I am creating a Access Form (2007) that will be utilize to update and create new records that are stored in a backend SQL Server 2008 Table. &nbsp;One of my fields in this table is a UniqueID. &nbsp;From SQL, I can use newid() to create this unique value. &nbsp;How can do this in the actual Access Form OR what are my options for this?
</div>
</div>


I am creating a Access Form (2007) that will be utilize to update and create new records that are stored in a backend SQL Server 2008 Table.  One of my fields in this table is a UniqueID.  From SQL, I can use newid() to create this unique value.  How can do this in the actual Access Form OR what are my options for this?

Passing &lt;uniqueidentifier&gt; from MS Access 2007 to SQL Database Table

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.

Microsoft Access

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.

Passing &lt;uniqueidentifier&gt; from MS Access 2007 to SQL Database Table

Passing <uniqueidentifier> from MS Access 2007 to SQL Database Table