自定义库存模板中的过滤器以使用用户输入的值 [英] Customize Filter in Inventory Template to use a value input by user

问题描述

我正在尝试使用清单模板中的过滤器创建过滤器。我已将库存模板附加为.zip以供参考。


有一个（过滤器详细信息）表单，它使用（过滤器）表作为其记录源。该表由一个（过滤字符串）字段组成，其中包含以下内容：


（Inventory Extended）是一个QUERY，其中包含一个（Category）字段，它是一个组合包含（1）类别的框（值列表）;" 2）类别";" 3）类别"）


过滤字符串如下所示：

展开 | 选择 | Wrap | 行号

解决方案

当您将两个括号（[]）项目与点（。）连接在一起时，它假定您是指一个accessibl可访问表中的e字段。如果你想提示用户，你应该明白括号内没有任何接近点的东西（不能被SQL识别）会触发提示过程。


所以：

展开 | 选择 | Wrap | 行号

所以它应该是这样的：

展开 | 选择 | Wrap | 行号

我''我害怕我不清楚你想要什么。你的问题里面有很多的话，但是我并没有太多意义。您所拥有的只是提示用户在括号之间添加文本。如果那是你的终极目标，那么它就会做到。如果没有，那就不行了。如果你试图将它链接到某个地方，并提示用户提供数据，那么我不知道你的想法是怎么回事，但它不会做那样的事情。

I am trying to create a filter using the Filter that is found in an Inventory Template. I have attached the Inventory Template as a .zip for reference.

There is a (Filter Details) form which uses the (Filters) table as its Record Source. The table consists of a (Filter String) field, which contains something like the following:

(Inventory Extended) is a QUERY here, which contains a (Category) Field which is a combo box (value list) containing ("1) Category";"2) Category";"3) Category")

Filter String looks like the following:

Expand|Select|Wrap|Line Numbers

解决方案

When you connect two bracketed ([]) items together with a dot (.) it assumes you are referring to an accessible field in an accessible table. If you want to prompt the user you should understand that anything contained within brackets (without a proximate dot) which is not recognised by SQL will trigger the prompting process.

So :

Expand|Select|Wrap|Line Numbers

So should it be something like this:

Expand|Select|Wrap|Line Numbers

I''m afraid I''m not very clear on what you want. Your question has a lot of words in it, but doesn''t make too much sense that I could fathom. What you have will simply prompt the user with the text between the brackets. If that''s your ultimate aim, then it will do that. If not, then it won''t. If you''re trying to link this into a field somewhere, as well as prompt the user to provide the data then I have no idea what''s going on with your thinking, but it won''t do anything like that.

这篇关于自定义库存模板中的过滤器以使用用户输入的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！