Enviornment: MS Access 2002 (XP) and VSS 6.0d
Is there a way to clear the list of modules that the VBA editor
'automatically' opens? What's happening is when I go to open a module and
answer yes to checking it out of VSS, it then asks to check out a bunch of
other modules that I worked on in the past. What ends up happening is that
I've got to go through the process twice in order to get the code window open
with the module that I want to work on. I've tried closing all modules
before closing the VBA editor window, but that does not help. At this point
I wished that it didn't remember any of the previously opened modules.
Thanks.
Brendan Reynolds - 14 Mar 2005 23:12 GMT
Try forcing a save. Make some change, for example comment then uncomment a
line, or put in a blank line then take it out again. Then close all modules
(or all except those that you want to open next time you open the VBE) and
save before closing the VBE.

Signature
Brendan Reynolds (MVP)
> Enviornment: MS Access 2002 (XP) and VSS 6.0d
>
[quoted text clipped - 11 lines]
>
> Thanks.
Dirk Goldgar - 14 Mar 2005 23:15 GMT
> Enviornment: MS Access 2002 (XP) and VSS 6.0d
>
[quoted text clipped - 7 lines]
> but that does not help. At this point I wished that it didn't
> remember any of the previously opened modules.
I don't know whether the use of VSS makes a difference to this solution
or not, since I don't use it, but what I find (without VSS in the mix)
is that I need to make a change to some module or other -- even a
trivial change -- then close all the modules, and then click the Save
button on the VB Editor's toolbar. That seems to save not only the
module I changed, but also the state of the editor and its windows.
Have you tried that?

Signature
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
CBKowitz - 15 Mar 2005 12:51 GMT
Thanks that does work.
> > Enviornment: MS Access 2002 (XP) and VSS 6.0d
> >
[quoted text clipped - 15 lines]
> module I changed, but also the state of the editor and its windows.
> Have you tried that?