AutoNumber 1

[Esoteric]

Is there a simple way to get the number of the record that was just added or is being added to the database.

Example:
-------------
I add a Job to the database via a form but I want to get the Job Number after its added. Seeing that the job number is an AutoNumber field how do I get it?

anyhelp is appreciated.

 

[JoeMiller]

You can show the AutoNumber field on your form so that the number is displayed when the user starts typing. Does this answer the question?
Joe Miller
joe.miller@flotech.net

 

[Cagliostro]

you can execute
(select count(*) from tableWhereYouWantToAppent) as x John Fill

ivfmd@mail.md

 

[Cagliostro]

or you can put as a source for a control the query John Fill

ivfmd@mail.md

 

[Esoteric]

not exactly. First I am using ASP and there are many people entering jobs at different times so I cannot show the Number before the entry.

Secondly, the job numbers may not be sequential as data is purged from the system to the recordcount ideal will not work either.

What I want to know is this:
rs.AddNew <- When Adding a new record
JID = rs(&quot;JID&quot <- I tried this but there is not JID because the record has not been submitted yet.

Based on what I just said there is no easy way. Because its not submitted. Is there a way to RESERVE a record?

 

[tlbroadbent]

Check out this article.

INFO: Jet OLE DB Provider Version 4.0 Supports SELECT @@Identity

http://support.microsoft.com/support/kb/articles/Q232/1/44.ASP

Terry Broadbent
Please review faq183-874.

&quot;The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge.&quot; - Daniel J Boorstin