saving a query string as an SQL view in Access

[Brian]

Hi. I have a query that I build using VBA. I have to
use VBA because depending on the user input, the query
can change. An example query is:

SELECT ACCOUNT_LIST.COMPLEMENTOR FROM REP_LIST INNER JOIN
(CS_LIST INNER JOIN ACCOUNT_LIST ON CS_LIST.id =
ACCOUNT_LIST.CS) ON REP_LIST.id = ACCOUNT_LIST.REP WHERE
(((ACCOUNT_LIST.COMPLEMENTOR)='Wal-Mart'));

Is there a way, using VBA, to save that query string as
an actual Access SQL view? So then I can see it in the
query browser in Access? Thanks for any help!

Brian

 

[Deville]

Use the CreateQueryDef method.

Set qdf = db.CreateQueryDef(qdfName, QuerySQL)

Hope this helps.

 

[Guest]

Thanks for the help!

Brian

-----Original Message-----
Use the CreateQueryDef method.

Set qdf = db.CreateQueryDef(qdfName, QuerySQL)

Hope this helps.

.