If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding alpha numeric (auto numbering) field to Access database
Is it possible to add an alpha-numberic 8 digit (autonumbering) field to
Access 2007? |
#2
|
|||
|
|||
Adding alpha numeric (auto numbering) field to Access database
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/f...ts.asp?TID=395 Increment Alpha Field.mdb http://www.rogersaccesslibrary.com/f...sts.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/...UBED1=ACCESS-L "babs" wrote in message ... Is it possible to add an alpha-numberic 8 digit (autonumbering) field to Access 2007? |
Thread Tools | |
Display Modes | |
|
|