Fields Object

The Fields object represents a collection of Field objects and provides methods for controlling and accessing the stored objects.

Methods

Count Returns the number of objects, stored in the collection.
Append Adds a new object to the collection.
GetByName Gets an object from the collection by its name.
GetByNumber Gets an object from the collection by its number.
DeleteByName Removes an object from the collection by its name.
DeleteByNum Removes an object from the collection by its number.
Refresh Refreshes the object collection.

Remarks

The Fields object belongs to the Index, Recordset, Relation, TableDef objects and can be retrieved by calling the Fields method.

 

See Also

Field Object, Index Object, Recordset Object, Relation Object, TableDef Object, Fields Method