Is there a way to find out where certain functions are used?

[latex88]

Hi,
Is there a way I can find out where certain customized functions are used in forms/queries/reports?

 

[spikepl]

google v-tools

 

[DavidAtWork]

Another way would be to go to the VB Window (Alt/F11) and use the search facility from the Edit menu, type the name of the function and select search current project. That will find all uses of that function in your code and the project explorer will indicate which Module/Form/Report relates to the current Find
David

 

[latex88]

I was actually hoping to find inside of queries or text boxes in forms or reports.
What are google v-tools?

 

[pr2-eugin]

Latex88, What spikepl means is try googling the term v-tools..

 

[latex88]

Don't I feel foolish...sorry, brain not working so well this morning...

 

[pr2-eugin]

Don't I feel foolish...sorry, brain not working so well this morning...

LOL.. Everyone has one of those days..

 

[latex88]

This is one I found

http://www.skrol29.com/us/vtools.php

. Has anyone installed this tool? I'm a bit hesitant.

 

[pr2-eugin]

I have not myself used the Tool (I might give it a try a bit later)..

spikepl is experienced in this field, and he would certainly not recommend something that is wonky.. Nothing to loose, as it is a Free tool..

Just my opinion.. wait for other to have their say..

 

[Rx_]

I used google to find V-Tools for Access 2010
How did I live with out this!
It should help find the values inside the Queries much better than the way I use to do it (e.g. with a bucket and shovel).
Thanks

 

[Galaxiom]

V-Tools is brilliant.

Be sure to get MZ-Tools too.
http://www.mztools.com

Also Allen Browne's Database Issue Checker
http://allenbrowne.com/appissuechecker.html

 

[ChrisO]

While the tools mentioned so far are very good they can not find all the callers of Functions and Subroutines.

Functions called directly from the Property sheet may not even exist in design view.

Functions and Subroutines called by the OnAction property of Command Bars may exist only in a Table.

Function names which are Evaluated or Functions and Subroutine executed by an Application.Run statement may be concatenated strings that only exist at run-time and under specific running conditions.

I mention these limitations for one reason. If you need to find something then you will probably need to find all instances of that thing. The automated packages can find most things but not all.

We still need to know how to find things manually if we want to find all instances of that thing. The automated find packages still need our knowledge of when and how to use them and a knowledge of their short comings.

There are no automated shortcuts if we want to find all callers of everything; that will still require manual work.

Chris.