[AccessD] SQL statement problem

Can anyone see what is wrong with this statement?
I have a feeling it has to do with quote marks but I have been pulling my
hair out trying to get it,  I guess I just can't see the forrest for the
trees.

strSQLInsert = "insert into tblUserLog([ErrNumber], [ErrDescription],
[ErrDate], [UserName], [ShowUser], [CallingProc]) values "
strSQLInsert = strSQLInsert & "('" & lngErrNumber & "' ,'" &
Left(strErrDescription, 255) & "' ,'" & Now() & "', '" & fcnOSUserName & "',
'" & vShowUser & "', '" & strCallingProc & "')"

This is how it reads when I try and do the insert:
insert into tblUserLog([ErrNumber], [ErrDescription], [ErrDate], [UserName],
[ShowUser], [CallingProc]) values ('2102' ,'The form name 'This Form' is
misspelled or refers to a form that doesn't exist.' ,'5/8/2003 1:28:00 PM',
'nlytle', 'True', 'Form_Open()')

Thanks,
Nancy L