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

adding alpha numeric autonumber field to Access 1
Input Mask 1
How do I create Alpha-Numeric Numbering in Word 07? IE: Word_1.0 1
Merge an alpha field and a numeric field 3
alpha AND numeric, best way to set up 2
remove letters from an alpha-numeric field 3
Importing Alpha-Numeric value into Access 3
Access auto numbers 3

Top