ACC2002: Filter Toolbar Disappears When You Use the Advanced Filter/Sort Feature (295230)


The information in this article applies to:

  • Microsoft Access 2002
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

  1. 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

  2. Open any table in Datasheet view.
  3. 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.

REFERENCES

For more information about using filters, click Microsoft Access Help on the Help menu, type filters in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbnofix KB295230
©2003 Microsoft Corporation. All rights reserved.