DoCmd.RunSQL Update Help

[xljunkie]

I have a table with 2 columns - VarName and VarValue. I want to update the record where VarName is "ImportFullDate" a text string. The text string is stored in a variable in my VBA code as ImportFullDate.

I'm not sure if my quotes are off or if I have other things in this statement that are off.

DoCmd.RunSQL "UPDATE [tblVariables] SET [VarValue] = ImportFullDate WHERE [tblVariables].[VarName]='" & ImportFullDate & "'"

 

[xljunkie]

I changed it to this and I'm getting a syntax error in number

DoCmd.RunSQL "UPDATE [tblVariables] SET [VarValue] = " & ImportFullDate & " WHERE [tblVariables].[VarName]= 'ImportFullDate'"

The variable ImportFullDate is a text string, yet it's trying to interpret it as a number?

 

[xljunkie]

Got it to work with this:

DoCmd.RunSQL "UPDATE [tblVariables] SET [VarValue] = '" & ImportFullDate & "' WHERE [tblVariables].[VarName]= 'ImportFullDate'"