运行时错误'3075' [英] Run-time error '3075'

问题描述

大家好，


我正在尝试将新数据记录插入到表中，但是我遇到了运行时错误。我很感激任何帮助。


这是我的代码：

展开 | 选择 | 换行 | 行号

解决方案

我会说问题出在SQL的.WTG =））部分。在测试的右侧似乎没有值

非常感谢您的输入，


但是当我使用时相同的数组元素WTGNo（i）在一个消息框中，它显示了我想要的值，但我不知道为什么它不被sql查询识别。


另一方面，当我删除WHERE语句的WTG部分时，我收到类似的错误：


运行-time error''3075''：


查询表达式中的语法错误（缺少运算符）''（（PreviousAlarmsInSixHoursforAGiv.timeStampEv）在12:00:00 AM和12:00之间：00 AM））''。


有没有人对此有任何想法？我也很感激任何类型的脑力激荡。

你需要将日期常量放入＃delimiters 。

以及用空WTG数组元素解决这个问题。


问候，

Fish

Hi guys,

I am trying to insert new data records to a table but I am getting a run-time error. I would appreciate any kind of help.

Here is my code:

Expand|Select|Wrap|Line Numbers

解决方案

Off the top of my head I would say that the problem is in the .WTG = )) portion of the SQL. There does not appear to be a value in the right side of the test

Thank you so much for your input,

But when I use the same array element "WTGNo(i)" in a message box, it shows the value I want, but I don''t know why it is not recognized by the sql query.

On the other hand, when I removed the WTG part of the WHERE statement, I get a similar error:

Run-time error ''3075'':

Syntax error (missing operator) in query expression ''(((PreviousAlarmsInSixHoursforAGiv.timeStampEv) Between 12:00:00 AM And 12:00:00 AM))''.

Does any one have any idea about this? I would appreciate any kind of brain storming as well.

You need to put date constant into # delimiters.
As well as solve that issue with empty WTG array element.

Regards,
Fish

这篇关于运行时错误'3075'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！