Applying Filter to Form in a Looping Macro Causes Catastrophic Err

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dbguru316 - 21 Dec 2007 00:30 GMT

I have a form that contains order details and I run through a loop that
applies a filter to the form (only view one order at a time), and then
removes the filter, applies a different filter (next order) and then removes
it etc.

After about 300 times, I get a message stating "not enough memory..." This
is fairly consistent and have narrowed it down to being a MS Access issue (as
opposed to a hardware issue). I have reduced the number of times the looping
macro runs to 100, and finishes successfully (without the memory error), but
renders the keyboard useless for changing any MS Access objects, but the
keyboard is functioning if I switch to another applicaition like MS Excel.

When the memory error occurs the macro is halted, and the form is corrupt -
I can no longer access it or view it in design view. Repair and compact
function does not repair the form.

Any ideas on why this is happening?

Reply to this Message

Jeanette Cunningham - 21 Dec 2007 02:04 GMT

Hi,
if you are trying to view the orders to choose an order to edit, then choose
another order to edit, . . .
Another approach that won't involve filter loops is to use a combo to choose
an order to edit.
You could instead use a search form to choose the order you want to edit.
There is a great sample of a search form with all the code on
www.allenbrowne.com
Look for the sample search form.

Jeanette Cunningham

>I have a form that contains order details and I run through a loop that
> applies a filter to the form (only view one order at a time), and then
[quoted text clipped - 18 lines]
>
> Any ideas on why this is happening?

Reply to this Message