1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
| '-Effacement Table TmpPlanning
On Error Resume Next
DoCmd.DeleteObject acTable, "TmpPlanning"
On Error GoTo 0
CurrentDb.TableDefs.Refresh
'--Création Nouvelle Table Planning
Dim oDb As DAO.Database
Dim tbl As DAO.TableDef
Set oDb = CurrentDb()
oDb.Execute "CREATE TABLE TmpPlanning"
oDb.TableDefs.Refresh
Set tdf = oDb.TableDefs("TmpPlanning")
'---Création des champs fixes---
Set fld = tdf.CreateField("NumAffaire", dbText, 50)
tdf.Fields.Append fld
Set fld = tdf.CreateField("Client", dbText, 50)
tdf.Fields.Append fld
Set fld = tdf.CreateField("LibAffaire", dbText, 255)
tdf.Fields.Append fld
'Types DbText DbLong DbMemo DbDouble DbDate ....
'---Création des Champs Variables (Dates)----------
For JJ = Me!DateDébut To Me!DateFin
Set fld = tdf.CreateField(CStr(JJ), dbText, 255)
tdf.Fields.Append fld
Set P = oDb.CreateProperty("ColumnWidth", dbInteger, 1800)
tdf.Fields(CStr(JJ)).Properties.Append P
Next JJ
'Libère les variables
Set tdf = Nothing
Set oIndex = Nothing
Set oChamp = Nothing
Set oNouvelleTable = Nothing
CurrentDb.TableDefs.Refresh
oDb.Execute "CREATE INDEX NumAff ON TmpPlanning (NumAffaire);" |
Partager