ID issues

[aadil7]

hi all
well at the moment i am very happy with my database. the ID i think though is going to be a big issue!
at the moment it is set as a auto number so every record would get assigned a unique ID
in my form that number has been concatenated with ABA/23 to form e.g: ABA/23455, ABA/23018
where im thinking an issue would arise is when the records reach 1000 and above
is there actually a way so that when it hits 1000 the concatenation would change to ABA/24 there fore making the 1000th record ABA/24000 in the form?

thanks in advance
kind regards

 

[JamesMcS]

I think you can tell Access to start autonumbering from a certain number. If you make it start from 23000, job's a goodun.

 

[JamesMcS]

Or, more accurately, make it start from 3000 and just concatenate "AB/2"

 

[JamesMcS]

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209696

 

[aadil7]

youve done it again
thanks

 

[JamesMcS]

Happy to help old son. Enjoy the weekend!