saving a query string as an SQL view in Access

  • Thread starter Thread starter Brian
  • Start date Start date
B

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
 
Use the CreateQueryDef method.

Set qdf = db.CreateQueryDef(qdfName, QuerySQL)

Hope this helps.
 
Back
Top