如何在连续子表单中使用未绑定复选框 - MS Access 2013 [英] How to use unbound checkbox in a Continuous Subform - MS Access 2013

问题描述

我是 Access 的新手，很难弄清楚它的每一点.现在我想要一个包含从查询中获取的行和每行的复选框的网格.这是我想要的:

I'm fairly new to Access and having a really hard time figuring out each and every bit of it. Now I want to have a grid containing rows fetched from a query and a checkbox for every row. Here's what I want:

1. 用户应该能够选择单个复选框来选择行.
2. 用于选择所有行的全选"复选框.
3. 只有在点击按钮时，行才必须更新

我有

1. 创建了一个表单.
2. 添加了一个连续子表单，并且行源有一个绑定到是/否字段的复选框.

我被困在这一点上.请参考所附图片并帮助我解决这个问题.请推荐一些带有实际例子的好教程.非常感谢.

I'm stuck at this point. Please refer to the attached image and help me figure this out. Please suggest some good tutorials with practical examples. Thanks a lot.

推荐答案

使用 SelectRecordsV2.下载数据库中有示例，但是评论是德语语言(如果需要，我可以翻译).如果您需要在表单中实现此建议，请显示 form.name、表单记录源和详细信息部分的控件名称(您需要一个具有唯一值的控件来将复选框分配给记录，可以不可见).

Use the clsCCRecordSelectclass from SelectRecordsV2. There are samples in the download db, but comments are in german lang (I can translate if needed). If you need advice in implementing this to your form show form.name, form recordsource and control names of detail section (you need one control with unique values to assing the checkboxes to a record, can be invisible).

这篇关于如何在连续子表单中使用未绑定复选框 - MS Access 2013的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！