Microsoft Access VBA Programming for the Absolute Beginner

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

Syntax

DoCmd.OpenFunction FunctionName[, View][, DataMode]

with the following parameters:

FunctionName

The name of the function to open.

View

A member of the AcView enumeration defining the view in which to open the function. Practical values are acViewDesign, acViewNormal, and acViewPreview.

DataMode

An AcOpenDataMode constant that defines the mode in which the function is opened. Possible values are acAdd (the user can add new code but can’t edit existing code), acEdit (the user can edit existing code and add new code), and acReadOnly (the code is read-only).

Comments

• The OpenFunction method was first introduced in Access for Office XP.

• To determine what functions are available, you can iterate the Application.AllFunctions collection.