find what forms and reports use a field from a given table

[jazminecat]

Hiya, is there a way to list all the forms, queries and reports that use a specific field from a table? I inherited a huge database and a user wants to add some functionality involving a specific field, but I need to know where that field is being used before I mess with it. Any ideas how to do this? the relationships window shows me what tables it's affecting - luckily it's only two. Thanks!!

 

[Remou]

This might help:
Find all objects that use field name?
thread181-1145093

 

[jazminecat]

Hm, I can't seem to run this. I have it in a module, where there is one other public sub, and have made all three public subs, but when I go to run it only lists the first one that was in there before. Am I missing a setting? It seems I used to be able to just click run and have it run whatever code I selected - i'm at a new job now, a year later, and a bit rusty.

thanks for your help!!

 

[raskew]

V-Tools, a freeware add-in appears to --in its Deep Search mode-- go down to the level you're looking for. Tried a test
and it provided every reference to OrderID in tables, queries, reports, forms.

You can download it at

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

HTH - Bob

 

[Remou]

If you mean my quite unsatisfactory snippets, you need to throw a field at them. For example:

Sub SearchAllOverThePlace()
Dim strField
strField = "ID"
SearchReportsForField (strField)
SearchFormsForField (strField)
SearchQueriesForField (strField)
End Sub

However, I have left out all sorts of things (echo, for example), so I suggest you try them one at a time.