[AccessD] Forms/Queries Relationships

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




More information about the AccessD mailing list