Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

tracing 1

Status
Not open for further replies.

lewie

Technical User
Joined
Jan 17, 2003
Messages
94
Location
US
When i am using a query, Is there a way to find out which forms use that query???without opening every form and checking the properties.
TIA
Lewie
 
There are some good utilities that can aid you in this sort of functionality, but nothing built into Access.

The free utilities:

John Barnett (a Tek-Tip regular) has created MDBDoc, which will compile the information you want into a very nice HTML layout. You can search that.


The non-free utilities:

- Find & Replace
- Speed Ferret

These two utilities will search through ALL of your Access properties, including crazy things like label captions, table connect strings, report recordsources, query SQL, and all sorts of places you would never dream to look. So using these tools is almost overkill, but they're useful for much more.
 
Status
Not open for further replies.

Similar threads

Part and Inventory Search

Sponsor

Back
Top