56stingray
Programmer
how does one 'split' a line of code into 2 lines on screen?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
(date,time,authno,cardno,tcno,fpi,reserved1,reserved2, _
tripno,unitno,driverno,reserved3,trancode1,trailerno, _
dispatchno,tsname,tscity,tsstate,diesel_gallons, _
....
strSQL1 = "Insert into tblimport_TPStransactions values(#" & FormatDateTime(ds("date"), vbShortDate) & "#, " _
& " '" & ds("time") & "','" & ds("authno") & "','" & ds("cardno") & "','" & ds("tcno") & "', " _
& " '" & ds("fpi") & "','" & ds("reserved1") & "','" & ds("reserved2") & "','" & ds("tripno") & "'," _
& " '" & ds("unitno") & "','" & ds("driverno") & "','" & ds("reserved3") & "','" & ds("trancode1") & "'," _
& " '" & ds("trailerno") & "','" & Replace(ds("tsname"), "'", "''") & "','" & Replace(ds("tscity"), "'", "''") & "'," _
& " '" & ds("tsstate") & "'," & ds("diesel_gallons") & "," & ds("diesel_total") & ",'" & ds("diesel_service") & "'," _
& " " & ds("diesel_ppg") & "," & ds("gasoline_gallons") & "," & ds("gasoline_total") & "," & ds("cashadv") & "," _
& " '" & ds("hub") & "'," & ds("oil_qty") & "," & ds("oil_total") & "," & ds("reefer_gallons") & "," & ds("reefer_total") & "," _
& " " & ds("additive_qty") & "," & ds("additive_total") & "," & ds("parts_total") & "," & ds("tire_rep_qty") & "," _
& " " & ds("tire_rep_total") & "," & ds("tire_purch_qty") & "," & ds("tire_purch_total") & "," _
& " " & ds("permit_total") & ",'" & ds("trancode2") & "','" & ds("tsno") & "'," & ds("reserved4") & ",'"
strSQL1 = "Insert into tblimport_TPStransactions values(#" & FormatDateTime(ds("date"), vbShortDate) & "#, " _
& " '" & ds("time") & "','" & ds("authno") & "','" & ds("cardno") & "','" & ds("tcno") & "', "
strSQL1 = strSQL1 & " '" & ds("fpi") & "','" & ds("reserved1") & "','" & ds("reserved2") & "','" & ds("tripno") & "'," _
& " '" & ds("unitno") & "','" & ds("driverno") & "','" & ds("reserved3") & "','" & ds("trancode1") & "',"
strSQL1 = strSQL1 & " '" & ds("trailerno") & "','" & Replace(ds("tsname"), "'", "''") & "','" & Replace(ds("tscity"), "'", "''") & "'," _
& " '" & ds("tsstate") & "'," & ds("diesel_gallons") & "," & ds("diesel_total") & ",'" & ds("diesel_service") & "',"
strSQL1 = strSQL1 & " " & ds("diesel_ppg") & "," & ds("gasoline_gallons") & "," & ds("gasoline_total") & "," & ds("cashadv") & "," _
& " '" & ds("hub") & "'," & ds("oil_qty") & "," & ds("oil_total") & "," & ds("reefer_gallons") & "," & ds("reefer_total") & ","
strSQL1 = strSQL1 & " " & ds("additive_qty") & "," & ds("additive_total") & "," & ds("parts_total") & "," & ds("tire_rep_qty") & "," _
& " " & ds("tire_rep_total") & "," & ds("tire_purch_qty") & "," & ds("tire_purch_total") & ","
strSQL1 = strSQL1 & " " & ds("permit_total") & ",'" & ds("trancode2") & "','" & ds("tsno") & "'," & ds("reserved4") & ",'"