I wish to use VBA to read/write a Exist Query's sql text in Access. Do anyone can give me some help and point out how to do this.
Thanks for your help.
1. First, I create a Query in Access, and save it as "qryCustom"
2, Now, I wish to read the Query "qryCustom" SQL Text in VBA code, then I can modify the SQL Text for other purpose.
3, If need, I wish I can update the original Query with new SQL Text.
Pls help! Thanks.
Gino Liu at CI.