1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
Sub test()
Dim db As DAO.Database, td As DAO.TableDef, f As DAO.Field, p As DAO.Property
Set db = CurrentDb
Set td = db.TableDefs("table1") ' Table
Set f = td.CreateField("OnOff", dbBoolean) ' Champ à ajouter
td.Fields.Append f
' Propriété Format
Set p = f.CreateProperty("Format", dbText, "Yes/No")
f.Properties.Append p
' Propriété Display Control (106 correspond à case à cocher)
Set p = f.CreateProperty("DisplayControl", dbInteger, 106)
f.Properties.Append p
f.Properties("DefaultValue")="True"
db.Close
End Sub |
Partager