Link to home
Start Free TrialLog in
Avatar of mds-cos
mds-cosFlag for United States of America

asked on

Search Access forms for specific underlying database field

I need to search through all of the forms and reports in a large Access XP database to determine what forms and reports use specific underlying database fields.  This is a one-time thing (I hope), so does not need to be fancy.

Does anybody know how to accomplish this?
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mds-cos

ASKER

Wow, don't I feel stupid!  I forgot that I downloaded the free MDBsearch (UCORA) tool a long time ago for something else.  See how often I have to do stupid stuff like searching forms for a field.

Thanks for getting my brain back in gear.
Avatar of mds-cos

ASKER

I don't want to buy anything for a simple search, but am going to check out TAA to see what other type of analysis info it gives me.
Do you mean this:

http://www.svalovic.com/?MDBSearch

If so, this won't tell you anything of that nature ... it searches tables for string values.

If that's not it, a link to this tool would be in order, I believe.

<I don't want to buy anything for a simple search>

This is anything but a "simple search" ... this would be an extrememly invasive process, and would take a LOT of code to generate a decent and robust cross index (hence the reason for 3rd party utilities to do this).
Avatar of mds-cos

ASKER

Yes, that is it tool.  And yes, after I pulled it up I realized that it does not search like I need it to.  I'm going to try the other tools.

Seems like it should not be that difficult to iterate through all the fields of every selected object type, pull the source field, and compare to a search string (I'm obviously ignoring the case of a query as the form source with select <record> as aliasname).  Course, as we all know something that seems like it should not be difficult often is.

Thanks.