Microsoft KB Archive/304755

= ACC2000: &quot;Undefined Function '{FunctionName}' in Expression&quot; When You Open a Data Access Page =

Article ID: 304755

Article Last Modified on 7/16/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q304755



Moderate: Requires basic macro, coding, and interoperability skills.

For a Microsoft Access 2002 version of this article, see 274379.



SYMPTOMS
In a data access page, if you call a function that is not available outside of Microsoft Access, you receive the following message when you open the page in Microsoft Internet Explorer:

Data Provider failed executing a provider command.

This message is followed by another message:

Undefined function '{FunctionName}' in expression.

This error does not occur when you open the data access page in Access.



CAUSE
When you open the page in Internet Explorer, certain Access-specific functions are not available. For example, you see this message if your data access page is based on a query in which an expression contains Nz, EuroConvert, Eval, or a user-defined function.

You also receive this message if you use one of these functions in a control (such as a text box) on a data access page.



RESOLUTION
This is a known limitation of data access pages.

However, two of these functions, Nz and Euroconvert, have been added as methods of the Microsoft Data Source Control (MSODSC) object. If you want to use Nz and Euroconvert in a data access page, you can do so by using the following syntax:

Euroconvert Method

MSODSC.Euroconvert(50,&quot;FRF&quot;,&quot;EUR&quot;,False,3) Nz Method

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



MORE INFORMATION
For more information about these and other methods of the DataSourceControl object, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type DataSourceControl Methods in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

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

Keywords: kberrmsg kbbug kbnofix kbdap kbdapscript KB304755

-

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

© Microsoft Corporation. All rights reserved.