Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 824279 - Last Review: May 31, 2007 - Revision: 2.1
Error message when you open a data access page in Internet Explorer: "Undefined function '{FunctionName}' in expression"
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=304755/
)
.
For a Microsoft Access 2002 version of this article, see
274379Â
(http://kbalertz.com/Feedback.aspx?kbNumber=274379/
)
.
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.
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.
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)
MSODSC.Nz([NumericValueHere],0)
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
APPLIES TO
- Microsoft Office Access 2007
- Microsoft Office Access 2003
| kbvba kbprogramming kberrmsg kbdapscript kbdap kbquery kbbug KB824279 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate