[AccessD] Does Query Exist In Access Queries

Charlotte,
Thanks for your help, never even considered On Error etc......Think the powers that be are working me too hard.....
Paul





Message date : Dec 02 2003, 04:24 PM
>From : Charlotte Foust 
To : Access Developers discussion and problem solving 
Copy to : 
Subject : RE: [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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime