DoCmd.OpenFunction Method (Access)
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.
Dim objFunction As AccessObject
Dim strFunction As String
Set objFunction = Application.AllFunctions(0)
DoCmd.OpenFunction FunctionName:=objFunction.Name, _
View:=acViewDesign, Mode:=acReadOnly