Beginning Access 2002 VBA (Programmer to Programmer)
| |
Methods
| Name | Returns | Description |
|---|---|---|
| CreateField | Field | Create a new Field in the index. |
| CreateProperty | Property | Creates a user -defined property on the index. |
Properties
| Name | Returns | Description |
|---|---|---|
| Clustered | Boolean | Identifies whether or not the index is clustered. |
| DistinctCount | Long | Identifies the number of unique values for the Index that are in the underlying table. Read-only. |
| Fields | Variant | Collection of Field objects in an Index object. |
| Foreign | Boolean | Indicates whether or not the index is a foreign key. Read-only. |
| IgnoreNulls | Boolean | Indicates whether or not the index ignores null values. |
| Name | String | The name of the index. |
| Primary | Boolean | Indicates whether or not this is the primary index. |
| Properties | Properties | Collection of Property objects. Read-only. |
| Required | Boolean | Indicates whether or not the index entry must have a value. |
| Unique | Boolean | Indicates whether or not this is a unique index. |
| |