• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 52
  • Last Modified:

Access VB Code Window - Close Multiple Objects

Hi Experts,
I accidently did something to cause the Code Window to open in VB Code for hundreds of Objects.

I closed each one by clicking the Close Button for each but when I open up the VBA Code Window again they all appear again.

Is there a way to stop this happening so only the one for the Form I am working on displays?
Is there a way to close all of them without doing them one at a time?

Thanks,
Bob C.
0
Bob_Collison
Asked:
Bob_Collison
2 Solutions
 
Gustav BrockCIOCommented:
Press - and hold - Ctrl+F4 to close all windows.
Click Save.
Then go to Database Tools and click Compact and Repair.

/gustav
0
 
Rey Obrero (Capricorn1)Commented:
It is common to see all the vba module window if they are not on maximize view
To see only one window, click on the Maximize button on any of the code window, then save

x
0
 
Bob_CollisonAuthor Commented:
Hi Gustave / Rey,

I haven't had the problem since and so couldn't test Gustave's solution but it does answer my question of how to close them without doing them one by one which I believe was what Rey was suggesting.

Thanks for your solutions.
Bob C.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now