This is a discussion on "change auto number in access 2003" within the Databases section. This forum, and the thread "change auto number in access 2003 are both part of the Program Your Website category.
|
|
|
|
|
![]() |
||
change auto number in access 2003
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
|||
|
change auto number in access 2003
I am developing an asp reservation system.
Each user booking will be kept in a database which will have a unique booking ID! currently i am using auto number as the booking ID,(increment number) how to make my own "booking ID" inside the database access? let say i want my booking ID looks like this... FRS0001 until FRS9999 can anybody suggest another way if this cannot be done? thanx!
Last Blog Entry: ASP Programming Tips and Technique (Oct 26th, 2007)
|
|
|
|
|||
|
Start by manually creating a booking ID (type it into the database), then write some code which will get the booking id, add 1 to it, then use that for the new booking id.
|
|
|||
|
what do you mean by add 1 to it?
i dont understand smokie? ok..in access theres a autonumber usually used for ID, it is an autonumber, Can i change this autonumber to...maybe, autonumber with alphabethic inside it generated randomly? for example 76DC54, 70H23K, BSS92P....can microsoft access do that?
Last Blog Entry: ASP Programming Tips and Technique (Oct 26th, 2007)
|
|
|||
|
Leave the auto number field alone and just create a new field (text) for your booking ID. Then just use ASP to create a custom function which creates the booking id in the format you want.
|
|
|||
|
i get the idea but,
i am new with asp programming!
Last Blog Entry: ASP Programming Tips and Technique (Oct 26th, 2007)
|
|
|||
|
ok, then proceed to my first reply.
|
|
|||
|
smokie...refering to your first reply,
can you show me the sample coding for that? ok...first i create a booking ID and type the first value to the database manually e.g: FRS0001 then i should create an asp coding to add 1 to the FRS0001 to become FRS0002 for the next ID,is it right? so, can you teach me how
Last Blog Entry: ASP Programming Tips and Technique (Oct 26th, 2007)
|
![]() |
| Tags |
| change, auto, number, access, 2003 |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Frontpage 2003 | snake | Starting Out | 4 | Apr 21st, 2008 17:35 |
| Exchange 2003 Specialist | Web JobBot | Job Opportunities | 0 | Feb 27th, 2007 16:01 |
| front page 2003 and psd files | faygirl | Scripts and Online Services | 4 | Nov 20th, 2006 14:31 |
| Show a Number from Access in the webpage | redkyna | Databases | 3 | Aug 25th, 2004 15:59 |
| Format Auto Number in MS Access 2000 | dretzka | Databases | 2 | Aug 10th, 2004 13:37 |