null date time

dhoward · June 15th, 2007, 01:33 PM

I'm having a problem. On my application I have several datetime textboxes that should be entered at certain times. If the datetime is not entered, it should enter either 'null' or it should remain empty in the database. Well if I don't enter anything in the textbox it throws an error saying "string does not recognize as valid datetime". Can someone help me so that error does not appear? Why won't it enter null and stay empty?

BrianWren · June 15th, 2007, 02:48 PM

Access delimits dates with #, so I used that as a sample

Code:

    If txtBx.Text = "" Then
        s = "NULL"
    Else
        s = " #" & txtBx.Text & "# "
    End If

    MyCnctn.Execute "UPDATE TheTable ( TheDateField ) " & _
                    "Values          ( " & s & "    ) ", , _
                    adCmdText

Just a simple sample to give you a possible solution approach.