Rocky Smolin
rockysmolin at bchacc.com
Wed Mar 20 12:27:54 CDT 2013
I think you could get most of that from Rick Fisher's Find and Replace. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett Sent: Wednesday, March 20, 2013 10:10 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Forms/Queries Relationships I have an mdb with 3 (stand-alone) tables, 49 queries, 2 forms (I tend to not use them, as it's easier to use the queries), and 38 reports. I want to do some housekeeping by eliminating some of the queries, and re-naming some of them. But I need to know which reports refer to what queries. My question: Is there some built-in utility that will give me a list of each of the report names, with the name of the query or table it is based on? (Yes, I think there are a couple of the first made reports that are based on the table instead of a query, from when I didn't know better). -- Kathryn Rhinehart Bassett (Pasadena CA) "Genealogy is my bag" "GH is my soap" kathryn at bassett.net http://bassett.net -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com