find queries, forms which reference column name

[stormin_norm]

I found a nice 'glitch' in the original table structure I inheritted. Two date fields are defined in different tables. Same data, just duplicated.
I wish to consolidate this info and clean house.
How can I find ALL queries, reports, and forms which reference these fields?


Thanks in advance!!
stormin' norm.

 

[WayneRyan]

norm,

For code, you can search in the VBA editor,

For queries, you can look in MSysObjects.

For forms and reports , you can loop through the forms and
reports collection, and for each one, loop through the controls
looking at the control source.

Sorry, I don't have any examples at hand.

Wayne

 

[stormin_norm]

Thanks for the assistance.

I found a thread which loops through the catalog for query names, I'll just modify it for forms and see how she works.

"just use the editor" - Good idea about the VBcode, I wasn't sure how complex it would be to tackle that object.
I know Keep it Simple Stormin

 

[WayneRyan]

norm,

Post back if you have trouble, this is something that should
interest everybody.

Wayne