[AccessD] Re: Does Query Exist In Access Queries

Paul,

open the querydef

set qdf = currentdb.querydefs("TheQueryName")

replace the sql statement

qdf.sql = "The SQL String you want"

close the querydef

qdf.close

Robert

At 10:18 AM 12/3/2003 -0600, you wrote:
>Date: Wed,  3 Dec 2003 12:57:40 +0100 (CET)
>From: paul.hartland at fsmail.net
>Subject: Re: Re: [AccessD] Does Query Exist In Access Queries
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Message-ID: <3999006.1070452660273.JavaMail.www at wwinf3005>
>Content-Type: text/plain; charset=iso-8859-1
>
>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)