retriev sql from query

[europed]

Is there a way of retrieving the SQL code from a existing query in access using VBA and than modifying the sql to create another similar query? Thanx,

 

[xlbo]

Well SQL is a property of the querydef object so I would say so

mySQL = querydefs("QueryName&quot.SQL

should work nicely

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[europed]

thanx!!