Check if query exists

  • Thread starter Thread starter Paulo
  • Start date Start date
P

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
 
Thanks. The function did the trick.

Paulo

Daniel Pineault said:
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.
Click to expand...
 
Back
Top