Suppress Modules from Loading in VB Window

  • Thread starter Thread starter terri
  • Start date Start date
T

terri

I am using 2003 on a new computer. Each time I open a file, all of the
modules in all of the referenced mda files open. With my main FE file, this
can literally mean minutes before I can begin editng. Since this didn't
happen with my prior PC, I'm assuming there is an option setting that is
causing this behavior. Nothing under Tools->Options in either the database
window or VB window seem to do it. What am I not seeing?

Thanks!
 
terri said:
I am using 2003 on a new computer. Each time I open a file, all of the
modules in all of the referenced mda files open. With my main FE file,
this
can literally mean minutes before I can begin editng. Since this didn't
happen with my prior PC, I'm assuming there is an option setting that is
causing this behavior. Nothing under Tools->Options in either the
database
window or VB window seem to do it. What am I not seeing?
Click to expand...

I answered this, but I'm not sure I really understood your question. I think
by reading this again that you may have a reference set to another database,
which may not be compiled. After opening your VBA window, click on Tools >>>
Refertences and check to see if another database is referenced. If so,
uncheck it an compile your database. If it compiles OK, leave the reference
off, otherwise, open it back up and reset the reference. Then open the
referenced database and try compiling it.
 
Thanks for your reply Arvin.

(Sorry about the double-post -- when I didn't receive a verification, I
assumed it hadn't gone through... I must have not cheked the notify box.)

Any way, yes I am dealing with references -- the layout of the FE
application is 1 MDA that contains common code, 8 mdas that represent
separate modules that all reference the common mda, and 1 mdb that references
the 9 mdas (and links the BE database tables).

When working in any of the 8 mdas, as soon as I opened any module it would
load all the modules from the common mda in the VB window -- not the taskbar
-- one at a time. In the mdb, it would loop through all 9 mdas.

Taking your suggestion, I tried manually compiling each mda and found an
issue in the common mda. Now that it is corrected (and compiled), I get the
window pop-ups when I compile the mda (or mdb) I am working in -- not when I
first try to edit.
 
Back
Top