This is my first time working with INSERT INTO, could you please take a look an see what is the problem.

Code:
' Adds The New User

Public Function ADD_NEW_USER(ByVal pUSER_USERNAME As String, _
       ByVal pUSER_PASSWORD As String, _
       ByVal pFULL_NAME As String, _
       ByVal pUSER_ACCESSLEVEL As String, _
       Optional pUSER_EMAILADDRESS As String = "[email protected]", _
       Optional pUSER_URL As String = AUTHOR_HOME_PAGE, _
       Optional pUSER_SMTP_SERVER As String = AUTHOR_SMTP_SERVER) As Boolean
       
   tmpString = ""
   tmpString = "INSERT INTO " & USER_TABLENAME & " (" & _
         "USER_LOGIN_NAME, USER_PASSWORD," & _
         " FULL_NAME, USER_ACCESS_LEVEL," & _
         " USER_EMAIL_ADDDRESS, USER_SMTP_SERVER," & _
         " USER_HOMEPAGE_URL, DATE_ADDED, USER_LOCKED)" & _
         " VALUES (" & _
         "pUSER_USERNAME, pUSER_PASSWORD," & _
         " pFULL_NAME, pUSER_ACCESSLEVEL," & _
         " pUSER_EMAILADDRESS, pUSER_SMTP_SERVER," & _
         " pUSER_URL, #" & Now() & "#, " & False & ")"

         PUBLIC_DATABASE.CONNECTION.Execute tmpString
         DoEvents

End Function


Note:
tmpString is already declared.
PUBLIC_DATABASE.CONNECTION is the Database conection it is open.
USER_TABLENAME stores the name of the table that I want to Update.
DATE_ADDED is a date/time field in the Table

P.S. I'm using ADO

I'm getting this error about too few parameters