List table properties : TableDefs « Access « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Access
  3. TableDefs

List table properties

 
Sub exaProperties()
    Dim db As Database
    Dim tbl As TableDef
    Dim prp As Property
     
    Set db = CurrentDb
    Set tbl = db!Employees
    For Each prp In tbl.Properties
       Debug.Print prp.Name
       Debug.Print prp.Value
       Debug.Print prp.Type
       Debug.Print prp.Inherited
     
    Next prp
    Debug.Print tbl.Properties.Count 
End Sub








Related examples in the same category

1.Database relations
2.Reference column name from TableDefs
3.Add new property to TableDef
4.Create a relation
5.Create an index
6.Create new field with validation rule