Hi,
I was trying to blank out (null out?) a field of a record that is a
date/time data type. Here is code excerpt:
Dim D As Database
Dim rsRacks As Recordset
Dim strSQL As String
strSQL = "SELECT Racks.* FROM Racks WHERE (((Racks.[RL-Serial])= "
& RackSerial & "));"
Set D = CurrentDb
Set rsRacks = D.OpenRecordset(strSQL, DB_OPEN_DYNASET)
If rsRacks.RecordCount > 0 Then
rsRacks.Edit
rsRacks![DateShipped] = ""
rsRacks![TimeShipped] = ""
Else
rsRacks.AddNew
rsRacks![RL-Serial] = RackSerial
End If
rsRacks.Update
rsRacks.Close
This code gets a type conversion error. The problem lines is where the
DateShipped and TimeShipped are set to "". I also tried "##". Does
anyone have any ideas?
Thanks in advance,
Aaron