Error message when you open a data access page in Internet Explorer: "Undefined function '{FunctionName}' in expression"

Article translations Article translations
Article ID: 824279 - View products that this article applies to.
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.
Expand all | Collapse all

SYMPTOMS

When 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.

CAUSE

When 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.

WORKAROUND

Notes
  • This is a known limitation of data access pages.
  • You cannot create or modify data access pages in Microsoft Office Access 2007.
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 Syntax
MSODSC.Nz([NumericValueHere],0)

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 824279 - Last Review: May 31, 2007 - Revision: 2.1
APPLIES TO
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
Keywords: 
kbvba kbprogramming kberrmsg kbdapscript kbdap kbquery kbbug KB824279

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com