Ms Access.... Custom Autonumber Format

Hi all.......I'M Using Ms Access to develope a db...which I want to set an autonumber format like this "FAMAOR-YY-XXXXX"....The YY = Year and the xxxxx = autonumber...and the example of generate autonumber should be like this "FAMAOR0200001".....can anybody
tell me how to do this

We'll I'd say you'd want to use the regular autonumber for one of the fields in the table. Then after you've added the record, grab the autonumber generated and format it into your index string with the year and leading zeros, which you would then update your record with using the autonumber as the identifying key.

Basically 2 steps needed, at least for Access anyway.

Hello Catalyst......Thanx for reply but can tell a little bit more on how to do this coz I'm kindda new in this whole db thing and I aslo don't have a clue how to do the string at all......may god bless you for your help

What language are you using with Access?

I can only presume VBA

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

I'm using Vba.....but the problem is also not very good in programming

Here's sample code for doing this in vba:
http://www.experts-exchange.com/Data...2.html#7747320

You might need to signup for a free membership to view the code.
If you have questions about the sample code just ask.

Hi guys, still need help here

so for example I have a wheel table...
wheelID(pk), wheelName, wheelSize, etc.

the other table is the autoIncrement which consist of two fields: perfix (pk, text) and increment(autonumber)

the format for wheelID is W"wheelsize"-"0001" and so on
for example W17-00001, W17-00002, W18-00010, W19-00001

the problem here, I dont get what the codes are doing :mad:

---- code start --------
Dim wheelID As String
Dim db As Database "when I run the program, theres an error here - user defined type not defined"
Dim autoNumber As Recordses

wheelID = "V" & *i dont know how to get wheelSize* & "-" (will this go to table Whell.wheelID?)

Set db = CurrentDb()
Set autoNumber = db.OpenRecordset("increment")

autoNumber.MoveFirst

autoNumber.Edit
autoNumber!increment = autoIncrement!increment + 1
autoNumber.Update

wheelID = wheelID & Format(autoNumber!increment, "00000") *is this the way to get the increment value from table autoIncrement?*

autoNumber.Close

----- code end ----------

this coding doesnt seem to work.
in vba coding part, where do I put this coding? on form load event ? or on form current event?

Thanks in advance guys

i've got it working now

Good job