使用N / A创建表单,OK&不行的复选框? [英] Create a Form with N/A, OK & Not OK check boxes?
问题描述
大家好,
我们是一家小型车队的机械师。我们每季度对大学车辆进行基本维护。
我试图用Access数据库更新过时的手动系统,而且进展顺利。
我们每天所做的一件事就是对进来的车辆进行基本检查。到目前为止,我们一直在使用一个简单的表格并手动填写。当然每个人都抱怨他们不能阅读我们的写作,所以我复制了Access中的表格(或者我认为),所以我们可以输入我们的笔记。
你看,表格我们现在使用它有一个项目列表。每个旁边都有三个复选框; N / A,OK&不好。当我制作简单的表格时,我只在每个表格旁边放一个复选框 - 好的。
当我向老板展示我创建的表格时,他不喜欢它是不同的。
所以我在这里,询问是否可以创建(或调整)表单,使其在每个项目旁边有三个选项复选框,以及类似的报告打印出来(注意:我知道如何使用这些单词,但每个都有3个复选框,我被卡住了。)
任何帮助将不胜感激!
**我附上了现在布局的表格截图。
Hello all,
We are mechanics in a small fleet shop. We perform basic maintenance on the Universities vehicles on a quarterly basis.
I am attempting to update an outdated manual system with an Access database, and it is going quite well.
One of the things we do everyday is perform a basic inspection on vehicles that come in. To this point we have been using a simple form and filling it in manually. Of course everyone complains that they can not read our writing, so I duplicated the form in Access (or so I thought) so we could type in our notes.
You see, the form we use now has a list of items on it. Next to each one are three check boxes; N/A, OK & Not OK. When I made my simple form I only put one check box next to each one - OK.
When I showed my boss the form that I created, he didn''t like that it is different.
So here I am, asking if it is possible to create (or adjust) the form so it has the three option check boxes next to each item, and a similar report to print out (NOTE: I know how to do this using the words, but having 3 check boxes for each is where I am getting stuck).
Any help would be greatly appreciated!
**I attached a screenshot of the form as it is laid out now.
推荐答案
您可以使用选项组并将选择存储为数字。
You can use an option group and store the selection as a number.
选项组肯定会有效,但在如此忙碌的表格中会有些笨拙,需要更多的表格真实-estate(请记住,当你最初发布时,Rabbit无法轻易看到表单。)
Access还提供了3路 CheckBox 。它支持的值是Null;虚假&真正。我认为设置 CheckBox es的 TripleState 属性可以使其正常工作。空==> N / A;错误==>不好;真==>好的。
如果这不是一个可接受的解决方案,那么其中包含三个值的ComboBox将是另一种解决方案。这比 CheckBox 占用更多空间,但具有明确适用于所有用户的优势。
Option Groups would certainly work, but would be somewhat clumsy in such a busy Form and require quite a bit more Form real-estate (Bear in mind Rabbit was unable to see the form easily when you posted it originally).
Access also provides the option of a 3-way CheckBox. The values it supports are Null; False & True. I would imagine that setting the TripleState property of your CheckBoxes would enable this to work. Null ==> N/A; False ==> Not OK; True ==> OK.
If that is not an acceptable solution then a ComboBox with the three values in it would be an alternative solution. This takes more space than a CheckBox, but has the advantage of being explicit for all users.
@Neo,我认为这里的问题是老板想要的它看起来与旧纸张形式完全相同,其中每个选项都有3个复选框。
@Neo, I think the issue here is that the boss wants it to look exactly like the old paper form in which every option has 3 checkboxes.
这篇关于使用N / A创建表单,OK&不行的复选框?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!