Autonumber in MS Access... - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 3 (permalink) Old 04-12-2006, 12:43 AM Thread Starter
Lifer
 
DoesSpeedTurnUon's Avatar
 
Join Date: Feb 2004
Location: Bedford, TX
Posts: 2,189
Autonumber in MS Access...

Does anyone know how to change it from like "+1" to something else? I want the auto number to auto it with a client code or ID, like...

WD10001
WD10002
WD10003
WD10004

Instead of:
1
2
3
4
5

anyone know?

2007 GMC Sierra RCSB - It breathes better now and looks better than stock.
2008 Honda 700XX - Doesn't need any mods.
DoesSpeedTurnUon is offline  
Sponsored Links
Advertisement
 
post #2 of 3 (permalink) Old 04-12-2006, 11:58 AM
El Camino
 
Stang2be's Avatar
 
Join Date: Sep 2003
Location: in front of the keyboard
Posts: 3,432
See if this does the trick for ya

http://www.databasedev.co.uk/add_prefix.html

2007 Taurus SEL - daily driver
1974 El Camino SS - 400sb

Quote:
Originally Posted by purrrfectstang
Umm.. what is the ID-10T settings?
Stang2be is offline  
post #3 of 3 (permalink) Old 04-12-2006, 01:09 PM Thread Starter
Lifer
 
DoesSpeedTurnUon's Avatar
 
Join Date: Feb 2004
Location: Bedford, TX
Posts: 2,189
Quote:
Originally Posted by Stang2be
See if this does the trick for ya

http://www.databasedev.co.uk/add_prefix.html

EXCELLANT!!! but i think i might be going a differnt way now, with a relationship to another table... not sure yet. but its getting deep!

2007 GMC Sierra RCSB - It breathes better now and looks better than stock.
2008 Honda 700XX - Doesn't need any mods.
DoesSpeedTurnUon is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may 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 On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome