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!

autonumber? how?

Status
Not open for further replies.
haytatreides

haytatreides

IS-IT--Management
Oct 14, 2003
94
US
does anyone know a way to make an int field an autonumb field with code or anything? anyway that works i am happy with!

hayt
 
Sort by date Sort by votes
Hi,

Go into to design mode on the table, select the field you want to make autonumber, as it is already an integer all you need to do is set the identity property to yes.

Hope this is what you wanted
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

toptech
  • Locked
  • Question
How do I pass form field into criteria of stored procedure
Replies
2
Views
181
toptech
toptech
neronikita
  • Locked
  • Question
Not sure how to search in Access 2010
Replies
1
Views
45
PWise
PWise
batteam
  • Locked
  • Question
How to find Access Version No.
Replies
4
Views
37
batteam
batteam
mnwuzor
  • Locked
  • Helpful tip
"HELP", I need your assistance on how to share MS Access projeect
Replies
2
Views
31
embryo
embryo
BSman
  • Locked
  • Question
How do you create an Access 2007 project?
Replies
4
Views
53
Darrylles
Darrylles

Part and Inventory Search

Sponsor

Back
Top