change auto number in access 2003

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.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices




Closed Thread
 
LinkBack Thread Tools
  #1  
Old Aug 16th, 2004, 04:27
Most Reputable Member
Join Date: Feb 2004
Location: Borneo
Age: 27
Posts: 1,612
Blog Entries: 2
Thanks: 0
Thanked 4 Times in 3 Posts
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)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!

  #2  
Old Aug 16th, 2004, 08:42
Highly Reputable Member
Join Date: Jul 2003
Location: Ipswich, UK
Posts: 690
Thanks: 0
Thanked 0 Times in 0 Posts
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
  #3  
Old Aug 18th, 2004, 01:44
Most Reputable Member
Join Date: Feb 2004
Location: Borneo
Age: 27
Posts: 1,612
Blog Entries: 2
Thanks: 0
Thanked 4 Times in 3 Posts
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)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
  #4  
Old Aug 18th, 2004, 08:26
Highly Reputable Member
Join Date: Jul 2003
Location: Ipswich, UK
Posts: 690
Thanks: 0
Thanked 0 Times in 0 Posts
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
  #5  
Old Aug 19th, 2004, 03:02
Most Reputable Member
Join Date: Feb 2004
Location: Borneo
Age: 27
Posts: 1,612
Blog Entries: 2
Thanks: 0
Thanked 4 Times in 3 Posts
i get the idea but,
i am new with asp programming!
Last Blog Entry: ASP Programming Tips and Technique (Oct 26th, 2007)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
  #6  
Old Aug 19th, 2004, 08:40
Highly Reputable Member
Join Date: Jul 2003
Location: Ipswich, UK
Posts: 690
Thanks: 0
Thanked 0 Times in 0 Posts
ok, then proceed to my first reply.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
  #7  
Old Aug 25th, 2004, 01:48
Most Reputable Member
Join Date: Feb 2004
Location: Borneo
Age: 27
Posts: 1,612
Blog Entries: 2
Thanks: 0
Thanked 4 Times in 3 Posts
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)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Closed Thread

Tags
change, auto, number, access, 2003

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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


All times are GMT. The time now is 20:19.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved