Microsoft KB Archive/93296

{|
 * width="100%"|

INF: View Procedures Sorts Modules Alphabetically
'Article ID: Q93296

Creation Date: 03-DEC-1992

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1, 2.0, 7.0

SUMMARY

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

When you click Procedures on the View menu after opening a module, the Modules box displays the modules in alphabetic order. If the modules are numbered, they may appear out of order. You can rename the procedures so that they appear in the proper order in the list.

MORE INFORMATION

Steps to Reproduce Behavior


 * 1) Create three modules (Module1, Module2, Module19).
 * 2) In Microsoft Access 1.x and 2.0, open Module1, and click Procedures on the View menu. In Microsoft Access for Windows 95 version 7.0, click Object Browser on the View menu. Note that the modules are listed Module1, Module19, and Module2 because they are sorted alphabetically.

To have the list sorted properly, rename Module1 and Module2 as Module01 and Module02. The modules will then be sorted as Module01, Module02, and Module19. NOTE: The modules are sorted the same way in the Database window.

REFERENCES

For more information about this topic, search for &quot;browse objects&quot; using Microsoft Access for Windows 95 Help Answer Wizard.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; 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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00 1.10 2.00 7.00

KBCategory: kbui

KBSubcategory: UifOthr