我可以拥有多少个ActiveX控件？堆栈溢出问题...... [英] How many ActiveX controls can I have? Stack overflow problems...
问题描述
过去几周我一直在为我的公司设计一个数据库。
问题是我已经开始遇到我认为的堆栈
溢出问题。表单上有两个选项卡控件（嵌套），
三个列表视图，一个树控件，最多30,000个节点，可能15个
组合框（其中一半有一个大型记录集作为rowsource），20或
所以按钮和大约30个文本框（更不用说图像，
标签等等，以及大约1000行VBA背后的所有内容） ）。
很明显（当我写这篇文章时，它变得更加明显），这是一个很好的堆栈溢出竞争者。 （话虽如此，我写的数据库的旧版本
有树控件和组合框，但是没有遇到任何问题。）/ br / b >
我的问题是，如果我把上面提到的表格分成三个单独的表格，然后将它们全部加载到
$，我会有堆栈溢出吗？ b $ b同时？
打开另一个表单之前我是否必须妥协并关闭每个表单？
另外，我如何评估堆栈的完整程度，以便我能够预期
提前溢出？
任何帮助非常感谢
Jim
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
推荐答案
>我的问题是，如果我将上面的
> My question is, would I have a stack overflow if I split the above
提到的表单分成三个单独的表单，但是它们在
同时加载了，我会有堆栈溢出吗？
吉姆，怎么可能有人回答这个问题？
首先，你还没有提供任何有关你的信息的信息
你得到堆栈溢出错误。是什么消息或其他
条件导致你的信念？
其次，如果你>是<得到堆栈溢出错误，你需要确定这实际上是由于表单的复杂性，而不是编码错误（例如无限递归过程）b $ b电话）。
第三，如果>是<由于你的表单的复杂性，没有人可能说b
表示是否将它分开，会解决问题。也许它会 - 也许
它不会！ AFAIK没有神奇的论坛，有人可以插入
项目数量&得到是/否回答。
我不是不同意你的表格的复杂性导致你的问题（无论他们是什么）。我只是建议你没办法
会得到任何是/否你的问题的答案，因为你现在已经用b / b
表达了它们。
HTH，
TC
Jim < JS ***** @ hotmail.com>在消息中写道
新闻：5c ************************* @ posting.google.co m ...我过去几周我一直在为我的公司设计一个数据库。
问题是我已经开始遇到我认为堆栈溢出问题。表单上有两个选项卡控件（嵌套），三个列表视图，一个树控件，最多30,000个节点，可能有15个组合框（其中一半有大型记录集作为行源），20或
所以按钮和大约30个文本框（更不用说图像，
标签等等，大约1000行VBA背后）。
显然（和我写的一样）这一点，它变得更加明显），这是堆栈溢出的良好竞争者。 （话虽如此，我写的数据库的旧版本有树控件和组合框，但没有遇到任何问题）
我的问题是如果我将上面提到的表格分成三个单独的表格，但是同时将它们全部加载在一起，我会有堆栈溢出吗？在打开另一个表单之前，我是否必须妥协并关闭每个表单？
另外，我如何评估堆栈的完整程度，以便我可以预期溢出时间？
任何帮助都非常感谢
Jim
mentioned form into three separate forms, yet had them all loaded at
the same time?
Jim, how could anyone possibly answer that question?
First, you haven''t given any information on what leads you to believe that
you are getting stack overflow errors. What is the message or other
condition that is leading you to that belief?
Second, if you >are< getting stack overflow errors, you would need to
determine that this is actually due to the complexity of your form, rather
than a coding error (eg. an infinite recursive procedure call).
Third, if it >is< due to the complexity of your form, no-one could possibly
say whether splitting it up, would fix the problem. Maybe it would - maybe
it wouldn''t! AFAIK there is no magic forumla where someone could plug in the
number of items & get a yes/no answer back.
I''m not disagreeing that the complexity of your form is causing your
problems (whatever they are). I''m just suggesting that there is no way you
will get any "yes/no" answers to your questions, as you have currently
phrased them.
HTH,
TC
"Jim" <js*****@hotmail.com> wrote in message
news:5c*************************@posting.google.co m... 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
2004年2月23日11:53:24 -0800， Jim写道：
来自MS知识库文章145799
堆栈是程序用来处理硬件事件的保留内存。当内存中没有足够的空间来运行
硬件中断例程时，会发生
堆栈溢出....
-------------------------------------------------- ------------------------------------------
我真的不知道如何使用
ActiveX控件创建其中一个错误。如果有的话，你会先打破内存不足或页面错误
。
-
Mike Storr
www.veraccess.com
On 23 Feb 2004 11:53:24 -0800, Jim wrote:
From MS KB article 145799
Stacks are reserved memory that programs use to process hardware events. A
stack overflow occurs when there is not enough space in memory to run the
hardware interrupt routines....
--------------------------------------------------------------------------------------------
I really don''t see how you could be creating one of these errors with
ActiveX controls. If anything, you''d hit an Out of Memory, or Page Fault
first.
--
Mike Storr
www.veraccess.com
非常感谢您的回复。我显然不理解堆栈。
有人可以解释他们如何使用Access？我刚刚花了几个小时在网上搜索，然后通过
皮卡迪利马戏团（显然是欧洲最大的书店）和
$一起花在了Waterstones上。 b $ b发现绝对没用。
谢谢
Jim
" TC" < no@email.here>在留言新闻中写道：< 40 ********** @ news.chariot.net.au> ...
Thanks very much for your reply. I clearly don''t understand stacks.
Can someone explain how they work with regards Access? I''ve just spent
several hours trawling the web, and popped down to Waterstones by
Piccadilly Circus (apparently the largest bookstore in Europe) and
found absolutely nothing useful.
Thanks
Jim
"TC" <no@email.here> wrote in message news:<40**********@news.chariot.net.au>...
我的问题是，如果我把上面提到的表格分成三个单独的表格，然后将它们全部加载到
同时，我会有堆栈溢出吗？
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?
Jim，怎么可能有人回答这个问题？
首先，你没有提供任何信息，告诉你是什么导致你相信你的堆栈溢出错误。导致你这种信念的信息或其他条件是什么？
其次，如果你>是<如果出现堆栈溢出错误，则需要确定这实际上是由于表单的复杂性，而不是编码错误（例如，无限递归过程调用）。
<第三，如果它>是<由于表单的复杂性，没有人可能会说是否将其拆分，可以解决问题。也许它会 - 也许
它不会！ AFAIK没有神奇的论坛，有人可以插入物品数量&得到是/否回答。
我并不反对你的表格的复杂性导致你的问题（无论他们是什么）。我只是建议你没有办法得到任何是/否。回答你的问题，正如你现在已经说过的那样。
HTH，
TC
Jim < JS ***** @ hotmail.com>在消息中写道
新闻：5c ************************* @ posting.google.co m ...
Jim, how could anyone possibly answer that question?
First, you haven''t given any information on what leads you to believe that
you are getting stack overflow errors. What is the message or other
condition that is leading you to that belief?
Second, if you >are< getting stack overflow errors, you would need to
determine that this is actually due to the complexity of your form, rather
than a coding error (eg. an infinite recursive procedure call).
Third, if it >is< due to the complexity of your form, no-one could possibly
say whether splitting it up, would fix the problem. Maybe it would - maybe
it wouldn''t! AFAIK there is no magic forumla where someone could plug in the
number of items & get a yes/no answer back.
I''m not disagreeing that the complexity of your form is causing your
problems (whatever they are). I''m just suggesting that there is no way you
will get any "yes/no" answers to your questions, as you have currently
phrased them.
HTH,
TC
"Jim" <js*****@hotmail.com> wrote in message
news:5c*************************@posting.google.co m...
过去几周我一直在为我的公司设计一个数据库。
问题是我已经开始遇到我认为堆栈溢出问题。表单上有两个选项卡控件（嵌套），三个列表视图，一个树控件，最多30,000个节点，可能有15个组合框（其中一半有大型记录集作为行源），20或
所以按钮和大约30个文本框（更不用说图像，
标签等等，大约1000行VBA背后）。
显然（和我写的一样）这一点，它变得更加明显），这是堆栈溢出的良好竞争者。 （话虽如此，我写的数据库的旧版本有树控件和组合框，但没有遇到任何问题）
我的问题是如果我将上面提到的表格分成三个单独的表格，但是同时将它们全部加载在一起，我会有堆栈溢出吗？在打开另一个表单之前，我是否必须妥协并关闭每个表单？
另外，我如何评估堆栈的完整程度，以便我可以预期溢出时间？
任何帮助都非常感谢
Jim
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
这篇关于我可以拥有多少个ActiveX控件？堆栈溢出问题......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
