AllFunctions object (Access)

The AllFunctions collection contains an AccessObject object for each function in the CurrentData or CodeData object.

Remarks

The CurrentData or CodeData object has an AllFunctions collection containing AccessObject objects that describe instances of all functions specified by the CurrentData or CodeData objects. For example, you can enumerate the AllFunctions collection in Visual Basic to set or return the values of properties of individual AccessObject objects in the collection.

Refer to an individual AccessObject object in the AllFunctions collection either by referring to the object by name, or by referring to its index within the collection. If you want to refer to a specific object in the AllFunctions collection, it's better to refer to the function by name because a function's collection index may change.

The AllFunctions collection is indexed beginning with zero. If you refer to a function by its index, the first function is AllFunctions(0), the second function is AllFunctions(1), and so on.

To list all open functions in the database, use the IsLoaded property of each AccessObject object in the AllFunctions collection. You can then use the Name property of each individual AccessObject object to return the name of a function.

You can't add or delete an AccessObject object from the AllFunctions collection.

Properties

• Application
• Count
• Item
• Parent

See also

• Access Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.