how do I search an access file for where a field is set from

[benjamin_hadden]

I have inherited a large database that I did not write that I am expected to
maintain. I have a field in an inventory table called
ThisSeasonsExpectedSales. This is the number of sales for a particular item
of inventory we expect to sell this season. I need to modify the formula that
sets this field to reflect a sharp increase in sales. However I cannot find
what form, macro or query sets this field. Is there a way of searching the
entire .mdb file for where this field might be set from. I frequently find
myself needing this ability to search for some field or property and end up
having to open vast quantities of forms and the like, by, hand hunting for n
expression that references a particular field. Surely it wouldn’t be too much
to ask for some function that traverses the entire object structure in an mdb
file. If we are going to have a programming paradigm that encourages
spaghetti like relationships surely there is a way to follow the wiggly lines.

Many thanks Ben

 

[KARL DEWEY]

I have inherited a large database that I did not write that I am expected to
maintain. I have a field in an inventory table called
ThisSeasonsExpectedSales. This is the number of sales for a particular item
of inventory we expect to sell this season. I need to modify the formula that
sets this field to reflect a sharp increase in sales. However I cannot find
what form, macro or query sets this field. Is there a way of searching the
entire .mdb file for where this field might be set from. I frequently find
myself needing this ability to search for some field or property and end up
having to open vast quantities of forms and the like, by, hand hunting for n
expression that references a particular field. Surely it wouldn’t be too much
to ask for some function that traverses the entire object structure in an mdb
file. If we are going to have a programming paradigm that encourages
spaghetti like relationships surely there is a way to follow the wiggly lines.

Many thanks Ben

 

[George Nicholson]

www.fmsinc.com "Access Analyzer", can supply field cross ref documentation
(among tons of other documentation and suggestions).

Not free, but can easily be worth the price in time & aggravation saved.

The bigger the project(s) the more useful it is.

HTH,