访问/ VBA问题 [英] Access/VBA Question
本文介绍了访问/ VBA问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
前端:Access 2010;后端SQL Server 2008
以下产生此错误消息,我不知道原因:运行时错误''3134''INSERT INTO语句中出现语法错误。
Front End: Access 2010; Back End SQL Server 2008
The following produces this error messages and I do not know why: Runtime error ''3134'' Syntax error in INSERT INTO statement.
展开 | 选择 | Wrap | 行号
推荐答案
当您调试Debug.Print时,您得到的结果是什么?这对我们有很大的帮助!
顺便说一下,发帖时请使用代码标签!
When you Debug.Print, what is the result that you get? That will help us greatly!
BTW, please use Code tags when you post Code!
这是我用debug.print得到的:
INSERT INTO [dbo_Notes](partshortages_ID,date,[by],[note])VALUES(16,''6/25/2014'',''SClark'', ''sdbsdfgsdfgsdfgsdfgfdsg'')
This what I get with a debug.print:
INSERT INTO [dbo_Notes] (partshortages_ID, date, [by], [note]) VALUES( 16, ''6/25/2014'', ''SClark'', ''sdbsdfgsdfgsdfgsdfgfdsg'')
sc5502,
我假设[dboNotes]是表格?如果是这样,这不应该在括号内。
您的字段:( partshortages_ID,date,[by],[note])也不应该在括号中。
您的日期可能要求#之前和之后。
所以,这可能会有所帮助:
sc5502,
I am assuming [dboNotes] is the table? If so, this should not be in brackets.
Your fields: (partshortages_ID, date, [by], [note]) also should not be in parentheses.
Your date "may" require "#" before and after it.
So, this might help:
展开 | 选择 | 换行 | 行号
这篇关于访问/ VBA问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文