Salad <oi*@vinegar.comwrote:
: Brian wrote:
:In a database I am developing, I have a listbox with contents that
:change per record that is being displayed. TO do this, the first
:thing I tried is to change the rowsource via SQL in the forms current
:event procedure. This resulted in an error that i haven't seen
:before. It told me that the computer was 'Out of memory' and it would
:not work. I assume it was probably an issue with the list box because
:when I removed it, the error disappeared. Any thoughts?
: Now that you've deleted the listbox, it's hard to say. But that's a
: voodoo SQL. Powerful SQL to go out of memory.
: Maybe you had it set to Value instead of Table/Query. Or who knows what
: you were attempting to stuff into the rowsource. I probably would have
: checked to see what I was attempting to stuff into the rowsource...like
: doing a debug.print on whatever you were stuffing into the listbox prior
: to the stuffing...that way you could check your sql in the query builder.
I have had these 'out of memory' events too, recently.
But after one of these I can no longer reach my form or any of
its code, and since I'm not as certain as the OP as to where my
problem is, I have to go back to the most recent backup, put in
msgboxes everywhere and see whether I can spot anything before doom
sets in. Yesterday I discovered an infinite loop, and one of my
msgboxes was in the middle of it; I had to bring down Windows and
start all over again.
--thelma
from the tame world of Unix and C++, where at least
your code doesn't go into a black hole.
: Gigolo
:
http://www.youtube.com/watch?v=QbXPHiyE7uE