Out of Memory

[Dabobson]

I know a lot of people have posted similar problems to this but I
haven't found an identical one, and I still don't have a solution.
Whenever any VBA script runs in my Access database I get an "Out of
Memory" message. The same thing happens when I try to edit VBA - the
actual editing is fine until I try to move on to a different line and
I get the message. The number of editor windows I have open makes no
difference. It happens with only one open, and it lets me open as many
more windows as I want without a problem until I edit. I can open as
many external apps as I want without a problem too.
After reading various other posts I've tried importing objects into
another (new) database. So far I've had absolutely no problem when
importing tables (dozens of them), but can receive an "out of memory"
message importing the first form into an empty database. This isn't
entirely consistent though - sometimes it happens, sometimes it
doesn't.
Any ideas welcomed, cos I'm starting to think I'm going to spend days
getting nowhere on this.
Thanks,
Doug

[Bruce Pick]

Someone will hopefully give more precise guidance, but...
It looks like a VBA problem. If the trouble is always and only with one
particular form, then there's the source. However, I sustect instead...

that it's a problem with one or more reference libraries for VBA. It's
not unusual for them to get fouled up, and I've had intermittent success
in maintaining them. All of my troubles with VBA becoming unavailable
have been related to VB or other versions of MS Office or MS Access
being installed on the same operating system.

Bruce Pick
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++
To send email, remove all < > and [ ] and the junk ~ between:
[brucepick1]
< a~t >
[comcast.net]
Dabobson wrote:

I know a lot of people have posted similar problems to this but I
haven't found an identical one, and I still don't have a solution.
Whenever any VBA script runs in my Access database I get an "Out of
Memory" message. The same thing happens when I try to edit VBA - the
actual editing is fine until I try to move on to a different line and
I get the message. The number of editor windows I have open makes no
difference. It happens with only one open, and it lets me open as many
more windows as I want without a problem until I edit. I can open as
many external apps as I want without a problem too.
After reading various other posts I've tried importing objects into
another (new) database. So far I've had absolutely no problem when
importing tables (dozens of them), but can receive an "out of memory"
message importing the first form into an empty database. This isn't
entirely consistent though - sometimes it happens, sometimes it
doesn't.
Any ideas welcomed, cos I'm starting to think I'm going to spend days
getting nowhere on this.
Thanks,
Doug