ACC: "Undefined Function in Expression" Error Message
ID: Q123344
|
The information in this article applies to:
-
Microsoft Access versions 2.0, 7.0, 97
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
When you call a user-defined function from within an aggregate (totals)
function, such as the Sum() function, in a report, you may receive the
following error message:
Undefined function '<function name>' in expression.
CAUSE
The user-defined function is located in the report module.
RESOLUTION
Transfer the user-defined function from the report module to a global
module.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access versions
2.0, 7.0, and 97.
MORE INFORMATION
Steps to Reproduce Problem
- Open the sample database Northwind.mdb (or NWIND.MDB in Microsoft
Access 2.0).
- Open the Alphabetical List Of Products report in Design view.
- Add a text box with the following property to both the detail section
and the Product Name footer section of the report:
ControlSource: =Sum(Notwork())
- On the View menu, click Code.
- Enter the following user-defined function in the report module:
Function Notwork()
Notwork=8
End function
- Close the report module.
- Preview the report. Note that you receive the error message described
earlier in this article.
REFERENCES
For more information about creating modules, search for "module," and
then "Creating" using the Microsoft Access 97 Help index.
Keywords : kberrmsg
Version : 2.0 7.0 97
Platform : WINDOWS
Issue type : kbbug