Coninuation ( _) Not Working 1

[EdAROC]

I can't believe I am stuck!
Here's the command, edited with " _", and I get an error dialog box:

"Compile Error:
Expected: end of statement"

dbRD_MACH_OPS - on the 2nd line is highlighted.
When I remove the continuation marks (put it back the way it was) it executes (I even removed the tabs that were inserted at the beginning of each line):

strSQL = "SELECT dbRD_MACH_OPS.MACH_NO as Machine, dbRD_MACH_OPS.ORDER_NO as Job, _
dbRD_MACH_OPS.SPEC_NO as Spec, dbRD_MACH_OPS.ITEM_NO as Item, dbRD_MACH_OPS.FORM_NO as Form _
FROM dbRD_MACH_OPS _
INNER JOIN MACHINES ON dbRD_MACH_OPS.MACH_NO = MACHINES.MACH_NO _
WHERE (((dbRD_MACH_OPS.ORDER_NO) = " & JNo & ") And ((dbRD_MACH_OPS.FORM_NO) = " & FNo & ") _
And dbRD_MACH_OPS.REPLACED_MACH_NO Is Null And (MACHINES.SCHEDCARDS_FLG = 'Y')) _
ORDER BY dbRD_MACH_OPS.MACH_SEQ_NO"

I'm so confused. :-(
(Do I need to remove the line leading tabs that are auto inserted for indentation?)

 

[PHV]

strSQL = "SELECT dbRD_MACH_OPS.MACH_NO as Machine, dbRD_MACH_OPS.ORDER_NO as Job, [!]"[/!]_
[!] & "[/!]dbRD_MACH_OPS.SPEC_NO as Spec, dbRD_MACH_OPS.ITEM_NO as Item, dbRD_MACH_OPS.FORM_NO as Form [!]"[/!]_
...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MajP]

I find that is very hard to do and to debug. Try something like this

strSql = "SELECT dbo_ORD_MACH_OPS.MACH_NO as Machine, dbo_ORD_MACH_OPS.ORDER_NO as Job,"

strSql = strSql & "dbo_ORD_MACH_OPS.SPEC_NO as Spec, dbo_ORD_MACH_OPS.ITEM_NO as Item,"

strSql = StrSql & "......"

This is makes it a lot easier to debug because along the way you can put in a debug.print.

However for a string in general

x = " adfsdfdsf" & _
    "ghghsdfsdfsd" & _
    "klklkjkl" & _

You need to close the quotes, you need an ampersand, you need a space after the ampersand.

 

[MajP]

Or as PHV showed you can put the continuation character and the ampersand on the next line.

 

[EdAROC]

Dang! :
It was right there in front of me in the 705-833660 thread - A literal string needs to be closed and re-opened.
Am I dense or what? (-:

Thanks, to both of you.