Insert Null Value into Date/Time Field
This simple project will simply insert a null value to a date/time field if the checkbox within DateTimePicker is False. In order to determine if the Checkbox is true/false you need to use the isNull function. Private Sub CmdInsert_Click() Dim cn As New Connection Dim strSQL As String cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Data.mdb;" strSQL = "INSERT INTO NOSOld