大侠们,求助

lzh_computer · 发表于 2015-10-29 14:32

CurrentDb.Execute ("insert into Participation_list(TNo,Name) values(tno1 & "," & '" & username & '" & ")" & ")
各位大侠,帮忙看看,这个语句就是一直抱错,谁能给给建议
谢谢

dl0506 · 发表于 2015-10-29 14:56

CurrentDb.Execute ("insert into Participation_list(TNo,Name) values(tno1," & username & ")") 试试？
只有username是变量么？

lzh_computer · 发表于 2015-10-29 15:14

dl0506 发表于 2015-10-29 14:56
CurrentDb.Execute ("insert into Participation_list(TNo,Name) values(tno1," & username & ")") 试试？
...

tno1是数字类型的,username是字符类型的,
现在运行抱错:Too fee parameters.Expected 2.

lzh_computer · 发表于 2015-10-29 15:15

本帖最后由 lzh_computer 于 2015-10-29 15:19 编辑

dl0506 发表于 2015-10-29 14:56
CurrentDb.Execute ("insert into Participation_list(TNo,Name) values(tno1," & username & ")") 试试？
...

tno1,username都是变量
tno1是数字类型的,username是字符类型的,
现在运行抱错:Too few parameters.Expected 2.
大侠,可有办法

dl0506 · 发表于 2015-10-29 15:21

CurrentDb.Execute ("insert into Participation_list(TNo,Name) values(” & tno1 & "," & username & ")")

试试这样吧，只是这样感觉的。

lzh_computer · 发表于 2015-10-29 15:27

dl0506 发表于 2015-10-29 15:21
CurrentDb.Execute ("insert into Participation_list(TNo,Name) values(” & tno1 & "," & username & ")" ...

哈哈,这次报其他错误了
Too few parameters. Expected 1.

dl0506 · 发表于 2015-10-29 15:34

lzh_computer 发表于 2015-10-29 15:27
哈哈,这次报其他错误了
Too few parameters. Expected 1.

传个附件看看吧

lzh_computer · 发表于 2015-10-29 15:55

CurrentDb.Execute ("insert into Participation_list(TNo,Name) values(" & cm1 & ",'" & username & "')")
改了一下,终于对了,加了个变量过渡一下那个公共变量

		自动登录	找回密码
密码			免费注册

[求助] 大侠们,求助