Re: How many ActiveX controls can I have? Stack overflow problems...

From: RSGinCA (rsginca_at_aol.com.NO.Spam)
Date: 02/25/04 

Date: 25 Feb 2004 07:06:32 GMT

BTW, I'd be very suspicious of your tree control (especially with 30,000
nodes). I'd bet that you have a recurcive call there in order to populate the
tree... that's one of the main causes of "out of stack" conditions.

Rick

>Subject: Re: How many ActiveX controls can I have? Stack overflow problems...
>From: rsginca@aol.com.NO.Spam (RSGinCA)
>Date: 2/24/2004 10:11 PM Pacific Standard Time
>Message-id: <20040225011103.20278.00000349@mb-m27.aol.com>
>
>
>Why don't you take a look at this:
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/
>html/minimizingstackusage.asp
>
>This was written for Office/Access 97, but the concepts will most likely be
>the
>same. It might give you some things to consider.
>
>Problems seem to be things like too many local strings (strings defined
>within
>functiions) and/or the way those local strings are defined, too many
>functions
>calling functions calling functions... or functions calling themselves,
>
>If you don't understand what it's talking about then post back again.
>
>Rick
>
>
>
>>Subject: How many ActiveX controls can I have? Stack overflow problems...
>>From: jshentz@hotmail.com (Jim)
>>Date: 2/23/2004 11:53 AM Pacific Standard Time
>>Message-id: <5c59f085.0402231153.63fb059@posting.google.com>
>>
>>I have spent the past few weeks designing a database for my company.
>>The problem is I have started running into what I believe are stack
>>overflow problems. There are two tab controls on the form (nested),
>>three list views, one tree control with up to 30,000 nodes, maybe 15
>>comboboxes (half of which have a large recordset as rowsource), 20 or
>>so buttons and around 30 text boxes (not to mention the images,
>>labels, etc and around 1000 lines of VBA behind it all).
>>
>>Clearly (and as I write this, it becomes more apparent), this is a
>>good contender for stack overflow. (Having said that, the old version
>>of the database I wrote had the tree control and combo boxes, yet
>>didn't run into any problems)
>>
>>My question is, would I have a stack overflow if I split the above
>>mentioned form into three separate forms, yet had them all loaded at
>>the same time? Would I have to compromise and close each form before
>>opening another?
>>
>>Also, how can I assess how full the stack is, so that I can anticipate
>>an overflow ahead of time?
>>
>>Any help greatly appreciated
>>Jim
>>