Design View Opens All Forms

I have one Access application that more than one user has been designing. For some reason, when I open one form in Design view and view the code, I end up having to close a whole bunch of other form code windows, too, even though I did not open them.

Is there some setting that needs to be changed to stop this from happening?

Thanks.
Buck_BeasomDatabase DesignerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
that is a normal behavior of the code window.

click on the maximize button of the  code window so you will not be annoyed by the other forms' module
0
PatHartmanCommented:
Access doesn't automatically close the module windows when you close the VBE, so if you want them closed, close them before you exit.  
Or download MZTools (www dot mztools dot com)  It is a very useful collection of tools for working with code.  There is also a close all code windows button.
0
Nick67Commented:
As noted above, this is the default, and as far as I know, unchangeable behavior of the code window.
Moreover, you can sometimes find that when you open the VBE, the modules that are open are NOT ones that you can recall having opened yourself to do some editing and then forgotten to close.
If Access 2003 has a Close All button or option, I've never found it.

There's a keyboard shortcut for closing code windows
CTRL-F4

Hold them down and all open windows will close.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jeffrey CoachmanMIS LiasonCommented:
@Nick
you can sometimes find that when you open the VBE, the modules that are open are NOT ones that you can recall having opened yourself to do some editing and then forgotten to close.

Oh God do I hate that!
0
Nick67Commented:
It's always a bit of mystery why some modules are open in the window, isn't it :)
0
Jeffrey CoachmanMIS LiasonCommented:
@Buck_Beasom,
I have one Access application that more than one user has been designing.
This may be a recipe for problems in the future.
Each designer will have their own ideas of how/when things should be done.
Some will use DAO, others will use ADO, still others will use SQL.
Some will use Case-Select, other will use If-Then-Else.
Some will use single line declarations: Dim FName, LName, as String
Some with use the numeric Constants, other will use the keywords
Some will use OnOpen, others will use OnLoad.
...etc

I don't know how you are managing versions or what your "approval" methodology is, but having more than one Access developer can be difficult to manage...

JeffCoachman
0
Jeffrey CoachmanMIS LiasonCommented:
As far as your issue here...
;-)
Over the years, I have just learned to ignore that particular oddity of the code window(s).

I open the code environment from whatever event I need, then I am sure to be in the correct "module".
Then I maximize that code window.
Thus, I never see another code windows.
If I need another form/module,..I will simply double-click on it in the navigation pane, ...and it too will be maximized.
Thus I never see (and subsequently, never care about), any other open code windows...

Even if there was a way to close all the code windows, I am not aware of any memory savings you might get, and I am not sure it would be worth the trouble...

JeffCoachman
0
Buck_BeasomDatabase DesignerAuthor Commented:
The weird part is this only occurs in one application. For all the other ones (and there are dozens) you open one code window, you close one code window and that's it. But in this one, I open the code window for the form I am working on and when I close it, I then have to close half a dozen other code windows, too!
0
Jeffrey CoachmanMIS LiasonCommented:
This happens for me in "every" Access application...

when I close it, I then have to close half a dozen other code windows, too!
But still, ...why bother...?
What's the issue with just closing the whole code environment?
Alt+F4, Alt+Q, or click File-->Close and return to Microsoft Access

Why the need to close individual code windows...?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nick67Commented:
The weird part is this only occurs in one application.

Because some stupid person at MS in invented FilterOnLoad and someone, who if I ever should meet them in the right circumstance I would cut, decided that said such stupid property would default to True, I have a button that will throw each form in turn open in design view, and then ask me, if a Filter property exists, if I would like it to die.

Running that button -- even without changing a thing -- causes modules to be open in the code window afterward.  I just tested that.

Your one app is clearly doing things that cause the code window to be opened.  Lord only knows what the root cause is, but it is not unusual at all.  it can be as simple as manipulating .Caption properties for reports.  Maybe filters, too.

It's normal, default behavior.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

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.