I notice there is white space in the column name of
RECORDING DATE
, wrap them in square brackets like this:
[RECORDING DATE]
.
Next, is the single quote for your datetimepickers, they are not nested correctly,
"’ & DateTimePicker1.Text & "’
it should be
'" & DateTimePicker1.Text & "’
same for datetimepicker2
Lastly, instead of
DateTimePicker1.Text
it should be more appropriately
DateTimePicker1.Value.ToString()
Learn
DateTimePicker.Value Property[
^] vs
DateTimePicker.Text Property[
^]