DoCmd.OpenFunction Method

  • Article
Access Developer Reference

Opens a user-defined function in a Microsoft SQL Server database for viewing in Microsoft Access.

Syntax

expression.OpenFunction(FunctionName, View, DataMode)

expression   A variable that represents a DoCmd object.

Parameters

Name Required/Optional Data Type Description
FunctionName Required Variant The name of the function to open.
View Optional AcView A AcView constant that specifies the view in which to open the function. The default value is acViewNormal.
DataMode Optional AcOpenDataMode A AcOpenDataMode constant that specifies the mode in which to open the function. The default value is acEdit.

Remarks

Use the AllFunctions collection to retrieve information about the available user-defined functions in a SQL Server database.

Example

The following example opens the first user-defined function in the current database in Design View and read-only mode.

Visual Basic for Applications 
  Dim objFunction As AccessObject
Dim strFunction As String

Set objFunction = Application.AllFunctions(0)


DoCmd.OpenFunction FunctionName:=objFunction.Name, _
View:=acViewDesign, Mode:=acReadOnly

See Also