sql server - SQL Command help in VBA MSAccess -
i trying run update query command on form when statements true. updating field variable. have far run sql not seem work , can't figure out why.
any suggestions?
fldval = me.advhours docmd.runsql "update dbo_employees " & _ "set dbo_employees.advhours = '" & _ fldval & "'" & _ "where ((dbo_employees.empid)=" & empid & "));"
extra closing )
- missing space before where
(thats prolly ok)
all parentheses unnecessary, access has fetish them.
docmd.runsql "update dbo_employees " & _ "set dbo_employees.advhours='" & _ fldval & "' " & _ "where dbo_employees.empid=" & empid & ";"
Comments
Post a Comment