Table of contents
TOC
Collapse the table of content
Expand the table of content

DoCmd.OpenFunction Method (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

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

NameRequired/OptionalData TypeDescription
FunctionNameRequiredVariantThe name of the function to open.
ViewOptionalAcViewA AcView constant that specifies the view in which to open the function. The default value is acViewNormal.
DataModeOptionalAcOpenDataModeA 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 

See also

Concepts

DoCmd Object

© 2017 Microsoft