<div>
How multi user is your database gonna be<br />
<br />
if u use a recordset to add (one I prefer to use if u have several fields to add) then once u do AddNew, u get the UID number (if its a autonumber)<br />

</div>


How multi user is your database gonna be

if u use a recordset to add (one I prefer to use if u have several fields to add) then once u do AddNew, u get the UID number (if its a autonumber)


<div>
There will be one whole user of this amazingly big database (excuse the sarcasm :P )<br />
<br />
So I can presume Dmax() will be safe?
</div>


There will be one whole user of this amazingly big database (excuse the sarcasm :P )

So I can presume Dmax() will be safe?

<div>
Yes. &nbsp;If you wanted to expand, you'd need to do something else.
</div>


Yes.  If you wanted to expand, you'd need to do something else.

<div>
<div class="content wysiwyg-content">
Hi guys,<br />
<br />
I wanted to know if it's possible to run an Insert statement on a table, and then determine what the UID (also the primary key) of that entry is?<br />
<br />
Cheers guys!
</div>
</div>


Hi guys,

I wanted to know if it's possible to run an Insert statement on a table, and then determine what the UID (also the primary key) of that entry is?

Cheers guys!

VBA - Determine last Inserted UID

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.