I'm sure this is possible, just cant remember how!!

[Paul Malbon]

Hi All,

I want to change the autonumber so that it starts at 11111 insted of 0. I've
done it before in Access 97 many years back, just cant remeber how. I'm not
an Access professional, just know my way about a bit!

Thanks in advance

Paul

 

[Allen Browne]

See:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html

 

[Joseph Meehan]

Hi All,

I want to change the autonumber so that it starts at 11111 insted of
0. I've done it before in Access 97 many years back, just cant
remeber how. I'm not an Access professional, just know my way about a
bit!
Thanks in advance

Paul

Are you sure you want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.

In any case Allen has provide the instructions to do what you asked.

 

[Mick Ruthven]

Allen, I went to your great site of tips and decided to use your "Display
system and version information". It works fine except that the code for Data
File:,
=Mid([DBEngine].[Workspaces](0).[Databases](0).[TableDefs]("MyAttachedTable"
).[Connect],11), produces an "#Error" when displayed. I'm running Access
2002.

What might I be missing?

Thanks,

Mick Ruthven

 

[Mick Ruthven]

Oops! I looked right over the "MyAttachedTable" part. It works fine, and
thanks so much.

Allen, I went to your great site of tips and decided to use your "Display
system and version information". It works fine except that the code for Data

File:,

=Mid([DBEngine].[Workspaces](0).[Databases](0).[TableDefs]("MyAttachedTable"
).[Connect],11), produces an "#Error" when displayed. I'm running Access
2002.

What might I be missing?

Thanks,

Mick Ruthven

Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

 

[Paul Malbon]

Ahhhh, yep, thats it!! Thanks very much indeed Allen!!

Paul