VBE Code Modules will not stay closed

T

Tony_VBACoder

In Access 2002 (SP2) with WinXP, why won't my code modules
stay closed when I close Access? If I open up code behind
forms or Modules and close each window, the next time I
open Access and go into my VBE and select "Window", I have
all my module windows open again.

Is there some new setting for this? I have never noticed
this strange behavior with previous versions of Access.
 
D

Dirk Goldgar

Tony_VBACoder said:
In Access 2002 (SP2) with WinXP, why won't my code modules
stay closed when I close Access? If I open up code behind
forms or Modules and close each window, the next time I
open Access and go into my VBE and select "Window", I have
all my module windows open again.

Is there some new setting for this? I have never noticed
this strange behavior with previous versions of Access.
Click to expand...

Not only is it an annoyance, it can even cause Access to fail due to
insufficient resources to display all those windows. Here's what works
for me to fix it.

Open up the VB Editor. Make an unimportant change to any module, like
adding a space at the end of a line. Then change it back if you have
to. The sole purpose of this change is to convince the editor that your
VB project is "dirty". Now compile your project. After doing that, and
before you save the project, close all the open module windows. *After*
you've closed all the module windows, click the Save button on the
toolbar, or the menu item File -> Save (project name), or press Ctrl+S.

The next time you open the VB Editor, the windows should still be
closed. In the future, as you work in the VB Editor, close the module
windows before saving the project.
 
T

Tony_VBACoder

Dirk

Thanks for the help...it worked as planned. I can't
believe this hasn't been fixed with a Patch, or has it?
 
Top