type mismatch

[BenEl via AccessMonster.com]

Hi. I have a form (parent table) with an unbound text box. When the user hits
the "close" button, whatever is written in the text box is put into the child
table. I am getting a type mismatch error and can't figure out what's wrong!
Can someone have a look at my code?

If EnterCommentText.Value <> "" Then

LInsert = "INSERT INTO [tblCommentsHistory] ([Auto Number],
[EnterComments], [UpdateWho])"
LInsert = LInsert & " VALUES (" & [Task Number] & ", " & Replace
(EnterCommentText.Value, "'", """) & ", " & LoggedUser & ")

db.Execute LInsert, dbFailOnError

Form_frmModifyTask.Refresh

EnterCommentText.Value = ""

DoCmd.Close acForm, "frmModifyTask"
Else
DoCmd.Close acForm, "frmModifyTask"
End If


Thanks!

 

[John Spencer]

Missing text delimiters
Closing ")" is outside quote marks

LInsert = "INSERT INTO [tblCommentsHistory] " & _
"([Auto Number], [EnterComments], [UpdateWho])" & VBCRLF
LInsert = LInsert & " VALUES (" & [Task Number] & ", '" & _
Replace(EnterCommentText.Value, "'", "''") & "', '" & LoggedUser & "' )"

'For trouble shooting add the following line
Debug.Print "LInsert is: " & vbcrlf & LInsert

Now you can check and see if that looks like a well formed SQL statement.

I am guessing that EnterComments is a text or memo field and LoggedUser is a
text field.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[BenEl via AccessMonster.com]

Fabulous! Thanks!

Missing text delimiters
Closing ")" is outside quote marks

LInsert = "INSERT INTO [tblCommentsHistory] " & _
"([Auto Number], [EnterComments], [UpdateWho])" & VBCRLF
LInsert = LInsert & " VALUES (" & [Task Number] & ", '" & _
Replace(EnterCommentText.Value, "'", "''") & "', '" & LoggedUser & "' )"

'For trouble shooting add the following line
Debug.Print "LInsert is: " & vbcrlf & LInsert

Now you can check and see if that looks like a well formed SQL statement.

I am guessing that EnterComments is a text or memo field and LoggedUser is a
text field.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Hi. I have a form (parent table) with an unbound text box. When the user hits
the "close" button, whatever is written in the text box is put into the child

[quoted text clipped - 20 lines]

Thanks!