Insert DTPicker in Access DB

[Nosrej]

Masters, please help me with my DTPicker.. I want it to be saved in my db (access). But it always says: "Syntax Error in Insert Into Statement"

And this is my code:

Dim statement1 As String
Dim conn1 As ADODB.Connection

Set conn1 = New ADODB.Connection
conn1.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\DB.mdb"
conn1.Open

statement1 = "INSERT INTO tblDPSR (Date) VALUES (' " & Me.DTPicker1.value & " ' )"

conn1.Execute statement1, , adCmdText




..and my Date in Access is Date/Time

[thelionheart]

you may try this one:

statement1 = "INSERT INTO tblDPSR (Date) VALUES (' " & DateValue(DTPicker1.Value) & " ' )"

conn1.Execute statement1, , adCmdText