Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 918584 - Last Review: November 3, 2006 - Revision: 1.1
You cannot process a data collection e-mail reply when the query that the e-mail was based on contains an Access 2007-defined function
This article applies to a Microsoft Access database (.mdb)
and to a Microsoft Access database (.accdb).
Novice: Requires knowledge of the user interface on single-user computers.
You cannot process a data collection e-mail reply when the
query that the e-mail was based on contains a Microsoft Office Access 2007-defined function, such as
the
PlainText function in Access 2007. The e-mail reply does not process
automatically into Access 2007, even if you select this option. You may notice that the data collection status in Microsoft Office Outlook 2007 displays the following
information:
Failure: Undefined function
'FunctionName' in expression.
represents the name of the
function that you use in the query.
Additionally, you receive the following error message if you manually process
the data collection:
Cannot
export data due to errors. Failure: Undefined function 'FunctionName' in expression.
This problem occurs because the query contains an Access-defined function, such as the
PlainText function. This problem occurs even though the
expression field that contains the Access 2007-defined function is not in the
e-mail.
To work around this problem, remove the reference to the
Access-defined function, or remove the field that contains the function call
from the query.
APPLIES TO
- Microsoft Office Access 2007
| kbexpertisebeginner kbtshoot kbprb KB918584 |
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