Hi All,

I have an Access database with an AutoNumber field. Now instead of having the number starts off with 1, can I have the format to be something like: B03-001, B03-002, B03-003, and so on.

I have been looking all over the place to do something like this, but so far no luck. What I am working on is an ASP page where I input a customer purchase information. Each time I enter a new customer, the database will automatically (AutoNumber) that particular record. Now the catch is, I want that AutoNumber to start with what I want it to be, instead of 1 and increment. Please Help! If this is not the right place to ask such question, please refer me to an appropriate site. Greatly Appreciated!!! Thank you!!!

Leon

Hi Leon,
In the table design view set the format of AutoNumber field as
B03-000.

Bye.


Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team

Thank you very much for you help. Wow, that was easy. I have another question and was wondering if you could please help me; it is related to the AutoNumber field as well.

I created an ASP page to UPDATE a record. Please see the Update string below. The problem is, when I click on the update button, instead of updating that record I have set on, it creates a brand new record in the database. Please note, the "referencenumber" is the autonumber field. What am I doing wrong? Thanks again.


SQLstmt = "UPDATE classificationmain SET "
SQLstmt = SQLstmt & "lastname='" & lastname& "',"
SQLstmt = SQLstmt & "incumbentname='" & incumbent & "'"
SQLStmt = SQLStmt & " where referencenumber= " & referencenumber & ""