Hi Paul, again I continue to thank you. If I have followed your instructions properly, using only one of the SQL options at a time, these are the results.
With:
Code:
StrSQL = "SELECT * FROM [CORE$]
Word just kept opening mail merge documents over and over, mergiing without headers and footers and reports of 135 calculation errors (there are only 31 records in my database). I had to <CTRL><ALT><DEL> to end Excel to stop the Word reports from being created non stop.
With just:
Code:
StrSQL = "SELECT * FROM [CORE$] " & _
"ORDER BY [START] ASC, [COMPLEX] ASC, [UNIT] ASC"
Received the mysterious select table prompt with the DATA1.xls worksheet.
With:
Code:
StrSQL = "SELECT * FROM [CORE$] WHERE [TYPE]=DR " & _
"ORDER BY [START] ASC, [COMPLEX] ASC, [UNIT] ASC"
Received the mysterious select table prompt with the DATA1.xls worksheet.
Same thing with ...
Code:
StrSQL = "SELECT * FROM [CORE$] WHERE [TYPE]=""""DR"""" " & _
"ORDER BY [START] ASC, [COMPLEX] ASC, [UNIT] ASC"
and lastly, with
Code:
StrSQL = "SELECT * FROM [CORE$] WHERE [TYPE]=[" & itype & "] AND [SIG_CREW]= [" & isubresp & "]" & _
"ORDER BY [START] ASC, [COMPLEX] ASC, [UNIT] ASC"
Same thing. Select table from workbook DATA1.xls
Within a few minutes, with the Select Table box open, I will eventually get the "Waiting to complete an OLE process" message.