[AccessD] Does Query Exist In Access Queries

The easiest way to test it is to try to set an object variable to point to it and trap the error.  If there is no error, it exists.  Alternatively, try to delete it and trap the error.  If it didn't exist, an error will occur and you'll know what happened.

Charlotte Foust

-----Original Message-----
From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] 
Sent: Tuesday, December 02, 2003 7:54 AM
To: accessd
Subject: [AccessD] Does Query Exist In Access Queries


To all,
I'm sure I have done this before but can't find the code anywhere and can't figure out how to do it, basically I want to know if a query called qryProgrammeAvailability exists before I delete it via VB/VBA Thanks in advance for you help. Paul Hartland Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com