SQL 语句提示类型出错

yuk_yu 发布于 2014-05-30 17:13， 457 次点击

我反复调试了怎么总出错？

me.text1(0)=05/31/2014
me.text1(0)="1,1,1,0,1,0,0,1"
UserID = 123
SQL = " Update Usermanagement set 有效期 = # " + me.text1(0) "# ，" + " 权限 = '" + me.text1(1) + " ' where ID = " + UserID

1 回复

yuk_yu2014-05-30 17:35

回复楼主 yuk_yu

已解决：

SQL = "Update Usermanagement set FunctionAuthotized = '" + Auth + "', " + "[Validperiod] = # " + Me.Text1(3) + "# where ID = " & SelectID

谢谢大家！！