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

ID: Q170981

The information in this article applies to:

SYMPTOMS

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

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

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

2. Create a new module, and type the following procedure: 

      Sub MySub()
         Stop
      End Sub
3. Run the procedure from the Debug window.

4. Press F11 or click on the Database window to place the focus there.

5. 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: 
Keywords          : kberrmsg kbprg WzProb 
Version           : 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb

Last Reviewed: November 19, 1998