Hi all -
I'm wondering if anyone has (or knows of) a tool that will allow me to
search through VB code, tables, queries, reports, forms, and other
objects, for references to all other types of objects.
That's not really that clear, so here's an example:
If I have a table named
"table_i_would_like_to_delete_but_don't_know_if_an y_object_is_using_it",
is there a way I can determine what forms/queries/reports/VB
code/other objects are getting data from it?
Another way to think about it is almost like a reverse lookup. So
let's say I have a form that I know is bound to a query. Well it's
easy to say "ok, this query is being used by this form." But I want
to programatically go through all other objects and figure out what
else is using/bound to this query. It's like there is a one-to-X
relationship between an object and X number of other objects and I
want to figure out what X equals (any number >= 0) and then what the
names of those X objects are.
To do this seems like it would take a fair amount of work, but I can't
imagine that others haven't had the need for this type of tool in the
past. There might even be something built into Access that I don't
know about (would M$ actually create something that robust and
useful?).
Thanks in advance,
Jon LaRosa
TDC
www.tdcorp.org