Insert Into Statement Troubles

[d9pierce1]

Hi all,
Can someone please assist me with the correct syntax in this statement?

Private Sub cmdCreateAccount_Click()


    DoCmd.SetWarnings False
    DoCmd.RunSQL "INSERT INTO tblAccount (AccountName, AccountTypeID, IsActive, IsBank, IsCreditCard,HasReward, AutoPayEnroled, OnLineAccessID, HasOnLineAccess, OpenBalance, OpenBalanceDate, AccountNumber, RoutingNumber, Memo) " & _
        "VALUES (" '" & AccountName & "'", " & cboAccountTypeID & ", "'" & IsActive & "'", " & IsBank & ", " & IsCreditCard & ", " & HasReward & ", " & AutoPayEnroled & ", " & OpenBalance & ", " & OpenBalanceDate & ", " & AccountNumber & ", " & RoutingNumber & ", " & Memo & ")"
    DoCmd.SetWarnings True
        
End Sub

AccountName is Txt, AccountTypeID is a cbo, IsActive is Chk, IsBlank is Chk, IsCreditCard is Chk, HasReward is Chk, AutoPayEnrolled is Chk, OnLineAccessID is Num, HasOnLineAccess is Chk, OpenBlanace is Currency, OpenBalanceDate is Date, AccountNumber is Txt, RoutingNumber is Txt, and Memo is Long Text!

Thanks
Dave

[SamL]

Seems to me you're missing two values, OnLineAccessID and HasOnLineAccess. Are they necessary?

[d9pierce1]

I see i forgot them, will try that

[d9pierce1]

Still seems to have an error
Runtime 3134
Syntax Error in Insert Into Statement?

Private Sub cmdCreateAccount_Click()
    DoCmd.SetWarnings False
    DoCmd.RunSQL "INSERT INTO tblAccount (AccountName, AccountTypeID, IsActive, IsBank, IsCreditCard,HasReward, AutoPayEnroled, OnLineAccessID, HasOnLineAccess, OpenBalance, OpenBalanceDate, AccountNumber, RoutingNumber, Memo) " & _
        "VALUES (" '" & AccountName & "'", " & cboAccountTypeID & ", " & IsActive & ", " & IsBank & ", " & IsCreditCard & ", " & HasReward & ", " & AutoPayEnroled & ", " & cboInstitution & "," & HasOnLineAccess & "," & OpenBalance & ", " & OpenBalanceDate & ", " & AccountNumber & ", " & RoutingNumber & ", " & Memo & ")"
        
End Sub

[Welshgasman]

Put it all into a string variable an debug.print it.
That will show your errors, and if you still cannot see it post it back here.

[pbaldy]

Also note that date values need to be surrounded by # and simple text values by '. For help on what Welshgasman suggested:

http://www.baldyweb.com/ImmediateWindow.htm

[d9pierce1]

thank you
Appriciate it

[davegri]

See if this fixes the syntax:

 "VALUES ('" & AccountName & "', " & cboAccountTypeID & ", '" & IsActive & "', " & IsBank & ", "

Text delimiter syntax correction for AccountName and IsActive.
If the various Isxxxxxx are text fields (like the letter Y or N), then you need the delimiters; if boolean fields, like True and False, none needed.
In any case, there's inconsistency as you're showing text for IsActive, but not so for all the rest.