If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Queries and reports
Hey Gang,
Quick question- I have a staff member who is tryiyng to find out which queries are connected to certain reports. She is in the process of printing up end of year fiscal reports and has no idea of which queries are connected to one particular report. Any help will be greatly appreciated! -- The IT Hombre |
#2
|
|||
|
|||
Queries and reports
Rich Fisher's excellent Find and Replace add-in might be just the ticket. If
you register it (one of the best $37 I've ever spent), the cross-reference report can find what queries use which reports and forms. It's also good way to find orphan queries not linked to forms and reports.. http://www.rickworld.com/ -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "theIThombre" wrote: Hey Gang, Quick question- I have a staff member who is tryiyng to find out which queries are connected to certain reports. She is in the process of printing up end of year fiscal reports and has no idea of which queries are connected to one particular report. Any help will be greatly appreciated! -- The IT Hombre |
#3
|
|||
|
|||
Queries and reports
Use TOOLS - Analyze - Documentor. Select the reports and option Properties,
click ok, click ok. Scroll down to Record Source. -- KARL DEWEY Build a little - Test a little "theIThombre" wrote: Hey Gang, Quick question- I have a staff member who is tryiyng to find out which queries are connected to certain reports. She is in the process of printing up end of year fiscal reports and has no idea of which queries are connected to one particular report. Any help will be greatly appreciated! -- The IT Hombre |
#4
|
|||
|
|||
Queries and reports
Couldn't you just go into Design mode on the report and right click on the
grey/tan box in the upper left hand corner and choose "properties" and go to the data tab?? If your record source is a query (most likely) then it's name appears in the top box. (Access 2003) -- BlueWolverine MSE - Mech. Eng. Go BLUE! "KARL DEWEY" wrote: Use TOOLS - Analyze - Documentor. Select the reports and option Properties, click ok, click ok. Scroll down to Record Source. -- KARL DEWEY Build a little - Test a little "theIThombre" wrote: Hey Gang, Quick question- I have a staff member who is tryiyng to find out which queries are connected to certain reports. She is in the process of printing up end of year fiscal reports and has no idea of which queries are connected to one particular report. Any help will be greatly appreciated! -- The IT Hombre |
#5
|
|||
|
|||
Queries and reports
Jerry,
I agree wholeheartedly. I have been using it for about 3 1/2 years. I once almost quit a contract because they said I could not install any software not purchased by the company. I told them to either buy it or replace me. They bought it. I doubt I could count the number of times the time savings have paid for the product. -- Dave Hargis, Microsoft Access MVP "Jerry Whittle" wrote: Rich Fisher's excellent Find and Replace add-in might be just the ticket. If you register it (one of the best $37 I've ever spent), the cross-reference report can find what queries use which reports and forms. It's also good way to find orphan queries not linked to forms and reports.. http://www.rickworld.com/ -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "theIThombre" wrote: Hey Gang, Quick question- I have a staff member who is tryiyng to find out which queries are connected to certain reports. She is in the process of printing up end of year fiscal reports and has no idea of which queries are connected to one particular report. Any help will be greatly appreciated! -- The IT Hombre |
Thread Tools | |
Display Modes | |
|
|