Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 53
  • 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 CollisonSystem ArchitectAuthor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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