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!

columns

Status
Not open for further replies.
tjm77

tjm77

Programmer
Joined
Oct 2, 2000
Messages
15
Location
US
I want to create a column, but want to change the properties of it using code to an autonumber format? Any idea on how to do that?? this is what I have so far:


DoCmd.RunSQL ("ALTER TABLE tec_trac ADD COLUMN auto LONG;")
 
Sort by date Sort by votes
For LONG substitute either COUNTER or AUTOINCREMENT. Note: In your statement above, the name given the column is "auto". You probably knew that (since you keyed it in lower case) but I thought I'd mention it just in case you thought it was a keyword. Rick Sprague
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kalyan Ganesan
  • Locked
  • Question Question
Query not inserting both the columns into MS Access tables
Replies
16
Views
849
Andrzejek
Andrzejek
rashokku
  • Locked
  • Question Question
Updating values in a table based on the combination of values in the columns
Replies
2
Views
313
dhookom
dhookom
rashokku
  • Locked
  • Question Question
Selecting data from MS Access table columns based on column location instead of column names
Replies
5
Views
610
combo
combo
Kalyan Ganesan
  • Locked
  • Question Question
Fails to Inserts two columns but no error given
2
Replies
23
Views
754
Kalyan Ganesan
Kalyan Ganesan
weightinwildcat
  • Locked
  • Question Question
Count of columns/fields in a query or table.
Replies
1
Views
268
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top