autonumber question ?

[luanhoxung]

hi all!
i want to create group text for showing my invoice number.
the invoice no. is created by 3 parts.
1st part: autonumber increasing at each new record.
2nd part: 2 characters of current month.
3rd part: 1 character of current year.
Ex: 001-016 --invoice 001 of Jan 2006.
i created 3 unbound control to make 3 parts.
and 1 bound control(inv no.) will be get value from 3 unbound control.
i don't know how can i execute in defaul value of 3 unbound control.
i used: right(year(date()),1) in 3rd unbound control --ok, it works
fine.
but in 2nd one, i used: month(date()) and format property: @@ . it dont
work. ex: Feb --2 but i want it is 02.
And the autonumber --Pls help.

Any ideas or others to get the best result ?
Thanks with appreciated.
Luan from VietNam

[kingston via AccessMonster.com]

Try this:

InvoiceNum = [AutoID] & "-" & right("0" & month(date()), 2) & right(year(date
()),1)

luanhoxung wrote:

>hi all!
i want to create group text for showing my invoice number.
the invoice no. is created by 3 parts.
1st part: autonumber increasing at each new record.
2nd part: 2 characters of current month.
3rd part: 1 character of current year.
Ex: 001-016 --invoice 001 of Jan 2006.
i created 3 unbound control to make 3 parts.
and 1 bound control(inv no.) will be get value from 3 unbound control.
i don't know how can i execute in defaul value of 3 unbound control.
i used: right(year(date()),1) in 3rd unbound control --ok, it works
fine.
but in 2nd one, i used: month(date()) and format property: @@ . it dont
work. ex: Feb --2 but i want it is 02.
And the autonumber --Pls help.

Any ideas or others to get the best result ?
Thanks with appreciated.
Luan from VietNam

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1

[Ron2006]

and also:
InvoiceNum = [AutoID] & "-" & format(month(date()),"00") &
right(year(date

()),1)

So how will you tell the difference between an invoice number in the
year 2006 and year 2016.

remember you will not be able to easily use the invoice number to
separate records by year and month expecially after 10 years of
operation.

Ron.

[luanhoxung]

great !
Thanks both of u.
perfective thinking.
i will revise it.
Luan from VietNam

[Ron2006]

If you are thinking of using part of the invoice number as a means of
grouping invoices, you should probably put the year IN FRONT of the
month.

For invoices I have created for our farm I have the invoice number as
follows

yyyymmdd-sssss

for your example it would be

yyyymmdd-[autonumber]

This lets you sequence them easily even when using the invoice number.

Also you avoid the problem of the months for multiple years showing up
together instead of seeing all the months for a single year and then
the next group of months for the next year.

Ron

[luanhoxung]

thanks.
but how can i create a autonumber?
[autoid]or[autonumber] is not effective.
Pls teach how to do this ?
i couldnot find any post abt this.
thanks

[Larry Linson]

"luanhoxung" <lu********@yahoo.comwrote

but how can i create a autonumber?
[autoid]or[autonumber] is not effective.
Pls teach how to do this ?
i couldnot find any post abt this.

You don't "create" it; you define a Field in your Table with the AutoNumber
data type.

How were you searching? Searching on "AutoNumber" using Advanced Group
Search at http://groups.google.com found the following numbers of matches:

For USENET newsgroup comp.databases.ms-access: 14,600
For sponsored newsgroup microsoft.public.access: 5,420

Larry Linson
Microsoft Access MVP

[luanhoxung]

Hi Larry .
Create autonumber by field in table, i think it is basic knowlegde.
Basically i need create autonumber in VBA and combine some texts to
make a new value for my control. I am not aware of VBA.
So hope get more help.
Thanks.
Luan.
Larry Linson wrote:

"luanhoxung" <lu********@yahoo.comwrote

but how can i create a autonumber?
[autoid]or[autonumber] is not effective.
Pls teach how to do this ?
i couldnot find any post abt this.

You don't "create" it; you define a Field in your Table with the AutoNumber
data type.

How were you searching? Searching on "AutoNumber" using Advanced Group
Search at http://groups.google.com found the following numbers of matches:

For USENET newsgroup comp.databases.ms-access: 14,600
For sponsored newsgroup microsoft.public.access: 5,420

Larry Linson
Microsoft Access MVP

[luanhoxung]

Anyone tell me what happen with our page:
http://www.talkaboutdatabases.com/gr...ses.ms-access/
I cannot enter.
Luan from Vietnam