Question Locked

auto numbering

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
i want to autonumber a form every time the form is opened, but i want to have custom number i.e. 300000 how do i do this?

7 replies

by bizzo

What are you using to create the forms?

by tony hopkinson

there are two properties
one is start value the other increment

They default to 1 and 1, change, em and you are off.

by yaeerb

i looked for this option, but can't find it.

thanx

by tony hopkinson

the table designer, pick a column and the properties tab appeared bottom left

by yaeerb

there no line that gives you the option to start your own increment.

there must be another way in access 2007.

thanx

by tony hopkinson

SQL stuff.

CREATE TABLE mytable
(
id_num int IDENTITY(300000,3)
)

for instance.

If you script out your current table, it should have IDENTITY(1,1) against the autonumber, twiddle with it then execute (after deleing / renaming the existing one.

I hate access!

This is MS's recomendation or twiddling with autonumbers

http://support.microsoft.com/kb/812718

This discussion is closed to new replies.