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



The information in this article applies to:

  • Microsoft Access 97

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

  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.

Modification Type:MajorLast Reviewed:9/26/2003
Keywords:kberrmsg kbprb kbprogramming KB170981