Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to preset an AUTONUMBER from 1 to 100? 2

Status
Not open for further replies.
broodis

broodis

Technical User
Jan 21, 2005
23
AU
Hi,

Just want to find out how to create an autonumber field from 1 to 100. Any ideas??
 
Sort by date Sort by votes
Any autonumber starting at 1 will go to 100. That's the unique selling point. Start it at 1 by creating a new table.

 
Upvote 0 Downvote
Mike, I think broodis wants the Autonumber to start from 100 or 101.
It is a never ending debate in these forums...
see these FAQs
can I make a dynamic autonumber?
Why AutoNumber shouldn't be used in MultiUser databases
How can I auto-prefix my autonumber field?
Why do I get duplicate Autonumbers after upgrading to Access 2000
Make an intelligent autonumber field?
What can I use besides AutoNumber
Also have an Advanced Search with KeyWord AutoNumber
Hope this helps

Zameer Abdulla
Visit Me
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
477
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
531
TheresAlwaysAWay
TheresAlwaysAWay
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
343
renigar
renigar
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
569
OCM
OCM
atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
230
atadbitslow
atadbitslow

Part and Inventory Search

Sponsor

Back
Top