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 derfloh 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
Joined
Oct 14, 2003
Messages
94
Location
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 Question
How do I pass form field into criteria of stored procedure
Replies
2
Views
754
toptech
toptech
neronikita
  • Locked
  • Question Question
Not sure how to search in Access 2010
Replies
1
Views
216
PWise
PWise
batteam
  • Locked
  • Question Question
How to find Access Version No.
Replies
4
Views
239
batteam
batteam
mnwuzor
  • Locked
  • Helpful tip Helpful tip
"HELP", I need your assistance on how to share MS Access projeect
Replies
2
Views
175
embryo
embryo
BSman
  • Locked
  • Question Question
How do you create an Access 2007 project?
Replies
4
Views
309
Darrylles
Darrylles

Part and Inventory Search

Sponsor

Back
Top