ACC97: "Command Not Available" Err on Converted Switchboard Form

Last reviewed: May 21, 1997
Article ID: Q160124
The information in this article applies to:
  • Microsoft Access 97

SYMPTOMS

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

After you convert a database in Microsoft Access 97 that you created with the Database Wizard in Microsoft Access 7.0, you may receive the following error message when you click the Change Switchboard Items button on the Main Switchboard form:

   Command Not Available

CAUSE

There is a line of code in the Main Switchboard form's class module that references a Microsoft Access 7.0 Wizard. The code must be modified for Microsoft Access 97.

RESOLUTION

Follow these steps to eliminate the error:

  1. Start Microsoft Access 97 and open the converted database.

  2. Open the Main Switchboard form in Design view.

  3. On the View menu, click Code.

  4. Select HandleButtonClick in the Procedure box of the form's module window.

  5. Locate the line in the HandleButtonClick function that reads:

          Application.Run "WZMAIN70.sbm_Entry"
    

  6. Change the line to read:

          Application.Run "WZMAIN80.sbm_Entry"
    

  7. Save the form and close it.

MORE INFORMATION

Steps to Reproduce Behavior

Create a database in Microsoft Access 7.0 as follows:

  1. Start Microsoft Access 7.0.

  2. When the Microsoft Access dialog box appears as the program starts, click Database Wizard in the "Create a New Database Using" box. If Microsoft Access 7.0 is already open, click New Database on the File menu.

  3. In the New dialog box, click the Databases tab, and then click Book Collection.mdz. Click OK.

  4. In the File New Database dialog box, type Book70.mdb in the File name box, and then click Create.

  5. When the Database Wizard starts, click Finish.

  6. After the database is created, quit Microsoft Access 7.0.

Convert the database in Microsoft Access 97 as follows:

  1. Start Microsoft Access 97 and open the Book70.mdb database.

  2. In the Convert/Open Database dialog box, click Convert Database, and then click OK.

  3. In the Convert Database Into dialog box, type "Book97.mdb" (without the quotation marks) in the File name box, and then click Save.

  4. When the Main Switchboard form opens, click the Change Switchboard Items button. Note that you receive the error "Command not available."

REFERENCES

For more information about switchboard forms, search the Help Index for "switchboard forms," or ask the Microsoft Access 97 Office Assistant.


Additional query words: menu template customize
Keywords : CnvOthr kberrmsg
Version : 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb


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 21, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.