j2cagle (5/9/2013)
Yes that helps...but I'm trying to resolve this without touching the VB code.
Have you tried passing it in with the single or double quotes? I think the single quotes should resolve the issue.
You say you don't want to change the VB code, so how is the variable entered? Through a text box in the interface? From a file? From another database or query?
What version of VB is this? (The answer doesn't matter much here, I'm just curious)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams