大家好!我是个新手,关于INSERT INTO语法错误请帮忙检查一下,如下:

'保存客户资料
STemp = "INSERT INTO 客户资料"
STemp = STemp & "(客户ID,公司名称,公司地址,客户姓名,客户职务,"
STemp = STemp & "电话,传真,手机,EMAIL,备注)"
STemp = STemp & "VALUES(" ' & Me![客户ID] & " '," ' & Me![公司名称] & "',"
STemp = STemp & "" ' & Me![公司地址] & "',"' & Me![客户姓名] & "',"
STemp = STemp & "" ' & Me![客户职务] & "',"' & Me![电话] & "',"
STemp = STemp & "" ' & Me![传真] & "',"' & Me![手机] & "',"
STemp = STemp & "" ' & Me![EMAIL] & "',"' & Me![备注] & "')"
'使用DoCmd对象的RunSQL方法执行查询
DoCmd.RunSQL STemp


以上,请大家多指教,谢谢.

你获取STemp的值看看。....单引号的和双引号乱了...???!!

OK,我试试，请教，那单引号和双引号应该如何来修改呢

STemp = "INSERT INTO 客户资料"
STemp = STemp & "(客户ID,公司名称,公司地址,客户姓名,客户职务,"
STemp = STemp & "电话,传真,手机,EMAIL,备注)"
STemp = STemp & "VALUES('" & Me![客户ID] & " ','" & Me![公司名称] & "',"
STemp = STemp & "'" & Me![公司地址] & "','" & Me![客户姓名] & "',"
STemp = STemp & "'" & Me![客户职务] & "','" & Me![电话] & "',"
STemp = STemp & "'" & Me![传真] & "','" & Me![手机] & "',"
STemp = STemp & "'" & Me![EMAIL] & "','" & Me![备注] & "')"

Thank you

唉,真是郁闷,引号问题解决了,另一个问题又出来了

新数据输入后保存时又出现错误提示,提示是:

[表'客户资料'已经被别的用户已独占方式打开,或它已经被其它的用户在用户界面打工,且不能被程序处理]

我怀疑是否与客户资料 子窗体有关,因为客户资料 子窗体本身有内容,但在窗体里面没显示,(有时则每页只显示

一条记录,不在同一页)

请问是否是这样呢,如果是,又如何解决这一问题呢

独占方式在你打开文件的时候用，当你打开文件的时候，你要选择是用什么方式打开