I have an MS Query instance, querying a selection of values from one worksheet into another worksheet.
I thought I had a problem in that I'm getting this error message:
Whenever I change the "command text" (the SQL) with a minor change, such as adding or removing the automatically added apostrophes to any MS Query Alias.
However, I noticed rather accidentally in testing that the query will refresh after the first error message.
My two questions/requests:
[ol 1]
[li]Can anyone help by shedding light on why it would throw such an error after the immediate change and yet operate totally fine afterwards?[/li]
[li]Can anyone help me think of the best way to just supress the message whenever I made a change programatically to the same SQL text?[/li]
[/ol]
Thanks for any thoughts,
Stephen
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
I thought I had a problem in that I'm getting this error message:
Whenever I change the "command text" (the SQL) with a minor change, such as adding or removing the automatically added apostrophes to any MS Query Alias.
However, I noticed rather accidentally in testing that the query will refresh after the first error message.
My two questions/requests:
[ol 1]
[li]Can anyone help by shedding light on why it would throw such an error after the immediate change and yet operate totally fine afterwards?[/li]
[li]Can anyone help me think of the best way to just supress the message whenever I made a change programatically to the same SQL text?[/li]
[/ol]
Thanks for any thoughts,
Stephen
"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
