AllFunctions Property

Microsoft Access Visual Basic

AllFunctions Property

       

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

expression.AllFunctions

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

Remarks

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

Example

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