SQL Update
Set adoRs = adoCon.Execute("UPDATE shortagedata SET [Yes_Or_No] = '" & xx & "', [Material_Infromation] = Now() & '" & Me.Inf(6).Text & "' where PN = '" & Me.TVW.SelectedItem & "' and IA = '" & Me.Combo1.Text & "'")Set adoRs = adoCon.Execute("UPDATE shortagedata SET [Yes_Or_No] = '" & xx & "' where PN = '" & Me.TVW.SelectedItem & "' and IA = '" & & "'") 没有问题,加了这个[Material_Infromation] = Now() & '" & Me.Inf(6).Text & "' 就不知道代码错在哪?
[ 本帖最后由 yuk_yu 于 2010-8-3 17:16 编辑 ]
