runtime error 3134

[TheLazyEngineer]

Hey, I'm new here and new to access. I'm trying to set up a simple database for my company that I can keep track of the programs we write, and the customer we write them for, etc...
I'm having this recurring error with my code and I have no idea why it's happening, I have looked at pretty much every resource to no avail.

The error is
"Run-time error '3134':
Syntax error in INSERT INTO statement."

Here is my code, any help would be very appreciated, thanks!
(I attempted to highlight the code that is giving me the error)
---------------------------------------------------------------------------------------
Private Sub cmdAdd_Click()
'add data to table
CurrentDb.Execute "INSERT INTO PROGRAM(programid, programnum, robot, box, options, origrom, date, disk, customer) VALUES (" & Me.txtID & ",'" & Me.txtRobot & "','" & _ Me.txtBox & "'.'" & Me.txtOptions & "'.'" & Me.txtRom & "'.'" & Me.txtDate & _ "'.'" & Me.txtDisk & "'.'" & Me.txtCustomer & "')"
'refresh data in list on form
frmProgramSub.Form.Requery

End Sub

Private Sub cmdClear_Click()
Me.txtNumber = ""
Me.txtRobot
Me.txtBox
Me.txtOptions
Me.txtRom
Me.txtDisk
Me.txtCustomer


Me.txtDate

Me.txtID.SetFocus
End Sub

Private Sub cmdClose_Click()
DoCmd.Close

End Sub

Private Sub txtID_Click()

End Sub
---------------------------------------------------------------------------------------

[pbaldy]

You've got some periods instead of commas, date fields would be surrounded by # rather than '. This should help debug it:

BaldyWeb-Immediate window

[John_G]

Your problem is the field "date" in the field list. "Date" should be considered a reserved word - this is one case where it causes problems in Access (SQL, actually).

There are two solutions - one is to rename the "Date" field in your table to (for example) Program_Date if it is practical to do so; the other option is to use [Date], in square brackets in the value list so Access knows it is a field name.