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!

  • 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

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;")
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top