A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Queries and reports



 
 
Thread Tools Display Modes
  #1  
Old July 9th, 2008, 08:13 PM posted to microsoft.public.access.queries
theIThombre
external usenet poster
 
Posts: 8
Default 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  
Old July 9th, 2008, 08:32 PM posted to microsoft.public.access.queries
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default 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  
Old July 9th, 2008, 08:54 PM posted to microsoft.public.access.queries
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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  
Old July 9th, 2008, 08:58 PM posted to microsoft.public.access.queries
BlueWolverine
external usenet poster
 
Posts: 138
Default 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  
Old July 9th, 2008, 09:21 PM posted to microsoft.public.access.queries
Klatuu
external usenet poster
 
Posts: 7,074
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.