Custom AutoNumber

[spcscooter via AccessMonster.com]

Is there any way to change the AutoNumber sequence? I have a tracking number
that I want to be able to have start with AUBREP001 and then continue in
sequence without the AUBREP changing.

Thank you

 

[Bill]

Scot,
One of the Access MVP's might have a better
solution, but you can always concatenate the
text string "AUBREP" with the last several
digits of the AutoNumber. If that works for
you, you can accomplish the concatenation
in the underlying RecordSource query. Or,
if it better serves your purpose, you can
maintain a separate field that is derived from
the two sources.

E.g., strMyTrkNo = "AUBREP" & Right(RecID, 4)

Bill

 

[spcscooter via AccessMonster.com]

Thank you very much Bill. You really saved my toosh.

 

[Bill]

Scot,
A better thought is to simply have a text box
bound to the record ID and format the text
box prefixed with whatever text you want.
That way you don't have your DB cluttered
with redundent information, which is always
a good thing to avoid.
Bill

 

[Bill]

You're welcome. Always glad to help.
Bill

Thank you very much Bill. You really saved my toosh.


--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA