Access 2002 program error

[Chris Hadjiloucas]

We are using Access 2002 SP3.

While executing a VB routine (loop) to email reports to
various receipients, the loop finishes and the following
error appears:

"There isn't enough free memory to update the display.
Close unneeded programs and try again."

This error occurs even after closing down all other
applications.


Regards

Chris

 

[Peter Martin]

One final word on this. In XP (on XP), the OutputTo action seems to be the culprit - when a report section is cancelled (in onformat or onprint) the subject error occurs. Due to more limitations with subreports (can't change a recordsource of a subreport...) the only way around this seems to be to stop the records ever getting into the report. I've done this (for DAO) with a public function in the query criteria, but it is a limitation still. OutputTo is buggy in other ways - hope it gets fixed.