First start by changing this line
"'" & Me.txtsg.Text & "'" & _
and adding a ',' to them
"'" & Me.txtsg.Text & "'," & _
Now see what happens.
You might want to change your code so that you are consistent in how you add the ' and , to the statement. The way it is now is very hard to read.
Also you might want to look into to
parameterized queries[
^].
And as a final note do not store date as a string but use the
datetime type[
^].