Microsoft KB Archive/295230

= ACC2002: Filter Toolbar Disappears When You Use the Advanced Filter/Sort Feature =

Article ID: 295230

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q295230



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you use the Advanced Filter/Sort feature in a Microsoft Access table, the Filter toolbar disappears when the Advanced Filter/Sort window opens.



RESOLUTION
To work around this issue, use one of the following methods:

Right-click the menu bar, and then select the Filter toolbar. -or-

On the Filter menu, click Advanced Filter/Sort.



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



MORE INFORMATION
The Advanced Filter/Sort feature allows you to perform complex filtering tasks, such as applying multiple search criteria, by using entire expressions as search conditions and by using one criterion or another. To apply the Advanced Filter/Sort feature to a table, you must click the Apply Filter button after you finish designing the filter in the filter design grid.

Steps to Reproduce the Problem
 Start Access and open any database. You can use the Northwind sample database usually located at the following location:

C:\Program Files\Microsoft Office\Office10\Samples

 Open any table in Datasheet view. On the Records menu, point to Filter, and then click Advance Filter/Sort. Note that all toolbars disappear, leaving only the menu bar visible. This removes the option of applying the filter by clicking the Apply Filter button on the Filter toolbar.

