AllFunctions Property [Access 2003 VBA Language Reference]

Returns an AllFunctions collection representing all the user-defined functions in a Microsoft SQL Server database.


expression Required. An expression that returns one of the objects in the Applies To list.


You can use the AllFunctions property to reference the AllFunctions collection and its related properties.


The following example prints the name of each open AccessObject object in the AllFunctions collection.

Dim objFunction As AccessObject

Debug.Print "Currently loaded functions:"

For Each objFunction In Application.CurrentData.AllFunctions
    If objFunction.IsLoaded = msoTrue Then
        Debug.Print objFunction.Name
    End If
Next objFunction

Applies to | CodeData Object | CurrentData Object

See Also | AllFunctions Collection | OpenFunction Method