Microsoft KB Archive/295247

= ACC2002: Error When You Use Filter by Selection on a Data Access Page =

Article ID: 295247

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295247



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

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
When you use filter by selection on a data access page, you receive the following error message:

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.



CAUSE
A key field in the underlying table has a space in its name.



RESOLUTION
Remove the space or spaces from the name of the key field.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

Steps to Reproduce the Behavior

 * 1) Start Microsoft Access, and then open the sample database Northwind.mdb.
 * 2) In the Database window, click the Customers table.
 * 3) On the Edit menu, click Copy.
 * 4) On the Edit menu, click Paste. When you are prompted, name the table CustomersSpace.
 * 5) Open the CustomersSpace table in Design view.
 * 6) Change the name of the CustomerID field to Customer ID, and then save and close the table.
 * 7) In the Database window, click Pages under Objects, and then click New.
 * 8) In the New Data Access Page dialog box, click AutoPage: Columnar, click the arrow in the Choose the table or query where the object's data comes from box, click CustomersSpace, and then click OK.
 * 9) When the page opens, click the Filter by Selection button on the navigation bar. Note that you receive the error message that is mentioned in the &quot;Symptoms&quot; section of this article.

Keywords: kbbug kberrmsg kbnofix KB295247

-

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

© Microsoft Corporation. All rights reserved.