Custom autonumbers 1

[balllian]

is it possible to create or customise my own autonumber so that it comes out in the following format.

ASM0001
ASM0002

etc

I presume i would need to code this?? Has anyone done this before and can assist me with this.

 

[SuicidED]

Hi

Put "ASM"0000 in the format box of your table with autonumber on.

Regards Eddie

 

[balllian]

Thanks for this. i've put in what u have said but it doesnt increment. it keeps appearing as ASM0000 for each record.

 

[ZmrAbdulla]

AUTONUMBER FAQs
[ul]
[li] Use of Autonumber faq702-5106 [/li]
[li] How can I auto-prefix my autonumber field? faq181-1725 [/li]
[li] Create a Autonumber with a Suffix faq181-1179[/li]
[li] How to autonumber date values in a control. faq181-1129 [/li]
[li] What can I use besides AutoNumber faq181-1023 [/li]
[li] Make an intelligent autonumber field? faq181-159 [/li]
[li] can I make a dynamic autonumber? faq181-158 [/li]
[/ul]


Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[balllian]

thanks for the links.

in one of my other fields i have set the default vaue to date(). Would this then stop a unique number being generated?

 

[balllian]

i have delated the existing autonumber and reset a new one up and this now works with the numbers increments

many thanks for pointing me in the right direction.

 

[ZmrAbdulla]

That won't affected anyway.
Your AutoNumber field to be set like below
[ul]
[li] DataType = AutoNumber [/li]
[li] NewValues = Increment [/li]
[li] Format = "ASM"00000 [/li]
[li] FieldSize = Long Integer [/li]
[li] enter item5 [/li]
[/ul]
I don't know what will happen after ASM99999

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[ZmrAbdulla]

Please avoid this typing mistake
[ul]
[li] enter item5 [/li]
[/ul]


Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me