Check if query exists

[Paulo]

How can I check, via code, that a query exists or not? I want to delete a
temporary query created in the program, using the CreateQueryDef property,
but it is not always that it has been created.

Thanks in advance,

Paulo

 

[Daniel Pineault]

See http://www.devhut.net/index.php?lang=en&pid=0000000003#DoesQryExist
for a function to check if a query exists or not.

Your alternative is to simply try and use the query and trap any errors that
arise in the case that it does not.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Paulo]

Thanks. The function did the trick.

Paulo

See http://www.devhut.net/index.php?lang=en&pid=0000000003#DoesQryExist
for a function to check if a query exists or not.

Your alternative is to simply try and use the query and trap any errors that
arise in the case that it does not.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.