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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table Definitions & Auto Numbers

Status
Not open for further replies.
ThomMenzies

ThomMenzies

MIS
Aug 9, 2001
23
0
0
GB
2 queries really.

I have the following simple code to produce a table in code with a unique primary key:

Set tdf = DB.CreateTableDef(strTempSR)
Set fld = tdf.CreateField("ID", dbInteger, 3)
tdf.Fields.Append fld
DB.Execute "CREATE UNIQUE INDEX PrimaryKey ON " & strTempSR & " (ID)"

What I want to do is create another field as an autonumber, and then sort the table by the autonumber but I'm not sure how to do it.

Any help is greatly appreciated.

Thom.
 
Status
Not open for further replies.

Similar threads

OCM
  • Question
Populate access table from excel
Replies
6
Views
234
OCM
OCM
Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
54
Andrzejek
Andrzejek
clevercat88
  • Locked
  • Question
Field in table will not filter - info update
Replies
0
Views
48
clevercat88
clevercat88
PrimoSteve
  • Locked
  • Question
You must use the dbSeeChanges opion with OpenRecordset when accessing a SQL Server table
Replies
9
Views
118
Andrzejek
Andrzejek
meagain
  • Locked
  • Question
Negative numbers to Bracketed text 1
Replies
2
Views
52
meagain
meagain

Part and Inventory Search

Sponsor

Back
Top