1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Sub createTable()
Dim oDb As DAO.Database: Set oDb = CurrentDb
Dim tblClients As DAO.TableDef: Set tbl = oDb.CreateTableDef("tblClients")
Dim fNum As DAO.Field, fName As DAO.Field
Dim PKUsers As DAO.Index
With tblClients
'===============================Your auto-incremented field===============================
Set fNum = .CreateField("Num", dbLong): .Attributes = dbAutoIncrField: .Fields.Append fNum
'==========================================================================================
Set fName = .CreateField("Name", dbText, 15): .Fields.Append fName
Set PKUsers = .CreateIndex("PKUsers")
With PKUsers
.Primary = True
.Unique = True
.Fields.Append .CreateField("Num")
End With
.Indexes.Append PKUsers
End With
oDb.TableDefs.Append tblLogs
End Sub |
Partager