I have an Access 200 database with a field set up as Date/Time and it is not required. When I go to insert something into the table, if there is not a date in that field, it gives me the error:

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

Here is the page code that inserts this info:
<%
'Set the response buffer to true as we maybe redirecting
Response.Buffer = True

Dim strNotes
strNotes = Replace(Request.Form("Notes"), "'", "''")
If Trim(Request.Form("MembershipDate")) = "" Then
strMembershipDate = "ommitted"
End If
If Trim(Request.Form("LastDateOfContact")) <> "" Then
strDateLastTalked = Replace(Request.Form("LastDateOfContact"), "'", "''")
strDateLastTalked = CDate(strDateLastTalked)
End If
If Trim(Request.Form("time_talents")) <> "" Then
strTalent = Replace(Request.Form("time_talent"), "'", "''")
End If

Set conn = server.createobject("adodb.connection")
DSNtemp="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("new_members.mdb")
conn.Open DSNtemp

SQLstmt = "INSERT INTO New_Members (LastName,FirstName,SpouseName,ChildrenNames1,Age1,ChildrenNames2,Age2,ChildrenNames3,Age3,ChildrenN ames4,Age4,Address,City,State,ZipCode,HomePhone,EmailAddress,MembershipDate,DateLastTalked,Notes,Pic tureID)"
SQLstmt = SQLstmt & " VALUES ('" & request.form("LastName") & "','" & request.form("FirstName") & "','" & request.form("SpouseName") & "','" & request.form("ChildrenNames1") & "','" & request.form("Age/Grade1") & "','" & request.form("ChildrenNames2") & "','" & request.form("Age/Grade2") & "','" & request.form("ChildrenNames3") & "','" & request.form("Age/Grade3") & "','" & request.form("Childrennames4") & "','" & request.form("Age/Grade4") & "','" & request.form("Address") & "','" & request.form("City") & "','" & request.form("State") & "','" & request.form("ZipCode") & "','" & request.form("PhoneNumber") & "','" & request.form("Email") & "','" & strMembershipDate & "','" & DATE_DELIMITER & strDateLastTalked & DATE_DELIMITER & "','" & strTalent & "," & strNotes & "','" & request.form("PictureID") & "')"
%>
<HR>
SQL statement: <%=SQLstmt%>
<HR>

<%

conn.execute(SQLstmt)

conn.Close
Set conn = nothing
Set SQLstmt = nothing
Response.Redirect("index.asp")
%>


All help is greatly appreciated!!