serial number in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get Access to generate and display a unique number for each new
record I enter?
 
Hi:

Access has a field type called AutoNumber which automatically increments
count by 1.

However AutoNumber will not always give the next number - for example you
start adding a new record and deicde to cancel - the AutoNumber used in that
record will be lost. For example you have 2 records are adding record 3 -
the AutoNumber will be 3 - however if you do not save the record and cancel
out the Autonumber 3 will be lost and you will get 4 next.

If you need a better approach then you should think of VBA code to assign a
unqiue number when you save the record.

Regards,

Naresh Nichani
Microsoft Access MVP
 
Instead you use this

When inserting a new record, find the maximum of Id and add 1 to it and
save the record

Madhivanan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Macro Repeat Expression using value of a field in table 0
Auto Number with Letter Prefix 5
Number Fields in Access 2007 Database 1
Concatenate Date and Number field for Append Query 0
Auto Number Fill 3
merging 2 tables 1
Form/ filter for report 2
Auto Generate Primary Field Value 5

Back
Top