Access 2002 IDE default project/module display

[Jerry Porter]

I have an Access 2002 mdb ("Main") that references another mdb
("Library"). When I open the Main mdb and display the code window, it
invariably has the Library project and a variety of module windows
initially displayed. If I close all the code windows and select the
Main project and exit, it doesn't help.

Besides the clutter, it's (mildly) annoying when I open the IDE to run
a command in the immediate window, and it doesn't work because the
wrong project is selected.

In case it's relevant, I am using the MZ-Tools 3.0 Add-in.

Any explanations?

Thanks,

Jerry

 

[Albert D.Kallal]

The "key" concept here is that after you close those modules, then do a
debug-compile.

(if your project is not "dirty", then go into one of those modules that you
"see", and simply dirty the module by editing it (just add a blank
line...then delete it!).

Now, close that module...and then go debug->compile.

If did not compile, then ms-access kind of assumes that you want to go back
to the code and work some more.....

I as a rule don't have the problem, since I always compile right after I
make a code change
(my hands have the keys alt-debug (left hand), and then "Enter key" right
hand hard wired, and I do that so fast, and so often I don't even remember
doing it anymore).

Anyway, the above should fix your problem. If some modules are more
stubborn, then dirty each one as above, close them. and then do a
compile....

 

[Jerry Porter]

Albert,

Thanks for the tips.

It took me a few tries to get all the modules closed: I had to open the
library database separately and close modules and compile to keep them
from opening when I opened the main mdb.

Now when I open the main mdb, no modules are open. But I still have the
problem that the Library is the active project (selected in Project
Explorer).

Jerry

 

[Jerry Porter]

It's now working fine and my Main project is selected by default. I had
originally closed all modules (and compiled). Since I've worked in the
Main project's modules, that's changed the default view.

Thanks Albert!