Form Access 2003上的高级查找框 [英] Advanced Find Box on Form Access 2003
问题描述
我目前正在尝试在我创建的表单顶部放置一个查找框，以便查看加工方法。我已设置框以显示部件编号字段，并在选中时将您带到该记录，但我想根据我在各种记录中填写的某些条件过滤部件编号的选择。
我想知道如何说出我的SQL / Query语句，只显示与我当时正在查看的部分类似的部分。例如我只想看到具有相同材料类型和形状且具有相同尺寸且具有相同关键绘图功能的零件。
I am currently trying to put a find box at the top of a form I have created for reviewing machining methods. I have setup the box to show the Part Number field and take you to that record when selected, but I want to filter the selection of Part Numbers based on certain criteria that I have filled out on various records.
I want to know how to word my SQL/Query statement to show only parts that are similar to the one I am viewing at that moment in time. e.g. I only want to see parts with the same material type and form that are the same size and have the same critical drawing features.
推荐答案
告诉我是否示例过滤表单可以帮助Sandy。如果没有，我们可以查看更多详细信息并帮助您找到解决方案我确定：）
Tell me if Example Filtering on a Form helps Sandy. If not we can look in more detail and help you find a solution I''m sure :)
感谢帮助NeoPa，
我已经在表单页面上对示例过滤的代码进行了调整，并使其适用于我的大多数字段，但我想通过是/否框以及文本和数字字段进行过滤。我希望过滤的字段总数如下:(这是它将遵循的格式）
FieldName（表格） - FieldName（表格） - 字段类型
VisualDescription - 视觉描述 - 文字（下拉框）
MaterialForm - 材料表格 - 文字（下拉框）
MaterialType - 材料类型 - 文字
尺寸 - 尺寸 - 文字（下拉框）
CriticalPart？ - 关键部分？ - 是/否（布尔值）
SealFins？ - 密封鳍？ - 是/否（布尔值）
跳出？ - 用完？ - 是/否（布尔值）
FaceGrooves？ - 面部凹槽 - 是/否（布尔）
圆度？ - 圆度？ - 是/否（布尔值）
IntGrooves？ - Int Grooves？ - 是/否（布尔值）
同心度？ - 同心度？ - 是/否（布尔值）
ExtGrooves？ - Ext Grooves？ - 是/否（布尔值）
平坦度？ - 平整度？ - 是/否（布尔值）
Splines？ - 样条？ - 是/否（布尔值）
ThinWall？ - 薄壁？ - 是/否（布尔值）
厚墙？ - 厚墙？ - 是/否（布尔值）
我无法弄清楚如何用Filter控件来考虑上面提到的所有字段。
再次感谢，
/ Sandy
Thanks for the Help NeoPa,
I have tweeked the code on the Example Filtering on a form page and got it to work for the majority of my fields, but I want to do filtering by Yes/No boxes as well as text and numeric fields. The total amount of fields I wish to filter by are as below: (This is the format it will follow)
FieldName (Form) - FieldName (Table) - Type of Field
VisualDescription - Visual Description - Text (Drop Down Box)
MaterialForm - Material Form - Text (Drop Down Box)
MaterialType - Material Type - Text
Size - Size - Text (Drop Down Box)
CriticalPart? - Critical Part? - Yes/No (Boolean)
SealFins? - Seal Fins? - Yes/No (Boolean)
Runout? - Runout? - Yes/No (Boolean)
FaceGrooves? - Face Grooves - Yes/No (Boolean)
Roundness? - Roundness? - Yes/No (Boolean)
IntGrooves? - Int Grooves? - Yes/No (Boolean)
Concentricity? - Concentricity? - Yes/No (Boolean)
ExtGrooves? - Ext Grooves? - Yes/No (Boolean)
Flatness? - Flatness? - Yes/No (Boolean)
Splines? - Splines? - Yes/No (Boolean)
ThinWall? - Thin Wall? - Yes/No (Boolean)
ThickWall? - Thick Wall? - Yes/No (Boolean)
I couldn''t work out how I would word the Filter control to take into account all the fields mentioned above.
Thanks Again,
/Sandy
布尔表现与数字项目非常相似。不需要分隔符。但是，将布尔值与其他值进行比较以产生测试是错误的。通常，在将A与B进行比较时，测试旨在生成布尔结果。布尔值不需要这样的测试来产生布尔结果。他们已经是那种形式了。因此，以下是非常明智的：
Booleans behave very similarly to numeric items. No delimiters are required. However, it is misguided to compare boolean values with other values to produce a test. Generally when comparing A with B, the test is designed to produce a boolean result. Booleans need no such test to produce a boolean result. They are already of that form. Hence, the following is perfectly sensible :
这篇关于Form Access 2003上的高级查找框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
