ACC1x: Find Company Macro Does Not Work Correctly in NWIND.MDB

 Last reviewed: May 28, 1997
Article ID: Q109324
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1

SYMPTOMS

The appropriate record for the company you selected in the Select Company To Find box on the Suppliers form in the sample database NWIND.MDB will not be displayed if you have chosen any of the alphabet buttons on the form.

For example, if you have chosen the "L" alphabet button, and then select a company that has a name that starts with the letter "E" in the Select Company To Find box, the record will not be displayed. Only companies whose names start with the letter "L" can be displayed.

CAUSE

The alphabet buttons on the Suppliers form apply filters to the records. If a filter is applied, only records that match the filter's criteria will be displayed.

RESOLUTION

Choose the All button, so that no filters are applied, before using the Select Company To Find box. 

 -or-
Add the ShowAllRecords macro action as the first line of the Find Company macro, which is the macro run by the Select Company To Find combo box. The ShowAllRecords macro action removes all filters. To add the ShowAllRecords action to the Find Company macro, follow these steps:

  1. Open the sample database NWIND.MDB.

  2. Open the Find Company macro in Design view.

  3. Select the top cell in the Action column, and select ShowAllRecords in the action list.

  4. Save the macro.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database NWIND.MDB.

  2. Open the Suppliers form in Form view.

  3. Select any company name in the Select Company To Find box.

  4. Choose the "L" alphabet button.

  5. Select a company in the Select Company To Find box whose name does not begin with the letter "L". Note that the record for the company is not displayed.

Keywords : FmsCmbo kbusage
Version : 1.0 1.1
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.