printing asks for duplicate information

  • Thread starter Thread starter Dennis hansen
  • Start date Start date
D

Dennis hansen

The report looks good and works fine. However, when I try
to print the report it once again asks me for the queue
information. This is annoying.
I would like to use a macro to just run the report and
print it but it asks for the information a second time
Help
Dennis
 
I think what you are saying is that when you attempt to
run a report you are asked for the same parameter twice.
When you run a report based on some parameter you could
use a form where you enter the parameter date like create
a form with two text boxes named startdate and enddate,
than you should set the query criteria to;
Between [Forms!yourform!startdate] and [Forms!yourform!
enddate]
If this does not answer your question post back with some
more specific information.
Fons
 
I chopped off half my question sorry.
My report consists of two sub reports. Each sub report
asks for a single entry queue, for information, not
BETWEEN- AND-. When I run the report it works fine. I get
the information in the way I have it laved out. If I try
to print that report as viewed, it starts the process over
of having me enter the same queue information that is
already displayed.
I did create a macro that would run the report and print.
That works.
How come I can't print the report I have viewed after I
run the report? With out it wanting to run the queue again?
Thank you again. Sorry about the first posting.
Dennis.
-----Original Message-----
I think what you are saying is that when you attempt to
run a report you are asked for the same parameter twice.
When you run a report based on some parameter you could
use a form where you enter the parameter date like create
a form with two text boxes named startdate and enddate,
than you should set the query criteria to;
Between [Forms!yourform!startdate] and [Forms!yourform!
enddate]
If this does not answer your question post back with some
more specific information.
Fons
-----Original Message-----
The report looks good and works fine. However, when I try
to print the report it once again asks me for the queue
information. This is annoying.
I would like to use a macro to just run the report and
print it but it asks for the information a second time
Help
Dennis

.
Click to expand...
.
Click to expand...
 
The simple answer is when you run preview and a subsequent
print the report format is run each time and as such you
recreating the report.
I know this does not change anything.
Fons
-----Original Message-----
I chopped off half my question sorry.
My report consists of two sub reports. Each sub report
asks for a single entry queue, for information, not
BETWEEN- AND-. When I run the report it works fine. I get
the information in the way I have it laved out. If I try
to print that report as viewed, it starts the process over
of having me enter the same queue information that is
already displayed.
I did create a macro that would run the report and print.
That works.
How come I can't print the report I have viewed after I
run the report? With out it wanting to run the queue again?
Thank you again. Sorry about the first posting.
Dennis.
-----Original Message-----
I think what you are saying is that when you attempt to
run a report you are asked for the same parameter twice.
When you run a report based on some parameter you could
use a form where you enter the parameter date like create
a form with two text boxes named startdate and enddate,
than you should set the query criteria to;
Between [Forms!yourform!startdate] and [Forms!yourform!
enddate]
If this does not answer your question post back with some
more specific information.
Fons
-----Original Message-----
The report looks good and works fine. However, when I try
to print the report it once again asks me for the queue
information. This is annoying.
I would like to use a macro to just run the report and
print it but it asks for the information a second time
Help
Dennis

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
How can I get around this? entering queue information
twice fosters mistakes. I would like to preview and e-mail
the report as reviewed.
Dennis
-----Original Message-----
The simple answer is when you run preview and a subsequent
print the report format is run each time and as such you
recreating the report.
I know this does not change anything.
Fons
-----Original Message-----
I chopped off half my question sorry.
My report consists of two sub reports. Each sub report
asks for a single entry queue, for information, not
BETWEEN- AND-. When I run the report it works fine. I get
the information in the way I have it laved out. If I try
to print that report as viewed, it starts the process over
of having me enter the same queue information that is
already displayed.
I did create a macro that would run the report and print.
That works.
How come I can't print the report I have viewed after I
run the report? With out it wanting to run the queue again?
Thank you again. Sorry about the first posting.
Dennis.
-----Original Message-----
I think what you are saying is that when you attempt to
run a report you are asked for the same parameter twice.
When you run a report based on some parameter you could
use a form where you enter the parameter date like create
a form with two text boxes named startdate and enddate,
than you should set the query criteria to;
Between [Forms!yourform!startdate] and [Forms!yourform!
enddate]
If this does not answer your question post back with some
more specific information.
Fons
-----Original Message-----
The report looks good and works fine. However, when I try
to print the report it once again asks me for the queue
information. This is annoying.
I would like to use a macro to just run the report and
print it but it asks for the information a second time
Help
Dennis

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
The only way I can think of to do this is to create a form
or use a current form where you have the parameter to
which you wish to filter the report. Than in the
underlying query for your report set the criteria for the
parameter to be filtered to refer to the textbox on the
open form containing the parameter data.
You could also do it with code to set the print where
condition.
Hope this helps.
Fons
-----Original Message-----
How can I get around this? entering queue information
twice fosters mistakes. I would like to preview and e- mail
the report as reviewed.
Dennis
-----Original Message-----
The simple answer is when you run preview and a subsequent
print the report format is run each time and as such you
recreating the report.
I know this does not change anything.
Fons
-----Original Message-----
I chopped off half my question sorry.
My report consists of two sub reports. Each sub report
asks for a single entry queue, for information, not
BETWEEN- AND-. When I run the report it works fine. I get
the information in the way I have it laved out. If I try
to print that report as viewed, it starts the process over
of having me enter the same queue information that is
already displayed.
I did create a macro that would run the report and print.
That works.
How come I can't print the report I have viewed after I
run the report? With out it wanting to run the queue again?
Thank you again. Sorry about the first posting.
Dennis.

-----Original Message-----
I think what you are saying is that when you attempt to
run a report you are asked for the same parameter twice.
When you run a report based on some parameter you could
use a form where you enter the parameter date like create
a form with two text boxes named startdate and enddate,
than you should set the query criteria to;
Between [Forms!yourform!startdate] and [Forms!yourform!
enddate]
If this does not answer your question post back with some
more specific information.
Fons
-----Original Message-----
The report looks good and works fine. However, when I
try
to print the report it once again asks me for the queue
information. This is annoying.
I would like to use a macro to just run the report and
print it but it asks for the information a second time
Help
Dennis

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top