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

ID: Q223229

The information in this article applies to:
  • Microsoft Access 2000
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and 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 this to be a problem in the Microsoft products 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.

Additional query words: pra pivot table cleared clears nothing

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: September 14, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.