Re: Self-generating Number

Tech-Archive recommends: Fix windows errors by optimizing your registry

the only way i can think of is using a form

and for the field that is that value you would use this setup

serialvaluetextbox.Value = Format(Date, "yy") & "-" &
Format(CInt(Right(DLast("[serialvalue]", "serialvaluetable"), 4) + 1),
"0000")

the people in the formscoding group may be able to help you implement
the above

i dont know how to set the autonumber format property to fo the above
someone else may know but as far as i know you cannot combine
datatypes ie date and int

hope this helps

Regards
Kelvan
.

Relevant Pages