Adding alpha numeric (auto numbering) field to Access database

R

Roger Carlson

You would have to program one yourself. The Autonumber datatype is a Long
Integer only and you have no control over its value. Here are a couple of
samples that illustrate how to do it yourself:

AutonumberProblem.mdb
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=395

Increment Alpha Field.mdb
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=21

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
adding alpha numeric autonumber field to Access 1
Delete all data after a symbol in a field 0
testing for numeric or alpha 2
Finding the proper style field and the numbered paragraph value within the style 0
alpha AND numeric, best way to set up 2
Access auto numbers 3
Alpha to Numeral column name 3

Top