我正在尝试使用inputbox更新我的表(引用)字段名称(引用日期)类型要更新的日期,其中用户通过输入框传递数字,然后将此数字传递到引用日期,以给我日期+2天的结果。(示例: inputbox 2天,20-12-2020相加2天结果是22-12-2020)我得到的错误( update语句中的语法错误)我的访问版本是2013
我的代码如下:
Dim S As Integer
S = InputBox(" How many days to follow", "Number of Days !")
DoCmd.RunSQL "UPDATE Referral" & _
"SET referdate = referdate" & Me.referdate + S & _
"where SRSno = " & Me.SRSno
Me.Refresh发布于 2020-12-23 01:28:52
根据文档(https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/update-statement-microsoft-access-sql),您的语句可能包含与局部变量连接的现有列值。试试这个:
DoCmd.RunSQL "UPDATE Referral" & _
"SET referdate = " & Me.referdate + S & _
"where SRSno = " & Me.SRSno差别很小,但Microsoft示例显示了将一个值作为查询表达式的一部分添加到现有列值中:
SET OrderAmount = OrderAmount * 1.1,
适用于您的情况的替代语法可能是:
DoCmd.RunSQL "UPDATE Referral" & _
"SET referdate = referdate + " & S & _
"where SRSno = " & Me.SRSno在这两种情况下,请注意referdate在语句中只出现一次。
发布于 2020-12-24 01:22:34
包括DateAdd,并且不要忘记空格:
If Val(S) > 0 Then
DoCmd.RunSQL "UPDATE Referral " & _
"SET referdate = DateAdd('d', " & Val(S) & ", referdata) " & _
"WHERE SRSno = " & Me.SRSno & ""
End Ifhttps://stackoverflow.com/questions/65409542
复制相似问题