ACC2000: Resetting Code in Visual Basic Editor Causes Problems with Wizards (223229)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q223229
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

If you switch from the Access user interface to the Visual Basic Editor while a wizard is running, and you click Reset on the Run menu or you click the Reset button on the toolbar, the wizard stops responding, or you receive any the following error messages. These error messages may be repeated several times.
Subscript out of range.

-or-

Invalid procedure call or argument.

-or-

Object variable or With block variable not set.
When you close all the error messages, some or all of the controls in the wizard may be empty. You may also see the errors when you click or move the mouse pointer over a control in the wizard.

CAUSE

In the Visual Basic Editor, you clicked Reset on the Run menu or you clicked the Reset button on the toolbar while a wizard was running.

RESOLUTION

Click Cancel, and then restart the wizard.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The behavior described in the "Symptoms" section occurs with the following wizards:
  • Chart Wizard
  • Crosstab Query Wizard
  • Find Duplicates Query Wizard
  • Find Unmatched Query Wizard
  • Form Wizard
  • Label Wizard
  • Page Wizard
  • PivotTable Wizard
  • Report Wizard
  • Simple Query Wizard
  • Table Wizard

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Forms under Objects, and then double-click Create form by using wizard.
  3. Press ALT+F11 to start the Visual Basic Editor.
  4. On the Run menu, click Reset.
  5. On the File menu, click Close and Return to Microsoft Access.
Note that you receive some of the error messages mentioned in the "Symptoms" section and that the controls on the Form Wizard are blank.
Modification Type:MinorLast Reviewed:7/14/2004
Keywords:kbbug kbpending KB223229
©2004 Microsoft Corporation. All rights reserved.