是否有针对“定义了太多字段”的解决方法 [英] Is there a workaround for "too many fields defined"

问题描述

我有一个标签式表单，其中包含12个不同的页面。当我尝试

并运行表单时，我收到错误消息，定义了太多字段---

我相信是记录源中的255字段限制。


我想知道，如果我打破页面以包含

子表单...是包含在子表单中的字段数添加到

主窗体的字段限制???


是否有其他方法可以解决此错误消息???

我将表格页面放在选项卡式控件上，以便在添加和编辑阶段保持表格

同步。

I have a tabbed form that contains 12 different "pages" and when I try
and run the form I get the error message too many fields defined ---
which I believe is the 255 field limit in the record source.

I was wondering, that if I were to break the pages down to include
subforms... is the number of fields contained in the subforms added to
the field limit for the main form ???

Is there some other way to work around this error message ???

I am putting the pages of forms on a tabbed control to keep the form
syncronized during the add and edit phases.

推荐答案

表格或查询中最多可包含255个字段，表单上最多可包含700多个

控件。子窗体计为主窗体上的一个控件，

可以有自己的控件和RecordSource（所以字段。）


但是，一个设计良好的表很少超过50个领域。如果你有数百美元的b $ b，你很有可能设计出一些看起来像电子表格的东西，即它不是关系型的。


如果你有任何重复的字段，一个死的赠品 - 序列如：

Week1，Week2，...

Employee1，Employee2 ,. ..

星期一，星期二......

FirstQuarter，SecondQuarter，...

Item1，Item2，...

每当你看到这种事情时，它总是意味着你需要创建一个包含大量记录的

相关表，而不是在你的
$ b $中有很多字段b table。


Access中的表分析器可能会给你一些建议：

工具|分析|表


要了解有关此内容的更多信息，请搜索规范化。这里有一些链接：
http：/ /home.bendbroadband.com/conrad...abaseDesign101

-

Allen Browne - 微软MVP。西澳大利亚珀斯

访问用户提示 - http：// allenbrowne .com / tips.html

回复群组，而不是mvps dot org的allenbrowne。


" MG Henry" < mr ************* @ hotmail.comwrote in message

news：11 ***************** *****@f1g2000cwa.googlegro ups.com ...

You can have up to 255 fields in a table or query, and up to 700-odd
controls on a form. A subform counts as one control on the main form, and
can have its own controls and RecordSource (so fields.)

However, a well designed table rarely has more than 50 fields. If you have
hundreds, there''s a very high chance that you are designing something that
looks like a spreadsheet, i.e. it is not relational.

One dead giveaway is if you have any repeating fields - sequences such as:
Week1, Week2, ...
Employee1, Employee2, ...
Monday, Tuesday, ...
FirstQuarter, SecondQuarter, ...
Item1, Item2, ...
Whenever you see this kind of thing, it always means you need to create a
related table with lots of records instead of having lots of fields in your
table.

The table analyzer in Access may be able to give you some suggestions:
Tools | Analyze | Table

To learn more about this, search on "normalization." Here''s some links:
http://home.bendbroadband.com/conrad...abaseDesign101

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"M G Henry" <mr*************@hotmail.comwrote in message
news:11**********************@f1g2000cwa.googlegro ups.com...

>我有一个包含12个不同页面的标签表单。当我尝试

并运行表单时，我收到错误消息，定义了太多字段---

我相信是记录源中的255字段限制。


我想知道，如果我打破页面以包含

子表单...是包含在子表单中的字段数添加到

主窗体的字段限制???


是否有其他方法可以解决此错误消息???

我将表单页面放在选项卡式控件上，以便在添加和编辑阶段保持表单

同步。

>I have a tabbed form that contains 12 different "pages" and when I try
and run the form I get the error message too many fields defined ---
which I believe is the 255 field limit in the record source.

I was wondering, that if I were to break the pages down to include
subforms... is the number of fields contained in the subforms added to
the field limit for the main form ???

Is there some other way to work around this error message ???

I am putting the pages of forms on a tabbed control to keep the form
syncronized during the add and edit phases.

当然等待这种形式的等待会驱使你香蕉！

要回答你的问题，嵌套子表格似乎会给你

无限量的控件存在，但控制限制是

出于性能原因，最好不要试图规避它。


逻辑上更好地分离你的数据更有意义了，你不能忘记Access Forms和一个窗口应用程序是非

完全可以互换。一个表单以一种有意义的方式呈现一组数据

...你填写的越多，它就越有意义。

变为。


你可能在一个行业中你处理各种各样的b $ b变量（比如我），如果是这种情况，则规范化不是

总是答案。出于演示目的，

数据的逻辑分离是合适的。


如果你能详细说明你的情况，我可能会指出你

更具体的方向。


祝你好运！

-Mal W


MG Henry写道：

Surely the wait with a form of this magnitude would drive you bananas!
To answer your question, nesting subforms will seemingly give you
endless amounts of controls to have present but the control limit is
there for performance reasons, it''s best not to try to circumvent it.

It would make more sense to logically separate your data better, you
can''t forget that Access Forms and a windowed application are non
completely interchangeable. A form is made to present one set of data
in a meaningful way...the more you pile in, the less meaningful it
becomes.

You may be in an industry where you deal with an enormous variety of
variables (such as I do) and if this is the case normalisation is not
always the answer. For presentation purposes, logical separation of the
data is appropriate.

If you can give more specifics of your case I could probably point you
in a more specific direction.

Good luck!
-Mal W

M G Henry wrote:

我有一个包含12个不同页面的标签表格。当我尝试

并运行表单时，我收到错误消息，定义了太多字段---

我相信是记录源中的255字段限制。


我想知道，如果我打破页面以包含

子表单...是包含在子表单中的字段数添加到

主窗体的字段限制???


是否有其他方法可以解决此错误消息???

我将表单页面放在选项卡式控件上，以便在添加和编辑阶段保持表单

同步。

I have a tabbed form that contains 12 different "pages" and when I try
and run the form I get the error message too many fields defined ---
which I believe is the 255 field limit in the record source.

I was wondering, that if I were to break the pages down to include
subforms... is the number of fields contained in the subforms added to
the field limit for the main form ???

Is there some other way to work around this error message ???

I am putting the pages of forms on a tabbed control to keep the form
syncronized during the add and edit phases.

Allen Browne写道：

Allen Browne wrote:

表中最多可包含255个字段或查询，以及表单上多达700多个

控件。子窗体计为主窗体上的一个控件，

可以有自己的控件和RecordSource（所以字段。）


但是，一个设计良好的表很少超过50个领域。如果你有数百美元的b $ b，你很有可能设计出一些看起来像电子表格的东西，即它不是关系型的。

You can have up to 255 fields in a table or query, and up to 700-odd
controls on a form. A subform counts as one control on the main form, and
can have its own controls and RecordSource (so fields.)

However, a well designed table rarely has more than 50 fields. If you have
hundreds, there''s a very high chance that you are designing something that
looks like a spreadsheet, i.e. it is not relational.

我使用的结构具有基于

表格的单个页面，有时只有10到15个字段，但不超过

60左右的字段...


我遇到的问题是选项卡

控件的记录源必须有我声明所有表格的字段名称

链接到所有页面，所以我的字段总数超过255（不是很多b $ b）。我在我的设计中使用了一些子表单，所以我现在将

将更复杂的表单分解为更多子表单以获取我的

下面的记录源字段总数255限制。


我只能想象在

表单中分层子表单会产生性能问题，但是，这个应用程序会

被少数用户使用，我希望不会因为严重的性能问题而结束。


我很欣赏您的意见和调查您的链接

给我作为进一步的信息来源。

The structure that I am using has the individual pages based upon
tables that have sometimes as few as 10 to 15 fields, but no more than
60 or so fields...

The problem I am running into is that the record source for the tabbed
control has to have me declare the field names for all the tables
linked to all the pages, so my total number of fields exceeds 255 ( not
by much ). I have used some subforms in my design and so I now will
break down the more complicated forms into more subforms to get my
total number of fields on the record source below the 255 limit.

I can only imagine that the layering of the subforms inside of the
forms, would create performance issues, however, this application will
be used by a small number of users and I hope will not end up with
severe performance issues.

I do appreciate your input and will investigate the links you have
given me as a further resource of information.

这篇关于是否有针对“定义了太多字段”的解决方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！