"Undefined Function '{FunctionName}' in Expression" error message when you open a data access page in Internet Explorer (824279)
The information in this article applies to:
- Microsoft Office Access 2003
This article applies to a Microsoft Access database (.mdb) and a Microsoft
Access project (.adp). Moderate: Requires basic macro,
coding, and interoperability skills.
For a Microsoft Access 2000 version of this article,
see
304755. For a Microsoft Access 2002 version of this article,
see
274379. SYMPTOMSWhen you open a data access page by using Microsoft Internet
Explorer, and that data access page contains a function that is not available
outside Access, you may receive the following error message: Data Provider failed executing a provider
command. The previous message is then followed by the
following message: Undefined function
'{FunctionName}' in expression. However, when you open a
data access page by using Access, the error messages do not
appear. CAUSEWhen you open a data access page by using Internet Explorer,
certain Access-specific functions are not available. As a result, you may
receive the error messages that are in the "Symptoms" section.
For
example, you receive the error messages if a data access page is based on a
query that has an expression that contains the Nz() function, the EuroConvert() function, the Eval() function, or a user-defined function.
You may also
receive the error messages if you use one of these functions in a control (such
as a text box) on a data access page.WORKAROUNDNote This is a known limitation of data access pages. You
can work around this problem with two of these functions, Nz() and Euroconvert(). Nz() and Euroconvert() may be added as methods of the Microsoft Data Source Control
(MSODSC) object. If you want to use the Nz() method or the Euroconvert() method in a data access page, you can use the following
syntax: Euroconvert Method Syntax
MSODSC.Euroconvert(50,"FRF","EUR",False,3)
Nz Method
SyntaxMSODSC.Nz([NumericValueHere],0) STATUS Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
REFERENCES For more information about the
methods of the DataSourceControl object, click Microsoft Visual Basic
Help on the Help menu, type
DataSourceControl Methods in the Search
for box in the Assistance pane, and then click Start
searching to view the topic.
Modification Type: | Minor | Last Reviewed: | 6/8/2004 |
---|
Keywords: | KbVBA kbProgramming kberrmsg kbDAPScript kbDAP kbQuery kbbug KB824279 kbAudDeveloper |
---|
|