PRB: Incorrect Actions Using Orders Edit Menu in ORDERS.MDB

Article ID: Q119774
Creation Date: 23-AUG-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access version 2.0

SYMPTOMS

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

When you choose Paste Append from the custom Edit menu bar in the ORDERS.MDB sample database, a Paste Special action is carried out instead. The following table lists this and other incorrect actions that are carried out when you choose commands from the custom Edit menu bar in the ORDERS.MDB database:

   Command            Action Carried Out
   -------------------------------------
   Paste Append       Paste Special
   Delete             Paste Append
   Select Record      Delete
   Select All         Select Record
   Find               Select All
   Replace            Find

CAUSE

The macro actions in the Orders Menu Bar_Edit macro are listed incorrectly.

STATUS

This behavior no longer occurs in Microsoft Access for Windows 95 version 7.0.

RESOLUTION

You can modify the Orders Menu Bar_Edit macro so that the actions are listed correctly. The correct actions are:

   Paste Append
      Action: DoMenuItem
      Menu Bar: Form
      Menu Name: Edit
      Command: Paste Append
   Delete
      Action: DoMenuItem
      Menu Bar: Form
      Menu Name: Edit
      Command: Delete
   Select Record
      Action: DoMenuItem
      Menu Bar: Form
      Menu Name: Edit
      Command: Select Record
   Select All
      Action: DoMenuItem
      Menu Bar: Form
      Menu Name: Edit
      Command: Select All Records
   Find
      Action: DoMenuItem
      Menu Bar: Form
      Menu Name: Edit
      Command: Find
   Replace
      Action: DoMenuItem
      Menu Bar: Form
      Menu Name: Edit
      Command: Replace

NOTE: To open the ORDERS.MDB database so that you can modify this macro, press and hold the SHIFT key while you open the database.

REFERENCES

For more information about menu bar macros, search for "menu bar macro," and then "Creating a Custom Menu Bar Using Macros" using the Microsoft Access Help menu.

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.