Again-Why do I get "out of Memory" message

[Guest]

Hello,

I have problem of low memory again. Running macro loop after aprox. 8000
times a message appears:

There isn't enough memory available to perform this calculation.
Close unneeded programs …..

Macro repeat expression is conditioned (([Forms]![Name]![Control Name]) Is
Not Null. Total num. of records aprox. 24000.
Actions used in macro loop are ordinary :
Openform
SetValue (setting string from another opened form)
RunMacro (another subMacro)
RunCommand (RecordsGoToNext)

Mr. Doug Steele, (Microsoft Access MVP) answered my question (21.june.05)
with same problem. He mentioned TEMP environment variable.
How can I expand memory by TEMP environment variable?

 

[Douglas J. Steele]

You can't expand the memory. The TEMP Environment Variable points to a hard
drive location. The amount of "memory" to which it points is dependent on
the free space on the hard drive. If you don't have much free space wherever
it's pointing, change it to point to another hard drive (or else free up
space on your hard drive).

How you do this depends on your OS. Try looking at the System option on the
Control Panel. See if there's a button labelled "Environment Variables" on
the Advanced tab. You can change the value there.

 

[Guest]

I tried to change value in "Environment Variables" part of System properties.
And there was still not enough of memory.
Then I tried to write macro to avoid continually form opening that takes a
lot of memory. I was successful. I solved it with update queries to
independent table.
It is no good to be in a hurry.
In anyway, thank you Mr. Steele.
Bye

You can't expand the memory. The TEMP Environment Variable points to a hard
drive location. The amount of "memory" to which it points is dependent on
the free space on the hard drive. If you don't have much free space wherever
it's pointing, change it to point to another hard drive (or else free up
space on your hard drive).

How you do this depends on your OS. Try looking at the System option on the
Control Panel. See if there's a button labelled "Environment Variables" on
the Advanced tab. You can change the value there.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello,

I have problem of low memory again. Running macro loop after aprox. 8000
times a message appears:

There isn't enough memory available to perform this calculation.
Close unneeded programs ...

Macro repeat expression is conditioned (([Forms]![Name]![Control Name]) Is
Not Null. Total num. of records aprox. 24000.
Actions used in macro loop are ordinary :
Openform
SetValue (setting string from another opened form)
RunMacro (another subMacro)
RunCommand (RecordsGoToNext)

Mr. Doug Steele, (Microsoft Access MVP) answered my question (21.june.05)
with same problem. He mentioned TEMP environment variable.
How can I expand memory by TEMP environment variable?