参数值 [英] Perameter Value

问题描述

我的数据库中有一个表单，它会显示3个框，询问不同的参数值。我没有添加任何这些，并想知道是否有人可以告诉我如何摆脱它们。我不知道什么查询正在创建它们，因为我在任何查询的条件字段中都没有任何内容。任何人都可以提供的任何帮助都将受到赞赏，因为我对这个程序一点也不识字。谢谢

解决方案

在SQL中搜索它要求的值。

因此，如果您将表单绑定到查询，在SQL视图中打开查询并在那里搜索它。


这通常发生在使用不存在的字段时。


例如，如果你有一个带[field]字段的表[tblTable]并且你有一个查询

展开 | 选择 | Wrap | 行号

在设计视图中打开表单。


打开属性窗口和unde在数据选项卡中，表单的记录源是什么。


如果是SELECT语句，请将其粘贴并粘贴到此处。


如果是保存的查询，则在设计视图中打开查询。将视图更改为sql并将其复制并粘贴到此处。


我猜它正在寻找某处的值。

< blockquote class =post_quotes>
在设计视图中打开表单。


打开属性窗口，在数据选项卡下，表单的记录源是什么。


如果是SELECT语句，请将其粘贴并粘贴到此处。


如果是保存的查询，则在设计视图中打开查询。将视图更改为sql并将其复制并粘贴到此处。


我猜它会从某个地方寻找值。

表单上的记录源是一个表，但表中没有它要查找的值。我已经浏览了每个查询，每个报告，每个属性框，但这两个值无处可寻。

I have form in my db that is bringing up 3 boxes asking for different parameter values. I have not added any of these and wonder if anyone can tell me how to get rid of them. I have no idea what query is creating them as I do not have anything in the criteria fields in any of my queries. Any assistance anyone can provide would be appreciated as I am not at all literate with this program. Thank-you

解决方案

Search for the values it asks for within your SQL.
So if you have the form bound to a query, open the query in SQL view and search for it there.

This usually happens when a field is used which doesn''t exist.

For instance, if you have a table [tblTable] with a field [Field] and you have a query

Expand|Select|Wrap|Line Numbers

Open the form in design view.

Open the properties window and under the data tab what is the record source of the form.

If it is a SELECT statement copy and paste it here.

If it is a saved query then open the query in design view. Change the view to sql and copy and paste it here.

I would guess that it''s looking for values from somewhere.

Open the form in design view.

Open the properties window and under the data tab what is the record source of the form.

If it is a SELECT statement copy and paste it here.

If it is a saved query then open the query in design view. Change the view to sql and copy and paste it here.

I would guess that it''s looking for values from somewhere.

The record source on the form is a table, however, the table does not have the values it is looking for. I have gone through every query, every report, every property box but these two values are nowhere to be found.

这篇关于参数值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！