simple sql not so simple

[crich21]

Can someone please help

I am using windows 7 64 bit with Access xp.

I am getting and error 3134 from the following code.

Private Sub Form_AfterInsert()
    Dim strsql As String

   On Error GoTo Form_AfterInsert_Error

    strsql = "INSERT INTO tblOptions (CategoryID, Option)" & _
             " VALUES(" & Chr(34) & "1326836054" & Chr(34) & "," & SQLFormat(Me.Package) & ")"
    
    Debug.Print strsql
'    CurrentDb.Execute strsql, dbFailOnError

   On Error GoTo 0
   Exit Sub

Form_AfterInsert_Error:

    MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure Form_AfterInsert of VBA Document Form_frmPackage"
End Sub

 

[speakers_86]

Create a query that shows the desired results, then view the sql and see what is different.

 

[pbaldy]

This should help you debug the string:

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

 

[crich21]

No idea why, but I had to add brackets around the fieldnames

 

[pbaldy]

Ah, Option is a reserved word so it was likely the culprit. The other one should have been okay. Try to avoid reserved words:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209187

You can work around it with brackets, but it's usually not worth the bother in the long run.