Finding Field Use

[Don]

Is there a way for me to easily locate every use of a field from a table that
I have used in forms, queries or reports? For instance, if I have a table
named tblTEST and it has a field named FIELD_A, I'd like to be able to find
that field in every form, query or report that I've created. Can I write
some VBA code to help me with this task?

 

[Roger Carlson]

You could. Or you could use a tool like Speed Ferret or Rick Fisher's Find
and Replace. The latter is free to download and cheap to register. You can
find it here: http://www.rickworld.com/download.html


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[alara asena]

Is there a way for me to easily locate every use of a field from a table
that
I have used in forms, queries or reports? For instance, if I have a table
named tblTEST and it has a field named FIELD_A, I'd like to be able to
find
that field in every form, query or report that I've created. Can I write
some VBA code to help me with this task?