stupid simple

[yessir]

Why won' t this accept the ' _' as the carry to next line in:

DoCmd.SetWarnings False
    DoCmd.RunSQL "INSERT INTO tblWater_Sample_Temp ( ClientID, ProjectNo, LabID, _
    Matrix, DuplicateOf, SampleDate, Analyte, Method, Result, Units, LOQ, Outlet_ID, _
    Elevation, Unit_ID, DataSource, [Note], DL, FlowValue, FlowUnit_ID, Notes, Duplicate, _
    ERR_MATRIX, ERR_ANALYTE, ERR_METHOD, ERR_OUTLET, ERR_UNITS ) _
    SELECT TOP 1 tblWater_Sample_Temp.ClientID, tblWater_Sample_Temp.ProjectNo, _
    tblWater_Sample_Temp.LabID, tblWater_Sample_Temp.Matrix, _
    tblWater_Sample_Temp.DuplicateOf, tblWater_Sample_Temp.SampleDate, _
    tblWater_Sample_Temp.Analyte, tblWater_Sample_Temp.Method, _
    tblWater_Sample_Temp.Result, tblWater_Sample_Temp.Units, _
    tblWater_Sample_Temp.LOQ, tblWater_Sample_Temp.Outlet_ID, _
    tblWater_Sample_Temp.Elevation, tblWater_Sample_Temp.Unit_ID, _
    tblWater_Sample_Temp.DataSource, tblWater_Sample_Temp.Note, _
    tblWater_Sample_Temp.DL, tblWater_Sample_Temp.FlowValue, _
    tblWater_Sample_Temp.FlowUnit_ID, tblWater_Sample_Temp.Notes, _
    tblWater_Sample_Temp.Duplicate, tblWater_Sample_Temp.ERR_MATRIX _
    tblWater_Sample_Temp.ERR_ANALYTE, tblWater_Sample_Temp.ERR_METHOD, _
    tblWater_Sample_Temp.ERR_OUTLET, tblWater_Sample_Temp.ERR_UNITS _
    FROM tblWater_Sample_Temp;"
DoCmd.SetWarnings True

 

[dcx693]

When you have text that is enclosed within quotes, you need to close the quotes before using the _ character.

You have it like this:
DoCmd.RunSQL "SELECT field _
FROM table;"

It should be like this:
DoCmd.RunSQL "SELECT field " & _
"FROM table;"

 

[ghudson]

Because you have created one huge text string. You need to enclose each line with the correct extenders (for lack of a better word ;-). This should give you the right idea...

DoCmd.SetWarnings False
    DoCmd.RunSQL "INSERT INTO tblWater_Sample_Temp ( ClientID, ProjectNo, LabID, " & _
    "Matrix, DuplicateOf, SampleDate, Analyte, Method, Result, Units, LOQ, Outlet_ID, " & _
    "Elevation, Unit_ID, DataSource, [Note], DL, FlowValue, FlowUnit_ID, Notes, Duplicate, " & _
    "ERR_MATRIX, ERR_ANALYTE, ERR_METHOD, ERR_OUTLET, ERR_UNITS ) " & _
    "SELECT TOP 1 tblWater_Sample_Temp.ClientID, tblWater_Sample_Temp.ProjectNo, " & _
    "tblWater_Sample_Temp.LabID, tblWater_Sample_Temp.Matrix, " & _
    "tblWater_Sample_Temp.DuplicateOf, tblWater_Sample_Temp.SampleDate, " & _
    "tblWater_Sample_Temp.Analyte, tblWater_Sample_Temp.Method, " & _
    "tblWater_Sample_Temp.Result, tblWater_Sample_Temp.Units, " & _
    "tblWater_Sample_Temp.LOQ, tblWater_Sample_Temp.Outlet_ID, " & _
    "tblWater_Sample_Temp.Elevation, tblWater_Sample_Temp.Unit_ID, " & _
    "tblWater_Sample_Temp.DataSource, tblWater_Sample_Temp.Note, " & _
    "tblWater_Sample_Temp.DL, tblWater_Sample_Temp.FlowValue, " & _
    "tblWater_Sample_Temp.FlowUnit_ID, tblWater_Sample_Temp.Notes, " & _
    "tblWater_Sample_Temp.Duplicate, tblWater_Sample_Temp.ERR_MATRIX " & _
    "tblWater_Sample_Temp.ERR_ANALYTE, tblWater_Sample_Temp.ERR_METHOD, " & _
    "tblWater_Sample_Temp.ERR_OUTLET, tblWater_Sample_Temp.ERR_UNITS " & _
    "FROM tblWater_Sample_Temp;"
DoCmd.SetWarnings True