How to detect if a Querydef exist without having to make a error sub?
Printable View
How to detect if a Querydef exist without having to make a error sub?
iterate over all items in the QueryDefs collection and inspect the Name property of each entry.
If the one you are looking for is there, it exists.