[AccessD] Does Query Exist In Access Queries

Oops, sorry Charlotte. I totally missed the fact that the intention was to
delete it. In that case you're absolutely right. Just delete it and handle
the error if it doesn't exist.

Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Charlotte Foust
> Sent: 02 December 2003 17:09
> To: Access Developers discussion and problem solving
> Subject: RE: RE: [AccessD] Does Query Exist In Access Queries
> 
> 
> Sure, but the intent was to delete it in the first place, so 
> there's nothing wrong with simply trying to delete it.  
> Obviously, if you wanted to just check to see if it existed, 
> you wouldn't do *that* by trying to delete it.
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: Andy Lacey [mailto:andy at minstersystems.co.uk] 
> Sent: Tuesday, December 02, 2003 8:59 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: RE: [AccessD] Does Query Exist In Access Queries
> 
> 
> I'd suggest caution with "try to delete it". Surely if it did 
> exist it won't any more after that.
> 
> Andy Lacey
> http://www.minstersystems.co.uk 
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> > paul.hartland at fsmail.net
> > Sent: 02 December 2003 16:35
> > To: Access Developers discussion and problem solving
> > Subject: Re: RE: [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/a> ccessd
> > Website: 
> > http://www.databaseadvisors.com 
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/a> ccessd
> > Website: 
> > http://www.databaseadvisors.com
> > 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/a> ccessd
> > Website: 
> > http://www.databaseadvisors.com
> > 
> > 
> > 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>