Suppress "Enter Parameter Value" Msgbox

[Guest]

Is there any why to suppress the "Enter Parameter Value" msgbox?
Thanks,
Ron

 

[Guest]

No, the query needs the parameter. You can supply the parameter so it wont
ask.

 

[Guest]

Is there a way that I can force the parameter to null in the VBA? Or is
there a way I can test to see if a parameter exists before issuing the SQL?

 

[Guest]

Is the SQL a stored query or is it built programmatically?
Can you describe in a bit more detail what the objective is, it would help
me understand the problem a little better.

 

[Guest]

The SQL is built programmatically. The program is navigating through a table
that contains EntityXML values and associated XMLTagNames. I plug these into
an SQL statement using the EntityXML value as the table and the XMLTagName as
the column.
I am running into situations were the XMLTagName is not defined in the table
and I get the Enter Parameter Value box. The fact that the data element is
not there is acceptable, I just want to report it as not existing without
generating all the prompts.

 

[UpRider]

Would it be acceptable for your code to substitute the string "Absent" or
"Null", or "Missing" or some such for the null fields?
That would satisfy the parameter requirement and stop the begging.

UpRider