Thanks for the advice..
"Shawn K. Hall" <[EMAIL PROTECTED]> wrote:Hi Arnold,
> Below is part of the code that produced the error. I
> did not experience this error in XP and 2000. The
> error only appeares in windows 98.
2k and xp have much better memory management, so that explains why
they work better on those OSes.
>From your code the only significant problem I see is that you're
using the 'New' operator and you are *not* setting the recordsets to
Nothing afterwards.
This is only the Form_Load event, so it's hard to imagine that this
would be a recursion problem. Most likely you have too many controls
on the form or the objects aren't in any form of object array.
You could also manage memory better by using GetRows instead of
maintaining the connection to the recordset.
Lastly, you're assigning a *reference* to the contents of the fields
to the ListView, not the values of each field. Change your
rs("field") assignments to rs("field").value . You'll experience a
significant memory leak when you assign fields directly to a
variant-capable element, which could explain your memory loss.
Regards,
Shawn K. Hall
http://ReliableAnswers.com/
'// ========================================================
And Adam asked, "What's a headache?"
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [EMAIL PROTECTED]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Meet the all-new My Yahoo! � Try it today!
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [EMAIL PROTECTED]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
