Knowledge Base

ACC97: Can't Use Any Wizard While in Break Mode of a Module

Article ID: 170981

Article Last Modified on 1/20/2007

Microsoft Access 97 Standard Edition

This article was previously published under Q170981

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

SYMPTOMS

If you try to run a wizard while in break mode of a module, you may receive the following message:

Microsoft Access can't find the wizard, or there is a syntax error in the Declarations section of a Visual Basic module.

CAUSE

You cannot run any of the wizards while in break mode of a module.

RESOLUTION

Stop all code from executing, and then run the wizard.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb in Microsoft Access 97.

Create a new module, and type the following procedure:

      Sub MySub()
         Stop
      End Sub

Run the procedure from the Debug window.
Press F11 or click on the Database window to place the focus there.
On the Tools menu, point to Analyze, and then click Table. Note that you receive the error message described in the "Symptoms" section.

Additional query words: Microsoft Access can t find the wizard

Keywords: kberrmsg kbprb kbprogramming KB170981