Mungkin sbb:
    
DoCmd.RunSQL "INSERT INTO TblLogHistory ( [User], [LogTime], [Note] )" _
    & " SELECT '" & strUser & "' AS [User], Now() AS [Log Time], '" &
strPesan & "' AS [Note];"

Salam, MBA

Kirim email ke