[AccessD] Does Query Exist In Access Queries

Dim qdf As DAO.Querydef

Set qdf = CurrentDb.Querydefs(<name of query>
Qdf.SQL = "SELECT * FROM Whatever..."

Set qdf = Nothing

Charlotte Foust


-----Original Message-----
From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] 
Sent: Wednesday, December 03, 2003 3:58 AM
To: Access Developers discussion and problem solving
Subject: Re: Re: [AccessD] Does Query Exist In Access Queries


lol (laughs out loud), didn't know you could do that.....how would I go about doing that ? Paul Database Designer/Developer (thinking of becoming a road sweeper)





Message date : Dec 03 2003, 11:49 AM
>From : Gustav Brock
To : Access Developers discussion and problem solving 
Copy to : 
Subject : Re: [AccessD] Does Query Exist In Access Queries
Hi Paul

So why not just replace the .SQL property?

/gustav


> I delete it to replace it with a similar query of the same name, based 
> on user selection.....

_______________________________________________
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 _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com