Add autonumber after entering records (1 Viewer)

S

scubadiver007

Registered User.

Local time

Yesterday, 21:34

Joined

Nov 30, 2010

Messages

317

• Aug 20, 2013

• #1

A slight flaw in the design requires this change. What is the best way to do it?

 

M

Mihail

Registered User.

Local time

Today, 07:34

Joined

Jan 22, 2011

Messages

2,373

• Aug 20, 2013

• #2

Create a new field, name it and select AutoNumber from the drop down list for data type.

 

S

scubadiver007

Registered User.

Local time

Yesterday, 21:34

Joined

Nov 30, 2010

Messages

317

• Aug 20, 2013

• #3

But what about records already entered? They won't populate will they?

EDIT: Oh, they do. I didn't realise.

 

M

Mihail

Registered User.

Local time

Today, 07:34

Joined

Jan 22, 2011

Messages

2,373

• Aug 20, 2013

• #4

scubadiver007 said:

But what about records already entered? They won't populate will they?

Click to expand...

3 minutes to ask but only 2 to try.

 

B

Bradd

New member

Local time

Yesterday, 21:34

Joined

Feb 19, 2014

Messages

6

• Feb 24, 2014

• #5

How to have autonumber start at 1000 instead of 1?

How to have your record autonumbered starting 1000? Thanks

 

B

Bradd

New member

Local time

Yesterday, 21:34

Joined

Feb 19, 2014

Messages

6

• Feb 24, 2014

• #6

Dear AccessBlaster,
I don't have an old table to start with, we have some records that need to continue the ID number from the past. How do I do. Also don't know how to create a append query. Please help!!!

 

gemma-the-husky

Super Moderator

Staff member

Local time

Today, 05:34

Joined

Sep 12, 2006

Messages

15,632

• Feb 24, 2014

• #7

but you do not want to try and use an autonumber like that. there is no guarantee of an intact sequence with an autonumber. if you need an intact sequence then you need a different approach.

 

Brianwarnock

Retired

Local time

Today, 05:34

Joined

Jun 2, 2003

Messages

12,701

• Feb 24, 2014

• #8

AccessBlaster said:

Hi Bradd,
My answer was for the orginal poster scubadiver007.

Click to expand...

Did you not notice that his question had been answered on the 20th of August last year?

Brian

 

M

Mihail

Registered User.

Local time

Today, 07:34

Joined

Jan 22, 2011

Messages

2,373

• Feb 26, 2014

• #9

Re: How to have autonumber start at 1000 instead of 1?

Bradd said:

How to have your record autonumbered starting 1000? Thanks

Click to expand...

Create a table with a field set to Autonumber.
Fill 999 records then... remove (delete) this records.
Now, your Autonumber will start from 1000.


Fortunately... Gemma is right: this is NOT necessary in a good DB.