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 » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Why is report re-prompting for parameters when I print?



 
 
Thread Tools Display Modes
  #1  
Old July 19th, 2007, 02:06 PM posted to microsoft.public.access.reports
rebecnoel
external usenet poster
 
Posts: 5
Default Why is report re-prompting for parameters when I print?

I have a report that opens up correctly in preview mode (after I enter in
appropriate parameters). For some reason though it asks for the same
parameters again when I try to print the report. Any idea what might cause
this?
  #2  
Old July 19th, 2007, 04:21 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default Why is report re-prompting for parameters when I print?

When you print a report it runs the query. When you print the report from
preview it call the print routine which reruns the query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
I have a report that opens up correctly in preview mode (after I enter in
appropriate parameters). For some reason though it asks for the same
parameters again when I try to print the report. Any idea what might cause
this?



  #3  
Old July 19th, 2007, 06:34 PM posted to microsoft.public.access.reports
rebecnoel
external usenet poster
 
Posts: 5
Default Why is report re-prompting for parameters when I print?

It only does this for 1 of the 20 reports in my database though. For the
other 19 I can print directly from preview without a second prompt for
parameters. Any idea what might be different with this 1 report?

"John Spencer" wrote:

When you print a report it runs the query. When you print the report from
preview it call the print routine which reruns the query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
I have a report that opens up correctly in preview mode (after I enter in
appropriate parameters). For some reason though it asks for the same
parameters again when I try to print the report. Any idea what might cause
this?




  #4  
Old July 19th, 2007, 09:23 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default Why is report re-prompting for parameters when I print?

No. I can't see any of your reports so obviously it is difficult to tell
you what is different.

Are you getting the parameters from a form or are you just using a parameter
prompt?

Does this one report have the parameter prompt in the underlying query? Or
are the parameter prompts coming from something in the report itself?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
It only does this for 1 of the 20 reports in my database though. For the
other 19 I can print directly from preview without a second prompt for
parameters. Any idea what might be different with this 1 report?

"John Spencer" wrote:

When you print a report it runs the query. When you print the report
from
preview it call the print routine which reruns the query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
I have a report that opens up correctly in preview mode (after I enter
in
appropriate parameters). For some reason though it asks for the same
parameters again when I try to print the report. Any idea what might
cause
this?






  #5  
Old July 20th, 2007, 12:24 AM posted to microsoft.public.access.reports
rebecnoel
external usenet poster
 
Posts: 5
Default Why is report re-prompting for parameters when I print?

The parameter prompt comes from an underlying query which is linked to a
combo box on a form. The report set-up is the same as a number of other
reports so I'm really not sure where to begin looking. I was wondeing if
report properties I'm unaware of deal with printing parameters or something.

Sorry, I know it's pretty impossible to diagnose a problem without even
seeing the database. I appreciate your responses. I may need to re-create the
report to see if the same problem arises.



"John Spencer" wrote:

No. I can't see any of your reports so obviously it is difficult to tell
you what is different.

Are you getting the parameters from a form or are you just using a parameter
prompt?

Does this one report have the parameter prompt in the underlying query? Or
are the parameter prompts coming from something in the report itself?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
It only does this for 1 of the 20 reports in my database though. For the
other 19 I can print directly from preview without a second prompt for
parameters. Any idea what might be different with this 1 report?

"John Spencer" wrote:

When you print a report it runs the query. When you print the report
from
preview it call the print routine which reruns the query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
I have a report that opens up correctly in preview mode (after I enter
in
appropriate parameters). For some reason though it asks for the same
parameters again when I try to print the report. Any idea what might
cause
this?






  #6  
Old July 20th, 2007, 01:03 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default Why is report re-prompting for parameters when I print?

My guess is that one of the following may be the problem
-- the form is not open when you run the report
-- the form name or the control name has changed (perhaps so subtly that
you don't notice the difference)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
The parameter prompt comes from an underlying query which is linked to a
combo box on a form. The report set-up is the same as a number of other
reports so I'm really not sure where to begin looking. I was wondeing if
report properties I'm unaware of deal with printing parameters or
something.

Sorry, I know it's pretty impossible to diagnose a problem without even
seeing the database. I appreciate your responses. I may need to re-create
the
report to see if the same problem arises.



"John Spencer" wrote:

No. I can't see any of your reports so obviously it is difficult to tell
you what is different.

Are you getting the parameters from a form or are you just using a
parameter
prompt?

Does this one report have the parameter prompt in the underlying query?
Or
are the parameter prompts coming from something in the report itself?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
It only does this for 1 of the 20 reports in my database though. For
the
other 19 I can print directly from preview without a second prompt for
parameters. Any idea what might be different with this 1 report?

"John Spencer" wrote:

When you print a report it runs the query. When you print the report
from
preview it call the print routine which reruns the query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
I have a report that opens up correctly in preview mode (after I
enter
in
appropriate parameters). For some reason though it asks for the same
parameters again when I try to print the report. Any idea what might
cause
this?








  #7  
Old July 20th, 2007, 03:20 PM posted to microsoft.public.access.reports
rebecnoel
external usenet poster
 
Posts: 5
Default Why is report re-prompting for parameters when I print?

You are right. If I open the report in preview mode and then re-open the form
and choose the same parameter and then print, it doesn't give me the second
prompt.

What's odd is that the other reports print with no second prompt without
their respective forms being open. Maybe the difference is just the
structural differences in the reports themselves. I was hoping maybe there
was a report property that might cause this but it doesn't sound like that's
the case...



"John Spencer" wrote:

My guess is that one of the following may be the problem
-- the form is not open when you run the report
-- the form name or the control name has changed (perhaps so subtly that
you don't notice the difference)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
The parameter prompt comes from an underlying query which is linked to a
combo box on a form. The report set-up is the same as a number of other
reports so I'm really not sure where to begin looking. I was wondeing if
report properties I'm unaware of deal with printing parameters or
something.

Sorry, I know it's pretty impossible to diagnose a problem without even
seeing the database. I appreciate your responses. I may need to re-create
the
report to see if the same problem arises.



"John Spencer" wrote:

No. I can't see any of your reports so obviously it is difficult to tell
you what is different.

Are you getting the parameters from a form or are you just using a
parameter
prompt?

Does this one report have the parameter prompt in the underlying query?
Or
are the parameter prompts coming from something in the report itself?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
It only does this for 1 of the 20 reports in my database though. For
the
other 19 I can print directly from preview without a second prompt for
parameters. Any idea what might be different with this 1 report?

"John Spencer" wrote:

When you print a report it runs the query. When you print the report
from
preview it call the print routine which reruns the query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
I have a report that opens up correctly in preview mode (after I
enter
in
appropriate parameters). For some reason though it asks for the same
parameters again when I try to print the report. Any idea what might
cause
this?









  #8  
Old July 20th, 2007, 05:17 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default Why is report re-prompting for parameters when I print?

Well. my original response may have been offbase. I thought I recalled
earlier versions of Access doing what I said, but I've since checked and I
am not seeing the behaviour of it prompting for input parameters again if I
print from preview - at least on the lmited testing I did.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
You are right. If I open the report in preview mode and then re-open the
form
and choose the same parameter and then print, it doesn't give me the
second
prompt.

What's odd is that the other reports print with no second prompt without
their respective forms being open. Maybe the difference is just the
structural differences in the reports themselves. I was hoping maybe there
was a report property that might cause this but it doesn't sound like
that's
the case...



"John Spencer" wrote:

My guess is that one of the following may be the problem
-- the form is not open when you run the report
-- the form name or the control name has changed (perhaps so subtly
that
you don't notice the difference)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
The parameter prompt comes from an underlying query which is linked to
a
combo box on a form. The report set-up is the same as a number of other
reports so I'm really not sure where to begin looking. I was wondeing
if
report properties I'm unaware of deal with printing parameters or
something.

Sorry, I know it's pretty impossible to diagnose a problem without even
seeing the database. I appreciate your responses. I may need to
re-create
the
report to see if the same problem arises.



"John Spencer" wrote:

No. I can't see any of your reports so obviously it is difficult to
tell
you what is different.

Are you getting the parameters from a form or are you just using a
parameter
prompt?

Does this one report have the parameter prompt in the underlying
query?
Or
are the parameter prompts coming from something in the report itself?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
It only does this for 1 of the 20 reports in my database though. For
the
other 19 I can print directly from preview without a second prompt
for
parameters. Any idea what might be different with this 1 report?

"John Spencer" wrote:

When you print a report it runs the query. When you print the
report
from
preview it call the print routine which reruns the query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"rebecnoel" wrote in message
...
I have a report that opens up correctly in preview mode (after I
enter
in
appropriate parameters). For some reason though it asks for the
same
parameters again when I try to print the report. Any idea what
might
cause
this?











 




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 10:55 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.