Microsoft KB Archive/223229

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

Article ID: 223229

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.

Additional query words: pra pivot table cleared clears nothing

Keywords: kbbug kbpending KB223229

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.