MS ACCESS 2007查询向您显示参数值对话框 [英] MS ACCESS 2007 queries that present you with a parameter value dialogue box

问题描述

我在Access 2007中设计了一个查询。我在相关字段的条件行中使用了哪些措辞，以便向用户显示一个对话框，告诉他需要在查询之前输入参数跑？我希望我的查询设计得像这样，因为在设计查询时用户不是技术娴熟。有问题的字段标记为注释。

I have designed a query in Access 2007. What verbiage do I use in the criteria row of the field in question in order to have the user presented with a dialogue box that tells him that he needs to enter a parameter before the query is run? I want my query designed like such because the users are not tech-savy when it comes to designing a query. The field in question is labelled as "comment".

推荐答案

括号内的任何文本 - [] - 与有效参考不匹配将是被视为来自操作员的值的提示。

Any text within brackets - [] - which doesn''t match up to a valid reference will be treated as a prompt for a value from the operator.

我知道括号，但它不起作用。我正在尝试查询具有乳胶的产品，例如，在其中。因为乳胶是指出现在一个带有其他单词的字段中，全部用逗号分隔，我放入我的框[输入*评论*]。我尝试了不同的版本，没有任何作用。

I know about the brackets, but it doesn''t work. I''m trying to query products that have latex, for example, in them. Because "latex" appears in a field with other words, all separated by a comma, I put in my box [enter *comment*]. I''ve tried different versions and nothing works.

那么，为什么你没有问这个问题 - 而不是你问过的问题。我已经正确地回答了你的问题 - 这个问题的正确问题（如果这对你不起作用那么你根本就没有正确使用它）。


如果你想要的话过滤一个名为[Comments]的字段，使其找到字段包含要提示的值的记录，然后您需要以下内容：

So, why didn''t you ask that question - instead of the one you did ask. I answered your question - the question for this thread - correctly already (If that doesn''t work for you then you''re simply not using it correctly).

If you want to filter a field called [Comments] such that it finds records where the field contains the value that you want to prompt for, then you would need something like :

展开 | 选择 | Wrap | 行号

这篇关于MS ACCESS 2007查询向您显示参数值对话框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！