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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|