标准表格 [英] Criteria Form
本文介绍了标准表格的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个带有2个组合框的表单。我想选择信息并运行报告。我在查询中添加条件时得到的错误是Microsoft Jet数据库无法识别[Forms]![OPCriteria]![Combo8]"作为有效的字段名称或表达。我试图只做[县]并让它提示我,但我仍然得到相同的错误,只有微软Jet数据库无法识别[县]"作为有效的字段名称或表达式
I have a form with 2 combo boxes on them. I want to pick info and run the report. the error I get when I put criteria in the query is "The Microsoft Jet Database does not recognize "[Forms]![OPCriteria]![Combo8]" as a valid field name or expression". I tried to do just [county] and have it prompt me but I still get the same error only that "The Microsoft Jet Database does not recognize "[county]" as a valid field name or expression"
推荐答案
无法分辨图片中的内容。你可以从SQL视图发布文本吗?
Can''t tell what''s going on in the pic. Can you post the text from the SQL view?
展开 | 选择 | Wrap | 行号
也许有经验的交叉表查询可以提供一些见解。我唯一能看到的是带有组合的表单需要打开才能运行查询,但我认为如果不是这样会导致不同的错误消息。
Maybe someone experienced with crosstab queries can provide some insight. The only thing I can see is that the form with the combo on it needs to be open to run the query, but I think that would cause a different error message if it were not.
这篇关于标准表格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文