|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 27th, 2005, 07:49 PM
|
|||
|
|||
Set Autonumber to a specific number
How can I set an autonumber to start at 500, rather than with 1?
Thanks! -- Vandy 
|
|
#2
February 27th, 2005, 08:18 PM
|
|||
|
|||
|
See this article at The ACCESS Web:
http://www.mvps.org/access/tables/tbl0005.htm -- Ken Snell MS ACCESS MVP "Vandy" wrote in message ... How can I set an autonumber to start at 500, rather than with 1? Thanks! -- Vandy
|
|
#3
February 27th, 2005, 08:39 PM
|
|||
|
|||
|
Thanks! Worked perfectly!
"Vandy" wrote: How can I set an autonumber to start at 500, rather than with 1? Thanks! -- Vandy
|
|
#4
February 28th, 2005, 09:54 AM
|
|||
|
|||
|
Ken Snell [MVP] wrote: How can I set an autonumber to start at 500, rather than with 1? See this article at The ACCESS Web: http://www.mvps.org/access/tables/tbl0005.htm What the MVPs don't tell you is that you can create such a column directly e.g. CurrentProject.Connection.Execute _ "CREATE TABLE MyTable (" & _ " ID INTEGER IDENTITY(500,1) PRIMARY KEY," & _ " data_col VARCHAR(255));" Jamie. --
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how do I find an average number of specific words in a column | cashgrfx | New Users | 7 | January 6th, 2005 04:44 PM |
| GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
| Write a formula that can look up and match a specific number and return the results for that specific number | Frank Kabel | Worksheet Functions | 4 | March 18th, 2004 05:26 PM |
Linear Mode
