Application Center Usage - AutoNumber Feature in MS Access

Author

AutoNumber Feature in MS Access

ExcelNoviceInIL

2005-11-02, 5:50 pm

In Access there is an autonumber feature that will pull up the next sequenced
number for use in a database. What I am trying to do is get Access to pullup
a sequenced number that is Alphanumeric. I am creating invoices and need the
system to pull up a new alphanumeric number to crate an individual invoice
with no duplication of number. Is this possible in Access or does it only do
AutoNumber with just numbers?

Would appreciate any help possible.

Thank you.

Richard Ault

2005-11-21, 5:51 pm

You might have better luck in the Excel newsgroups.

Richard Ault
Application Center Product Team

This posting is provided "AS IS" with no warranties, and confers no rights. Use of any included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm

-----Original Message-----
From: ExcelNoviceInIL@discussions.microsoft.com
Posted At: Wednesday, November 02, 2005 14:36
Posted To: microsoft.public.applicationcenter.usage
Conversation: AutoNumber Feature in MS Access
Subject: AutoNumber Feature in MS Access

In Access there is an autonumber feature that will pull up the next sequenced number for use in a database. What I am trying to do is get Access to pullup a sequenced number that is Alphanumeric. I am creating invoices and need the system to pull up a n
ew alphanumeric number to crate an individual invoice with no duplication of number. Is this possible in Access or does it only do AutoNumber with just numbers?

Would appreciate any help possible.

Thank you.