C
C. Sharp
Is there a quick way to see which queries are attached to which reports and
vice versus in Access 2007?
Thanks in advance!
vice versus in Access 2007?
Thanks in advance!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Lord Kelvan
not sure bout accress 2007 but if you open the report in design view
and then double click on the grey area you get the properity window
for the report and then you can click on the daya tab and it sould
display it there at least on the older versions.
Regards
Kelvan
and then double click on the grey area you get the properity window
for the report and then you can click on the daya tab and it sould
display it there at least on the older versions.
Regards
Kelvan
C
C. Sharp
Actually, I was wanting it the other way around. I want to open the query
and find out which reports are using it. I'm cleaning up my DB and would
like to see how everything is related between the various queries/reports so
I don't delete something that is needed.
and find out which reports are using it. I'm cleaning up my DB and would
like to see how everything is related between the various queries/reports so
I don't delete something that is needed.
J
John Spencer
Products to document the database and do a global find and replace. All
have Access 97 and later versions. Some don't have an Access 2003
version, but may still work with Access 2003.
Shareware (Try and Buy):
Find and Replace http://www.rickworld.com
Commercial (Try and Buy)
Speed Ferret http://www.moshannon.com
Commercial
Total Access Analyzer http://www.fmsinc.com
Free (For Access XP Only??):
http://www3.bc.sympatico.ca/starthere/findandreplace
Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/ (Free)
V-Tools: http://www.skrol29.com/us/vtools.php (Free)
'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
have Access 97 and later versions. Some don't have an Access 2003
version, but may still work with Access 2003.
Shareware (Try and Buy):
Find and Replace http://www.rickworld.com
Commercial (Try and Buy)
Speed Ferret http://www.moshannon.com
Commercial
Total Access Analyzer http://www.fmsinc.com
Free (For Access XP Only??):
http://www3.bc.sympatico.ca/starthere/findandreplace
Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora: http://www3.bc.sympatico.ca/starthere/findandreplace/ (Free)
V-Tools: http://www.skrol29.com/us/vtools.php (Free)
'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
E
Elysia
If I'm understanding your Q (that you want to see which objects depend on a
certain query) in Access 2007 it is super easy to do this. There is a really
nifty tool called object dependencies under the database tools tab.
Open a query (design view, run it, whatever) then click the object
dependencies. I think it asks you if you're ok with closing everything so it
can run its 'scan' of your database's relationships, but then it will bring
up a side bar like the properties tab that tells you what objects and their
types are related, so there should be a section for "reports" that lists all
the reports files associated with a particular query
~E
certain query) in Access 2007 it is super easy to do this. There is a really
nifty tool called object dependencies under the database tools tab.
Open a query (design view, run it, whatever) then click the object
dependencies. I think it asks you if you're ok with closing everything so it
can run its 'scan' of your database's relationships, but then it will bring
up a side bar like the properties tab that tells you what objects and their
types are related, so there should be a section for "reports" that lists all
the reports files associated with a particular query
~E