Microsoft KB Archive/101673: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 12: | Line 12: | ||
<div id="TitleRow"> | <div id="TitleRow"> | ||
= <span id="KB101673"></span>ACC: | = <span id="KB101673"></span>ACC: "Undefined Function" Error Message Referencing Column Property = | ||
Line 77: | Line 77: | ||
If you wrap the expression inside the Eval() function as a text string, Microsoft Access will consider the entire reference as a whole, and will not try to parse it. For example:<br /> | If you wrap the expression inside the Eval() function as a text string, Microsoft Access will consider the entire reference as a whole, and will not try to parse it. For example:<br /> | ||
<pre class="fixed_text"> Eval( | <pre class="fixed_text"> Eval("[Forms]![Formname]![Controlname].column(2)") | ||
</pre> | </pre> | ||
Line 134: | Line 134: | ||
== REFERENCES == | == REFERENCES == | ||
For more information about using the Column property in an expression, search on | For more information about using the Column property in an expression, search on "Column property," and then "Refer to a column in a list in an expression," using the Microsoft Access 97 Help Index. | ||
</div> | </div> |
Latest revision as of 09:19, 20 July 2020
Article ID: 101673
Article Last Modified on 1/18/2007
APPLIES TO
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q101673
Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
When you try to run macro actions that contain a Where clause (ApplyFilter, OpenForm, OpenReport, and FindRecord), and queries that reference the Column property of a combo box or list box on a form, you may receive the following error message:
CAUSE
Microsoft Access interprets any text followed by opening and closing parentheses as a user-defined function.
RESOLUTION
If you wrap the expression inside the Eval() function as a text string, Microsoft Access will consider the entire reference as a whole, and will not try to parse it. For example:
Eval("[Forms]![Formname]![Controlname].column(2)")
STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Access listed at the beginning of this article.
MORE INFORMATION
Steps to Reproduce Problem
- Open the sample database Northwind.mdb (or NWIND.MDB in version 2.0 or earlier), and create a new form based on the Orders table.
Add a combo box control with the following properties:
Form: PromptForm -------------------- RecordSource: Orders Combo box: Name: TheCombo RowSource: Orders ColumnCount: 4 BoundColumn: 1
- Save the form as PromptForm, and then close it.
Create the following query based on the Employees table:
Query: ReferenceCombo --------------------- Type: Select Query Field: EmployeeID ([Employee ID] in Microsoft Access 1.x and 2.0) Table: Employees Criteria: =[Forms]![PromptForm]![TheCombo].column(2) Field: LastName ([Last Name] in Microsoft Access 1.x and 2.0) Table: Employees Field: FirstName ([First Name] in Microsoft Access 1.x and 2.0) Table: Employees
- Open the PromptForm form in Form view and select an item from the combo box.
- Open the ReferenceCombo query in Datasheet view. Note that you receive the following error message: Undefined Function '[Forms]![PromptForm]![TheCombo].column' in Expression.
REFERENCES
For more information about using the Column property in an expression, search on "Column property," and then "Refer to a column in a list in an expression," using the Microsoft Access 97 Help Index.
Keywords: kbbug kberrmsg KB101673