Print Previewing the Same Report

[Jim]

I’m trying to call a single report using different filter criteria. For
example DoCmd.OpenReport "rptReport1", acViewPreview, , "[Name] = 'Jones'"
and then DoCmd.OpenReport "rptReport1", acViewPreview, , "[Floor] = 7". When
I do this only the first report is shown in preview mode, is there a way to
pop-up multiple print preview screens?

Thanks in advance,

Jim

 

['69 Camaro]

Hi, Jim.

When
I do this only the first report is shown in preview mode, is there a way to
pop-up multiple print preview screens?

If you are running Access 2002 or 2003, then you could open the report in
dialog mode:

DoCmd.OpenReport "rptReport1", acViewPreview, , "[Name] = 'Jones'",
acDialog
DoCmd.OpenReport "rptReport1", acViewPreview, , "[Floor] = 7", acDialog

The code will stop running while the first report is open. As soon as the
user closes it, the second report will be opened.

To get a similar effect in an earlier version of Access, you could make a
copy of the report and open the reports in succession. Open the reports in
reverse order, since the last report opened will be "on top" for the user to
view. For example:

DoCmd.OpenReport "rptReport1", acViewPreview, , "[Floor] = 7"
DoCmd.OpenReport "rptReport1Copy", acViewPreview, , "[Name] = 'Jones'

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

I’m trying to call a single report using different filter criteria. For
example DoCmd.OpenReport "rptReport1", acViewPreview, , "[Name] = 'Jones'"
and then DoCmd.OpenReport "rptReport1", acViewPreview, , "[Floor] = 7". When
I do this only the first report is shown in preview mode, is there a way to
pop-up multiple print preview screens?

Thanks in advance,

Jim

 

[Jim]

Gunny,

Sorry - forgot to put that I'm using Access2003. Thanks for the help, I had
all but given up on the idea.

Thanks again,

Jim

Hi, Jim.

When
I do this only the first report is shown in preview mode, is there a way to
pop-up multiple print preview screens?

If you are running Access 2002 or 2003, then you could open the report in
dialog mode:

DoCmd.OpenReport "rptReport1", acViewPreview, , "[Name] = 'Jones'",
acDialog
DoCmd.OpenReport "rptReport1", acViewPreview, , "[Floor] = 7", acDialog

The code will stop running while the first report is open. As soon as the
user closes it, the second report will be opened.

To get a similar effect in an earlier version of Access, you could make a
copy of the report and open the reports in succession. Open the reports in
reverse order, since the last report opened will be "on top" for the user to
view. For example:

DoCmd.OpenReport "rptReport1", acViewPreview, , "[Floor] = 7"
DoCmd.OpenReport "rptReport1Copy", acViewPreview, , "[Name] = 'Jones'

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

I’m trying to call a single report using different filter criteria. For
example DoCmd.OpenReport "rptReport1", acViewPreview, , "[Name] = 'Jones'"
and then DoCmd.OpenReport "rptReport1", acViewPreview, , "[Floor] = 7". When
I do this only the first report is shown in preview mode, is there a way to
pop-up multiple print preview screens?

Thanks in advance,

Jim

 

['69 Camaro]

You're welcome. And since my reply helped you, why not sign into the
Microsoft Online Community using your .Net passport and select the "Yes"
button for the question "Did this post answer your question?" right below my
previous post? That way, the next person who has the same question will be
able to find your marked answer by searching the answer database and won't
have to wait for days for an answer. Questions not marked with answers
(those green check marks) are removed from the "recent posts" database after
a reasonable waiting period in order to make room for new posts.

Thanks! Your help is greatly appreciated.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

Gunny,

Sorry - forgot to put that I'm using Access2003. Thanks for the help, I
had
all but given up on the idea.

Thanks again,

Jim

Hi, Jim.

When
I do this only the first report is shown in preview mode, is there a
way to
pop-up multiple print preview screens?

If you are running Access 2002 or 2003, then you could open the report in
dialog mode:

DoCmd.OpenReport "rptReport1", acViewPreview, , "[Name] = 'Jones'",
acDialog
DoCmd.OpenReport "rptReport1", acViewPreview, , "[Floor] = 7",
acDialog

The code will stop running while the first report is open. As soon as
the
user closes it, the second report will be opened.

To get a similar effect in an earlier version of Access, you could make a
copy of the report and open the reports in succession. Open the reports
in
reverse order, since the last report opened will be "on top" for the user
to
view. For example:

DoCmd.OpenReport "rptReport1", acViewPreview, , "[Floor] = 7"
DoCmd.OpenReport "rptReport1Copy", acViewPreview, , "[Name] = 'Jones'

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message
will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the
question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember
that
questions answered the quickest are often from those who have a history
of
rewarding the contributors who have taken the time to answer questions
correctly.

I'm trying to call a single report using different filter criteria.
For
example DoCmd.OpenReport "rptReport1", acViewPreview, , "[Name] =
'Jones'"
and then DoCmd.OpenReport "rptReport1", acViewPreview, , "[Floor] = 7".
When
I do this only the first report is shown in preview mode, is there a
way to
pop-up multiple print preview screens?

Thanks in advance,

Jim