out of memory viewing code

[Eric]

I'm getting low resources/out of memory errors when I go
to view my code. My computer will stop processing
eventually. I have 256Mb RAM running Win ME. The resource
meter sits at about 61% free for user and system resources
when only windows is running but gets completely depleted
when I open up the visual basic editor of my access
application.

 

[Brendan Reynolds \(MVP\)]

When you open the VBA editor, it opens all modules that were open the last
time you saved within the VBA editor. You may see only one open code window,
but there may be many more open 'behind' that window.

If you can't get into the VBA editor at all, try importing everything into a
new, empty MDB (or ADP, as the case may be). Once you can get into the VBA
editor, to prevent the problem happening again, get into the habit of
forcing a save before you close the VBA editor. Change something - for
example, put in a blank line and backspace it out again - then close all
code windows (or all except those you want opened the next time you open the
VBA editor). Then save before you close the VBA editor.