表格上的复选框 [英] Checkbox on Forms
问题描述
我创建了一个表单，列出了我的
数据库中特定小队的所有玩家。我使用向导创建表单并使用
从sqad查询中填充表单。有用。我的下一阶段是在表单中添加支票
框，以允许用户选择在下一场比赛中将播放的适当玩家，并将选定的玩家发送到形式为
打印。我正面临着两个问题。首先是当我在表单中添加
复选框时，表单中返回的每个玩家都有一个复选框，
是好的。但是当我选择一个复选框时，它会启用所有复选框。
第二个问题是如何让选定的玩家获得报告，这将是b
在玩家名下？任何帮助都会非常好。
赞赏。
谢谢
JW
-
< link removed>
I created a form that lists all the players from a particular squad in my
database. I used the Wizard to create the form and populate the form with
the results from a sqad query. It works. My next phase is to add check
boxes to the form to allow the user to select the appropriate players that
will play in the next game and send the selected players to a form for
printing. I''m facing two issues. The first is that when I added the
checkbox to the form, each player returned in the form has a checkbox, which
is good. But when I select one checkbox it enables all of the checkboxes.
The second issue is how to I get the selected players to a report that will
list them in a column under Player Name? Any help would be greatly
appreciated.
Thanks
JW
--
<link removed>
推荐答案
2006年6月6日星期二14:50:04 GMT，jdub via AccessMonster.com写道：
On Tue, 06 Jun 2006 14:50:04 GMT, jdub via AccessMonster.com wrote:
我创建了一个表单，列出了我的
数据库中特定小队的所有玩家。我使用向导创建表单并使用sqad查询的结果填充表单。有用。我的下一阶段是在表单中添加check
框，以允许用户选择将在下一场比赛中播放的合适玩家，并将选定的玩家发送到表格进行打印。我正面临着两个问题。首先，当我在表单中添加
复选框时，表单中返回的每个玩家都有一个复选框，这很好。但是当我选择一个复选框时，它会启用所有复选框。
第二个问题是如何让选定的玩家获得报告，将其列在玩家名称下的列中？任何帮助都会非常感激。
谢谢
JW
I created a form that lists all the players from a particular squad in my
database. I used the Wizard to create the form and populate the form with
the results from a sqad query. It works. My next phase is to add check
boxes to the form to allow the user to select the appropriate players that
will play in the next game and send the selected players to a form for
printing. I''m facing two issues. The first is that when I added the
checkbox to the form, each player returned in the form has a checkbox, which
is good. But when I select one checkbox it enables all of the checkboxes.
The second issue is how to I get the selected players to a report that will
list them in a column under Player Name? Any help would be greatly
appreciated.
Thanks
JW
您首先需要添加基础表的复选框字段。
然后在表单中添加该复选框字段。
-
Fred
请仅回复此新闻组。
我不回复个人电子邮件
You first need to add a check box field to the underlying table.
Then add that check box field to your form.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
如果您未选中复选框数据字段，然后设置一个设置所有
实例。
首先，你必须为每个玩家绑定一个真/假字段。
其次，您可能不希望在主数据表中使用它，我认为这是用于填充表单的
。如果设置是暂时的（你要设置它，你可以使用它，然后你不在乎）你可能会得到
了用它在主表中。疑。我可能会制作一张桌子来支持
持有玩家主键和真/假字段的列表。通过一个动作
查询，您可以将所有玩家主键值复制到新表中的外键
字段，并将yes / no字段设置为yes，或者不是，
你想要的默认值。
然后，你的显示器将由新表驱动，你可以绑定
你的是/否字段的复选框。
而且......你最终可能想要创建多个列表，所以你
也可以创建一些ListID值并将其放在新表中。
您可以在追加行时动态创建它，或者您可以获得
正式并且有一个ListMaster和ListDetail表对。当你创建一个
新列表时，你在ListMaster中放了一行，得到它的主键，并在ListDetail的新行中使用那个
主键作为foriegn键。
你想要多么精致？
Ifyou checkbox is not bound to a data field, then setting one sets all
instances.
First, you have to have a true/false field you can bind to for each player.
Second, you probably don''t want that in your main data table, which I assume
you''re using to populate your form. If the setting is temporary (you''re
going to set it, use it a bit, and then you don''t care) you can probably get
away with it in the main table. Doubtful. I''d probably make a table to
hold a list of player primary keys and a true/false field. With one action
query you can copy all the player primary key values to the foreign key
field in the new table, and also set the yes/no field to yes, or no,
whichever you prefer for the default.
then, your display, would be driven by the new table, and you could bind
your checkbox to the yes/no field.
And...you''ll probably want to create more than one list eventually, so you
might as well create some ListID value and put that in the new table also.
You can either create it on the fly as you append the rows, or you can get
formal and have a ListMaster and ListDetail table pair. When you create a
new list, you put one row in ListMaster, get its primary key, and use that
primary key as a foriegn key in the new rows in ListDetail.
How elaborate do you want to be?
Rick，
谢谢。我是新手，我想我会听从你的建议。我打算给他们一个镜头。
Jdub
Rick Wannall写道：
Rick,
Thanks. I''m a newbie and think I follow your suggestions. I''m going to give
the a shot.
Jdub
Rick Wannall wrote:
如果你没有将复选框绑定到数据字段，那么设置一个就设置所有
实例。
首先，你必须有一个你可以绑定的真/假字段对于每个玩家。
其次，你可能不希望在你的主数据表中，我认为你用它来填充你的表格。如果设置是暂时的（你要设置它，使用它，然后你不在乎）你可以在主表中使用它。疑。我可能会制作一张桌子来保存玩家主键和真/假场的列表。通过一个动作
查询，您可以将所有玩家主键值复制到新表中的外键
字段，并将yes / no字段设置为yes或no，
无论哪个您更喜欢默认设置。
然后，您的显示器将由新表驱动，您可以将您的复选框绑定到是/否字段。
并且......你最终可能想要创建多个列表，所以你也可以创建一些ListID值并将它放在新表中。
你可以创建它会在你追加行时动态，或者你可以正式获得并具有ListMaster和ListDetail表对。当您创建一个新列表时，在ListMaster中放置一行，获取其主键，并在ListDetail的新行中使用该主键作为foriegn键。
你想要多么精致？
Ifyou checkbox is not bound to a data field, then setting one sets all
instances.
First, you have to have a true/false field you can bind to for each player.
Second, you probably don''t want that in your main data table, which I assume
you''re using to populate your form. If the setting is temporary (you''re
going to set it, use it a bit, and then you don''t care) you can probably get
away with it in the main table. Doubtful. I''d probably make a table to
hold a list of player primary keys and a true/false field. With one action
query you can copy all the player primary key values to the foreign key
field in the new table, and also set the yes/no field to yes, or no,
whichever you prefer for the default.
then, your display, would be driven by the new table, and you could bind
your checkbox to the yes/no field.
And...you''ll probably want to create more than one list eventually, so you
might as well create some ListID value and put that in the new table also.
You can either create it on the fly as you append the rows, or you can get
formal and have a ListMaster and ListDetail table pair. When you create a
new list, you put one row in ListMaster, get its primary key, and use that
primary key as a foriegn key in the new rows in ListDetail.
How elaborate do you want to be?
-
通过 http://www.accessmonster.com
这篇关于表格上的复选框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
