DoCmd.OpenFunction Method
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 |
---|
|
See Also