Microsoft KB Archive/100133

= ACC: Form Is Inaccessible When Debugging Run-Time Error =

Article ID: 100133

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q100133



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



SYMPTOMS
If a form calls an Visual Basic for Applications function that is halted because of a run-time error, the form will become inaccessible.



CAUSE
When a program halts because of a run-time error, the form's handle is not released by the system. Even though the program is no longer running, the handle is still in use.



RESOLUTION
To release the form handle after the program has halted, click Reset on the module's Run menu.



Steps to Reproduce Behavior
  Create and save a form with the following command button on it:      Object: Command Button --     Caption: Run Code OnClick: =Test NOTE: In Microsoft Access version 1.x, the OnClick property is called the OnPush property.   In a new module, create and save the following function named Test: Function Test Dim x as Integer x = 1 / 0 End Function  Open the form that you created in step 1. Click the Run Code button. Note that the program will halt and that you receive the error message "Division By Zero." Click Debug (or click OK in versions 1.x and 2.0).</li> Minimize the module in which the function is being displayed.</li> Try to click the Run Code button again, or try to move the form. Note that you cannot manipulate the form or anything on it. This is because the form handle is not available.</li> To release the form handle after the program has halted, click Reset (or Reinitialize in version 1.x) on the module's Run menu.</li></ol>

Keywords: kbprb kbprogramming KB100133

-

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

© Microsoft Corporation. All rights reserved.