E
EdStegner
i am a novice at vba. i have written vba code to find the "type" of all
queries in a database. Code was something like:
For each qry in querydefs,
if qry.properties("type") = YYY then do something
Next qry
If the query type = "dqQSelect", i'd like to ascertain what tables are being
used in the select statement. Additionally, if type = dbQAppend, i'd like to
ascertain into what table is having the data is being appended.
Are there properties that can give me this information? there are way too
many queries in this database to do this manually.
queries in a database. Code was something like:
For each qry in querydefs,
if qry.properties("type") = YYY then do something
Next qry
If the query type = "dqQSelect", i'd like to ascertain what tables are being
used in the select statement. Additionally, if type = dbQAppend, i'd like to
ascertain into what table is having the data is being appended.
Are there properties that can give me this information? there are way too
many queries in this database to do this manually.