“表达式键入不正确或太复杂”。在报告子表单上。 [英] "Expression typed incorrectly or too complex." on report subform.
问题描述
大家好，
我已经遇到了另一个绊脚石的令人沮丧的沮丧。
请附上我的项目的精简版本，其中包含报告，子表格以及他们所依赖的表格和查询。
开运行报告我收到错误消息：
"这个表达式键入不正确，或者它太复杂而无法评估。例如，数字表达式可能包含太多复杂元素。尝试通过将表达式的一部分分配给变量来简化表达式。
对于tblOrderDetails中的每条记录，消息都会出现一次（表格被裁剪以防止数百个）。其中一个查询包含计算字段，我尝试将这些表达式作为子表单上的计算控件输入，结果相同。
我已检查链接字段的格式。
我的睡眠剥夺了大脑的伤害。建立此发票是它上线之前的最后一个障碍。任何指针都会受到赞赏。
Jay
Hi Guys,
I''ve hit another frustrating braintwister of a stumbling block.
Please find attached a stripped down version of my project containing a report, a subform and the tables and queries they depend on.
On running the report I get the error message:
"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numberic expression may contain too many complicated elements. Try Simplifying the expression by assigning parts of the expression to variables."
The message appears once for each record in tblOrderDetails (tables cropped to prevent hundreds). One of the queries contains calculated fields, I have tried entering these expressions as calculated controls on the sub-form with the same result.
I have checked the formatting of the linked fields.
My sleep deprived brain hurts. Building this invoice is the last hurdle before go it goes live. Any pointers would be appreciated.
Jay
推荐答案
运行查询时会发生什么？？你收到同样的错误吗？或者它成功运行？
What happens when you run the query? Did you receive the same error? Or it runs successfully?
Hi Migi。所有查询运行正常，这让我感到困惑。
查询运行正常，连续形式也是如此，但是当你把两者放在一起时它就会尖叫。这几乎就像链接字段存在问题一样，但是在一个表上它是一个自动编号字段，另一个表格会自动通过输入订单详细信息的条目表单子表单传递。
Hi Migi. All the queries run fine, which is what is puzzling me.
The queries run fine on their own, as does the continuous form, but when you put the two together it squeals. It''s almost as if there is a problem with the linked fields, but on one table it is an autonumber field and on the other it is automatically passed across by the entry form subform on which Order Details are entered.
Jay，
首先检查你的表格。你松了一些 LookUp s参考。
使用对象依赖项工具（功能区 - >数据库工具 - 对象依赖项）来发现问题。
我不能说如果这个可以解决您的问题，但只要您的数据库出现问题，是浪费时间寻找问题的答案。
再次对数据库进行必要的更正后（如果报告仍无效）。
Jay,
First of all review your tables. You loose some "LookUps" references.
Use the Object Dependencies tool (Ribbon -> Database Tools - Object Dependencies) to discover the problems.
I can''t say if this will solve your problem but as long as something is wrong in your database, is a wasted time to look for an answer to your question.
After you make the necessary correction post again the database (if the report still not work).
这篇关于“表达式键入不正确或太复杂”。在报告子表单上。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
