Microsoft KB Archive/824279

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

Article ID: 824279

Article Last Modified on 5/31/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * 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.



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 &quot;Symptoms&quot; 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,&quot;FRF&quot;,&quot;EUR&quot;,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 &quot;Applies to&quot; section.

Additional query words: ACC2007 ACC2003 euro convert code won't work dap internet browser eval undefined function functionname in expression

Keywords: kbvba kbprogramming kberrmsg kbdapscript kbdap kbquery kbbug KB824279

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.