How access underlying query collection (if exist)

[koci]

Hi all.

My question is: how access ALL the underlying querys form one access database, to see for example if use one function (if I need to change this function), or use one field (that I want to erase)?
Exist one such a collection (like querydef)?


Thank's.

 

[maxmangion]

not sure if i understand you question correctly, but if you would like to create your own function and use it throughout any of your queries, so that you will have to change that function only at a later stage, you can create your desired function(s) in a module, and then you can use it in all of your queries.

 

[koci]

Thank's for reply.

I'll be more explicit.

I have one function. This function I use in many underlying query's in let's say source of some combo box's. Then I need to modify this function (put one parameter more). I need to make the changes in All the SQL's that use this function. But how I now the combos box's (Example) where I need to make this changes?

The same with source of some forms. I want to erase one field form one table, but I build some SQL strings like source's at some forms. How to know where need to make the sql updates?