Try:
ssql = "SELECT Manual_Covernote_Log.DateOfCall, Manual_Covernote_Log.DealerNumber, Manual_Covernote_Log.DealerName, " & _
"Manual_Covernote_Log.CustomerName, Manual_Covernote_Log.ChassisNumber, Manual_Covernote_Log.ManualCovernoteNumber, " & _
"Manual_Covernote_Log.Vehicle, Manual_Covernote_Log.Comments " & _
"WHERE Manual_Covernote_Log.DealerNumber = " & txtDCSearch.Value & _
"FROM Manual_Covernote_Log ORDER BY Manual_Covernote_Log.DateOfCall;"