Printing the current page being used

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul M - 22 Dec 2005 19:08 GMT

I am writing a database that transmits information to a report for leases, I
would like to print only the current page (in the form) that I am using from
the report, but everytime I click the "print report" button, the entire
report (every page in it) prints out. what settings do I use in the macro
for the report to ensure I am only printing the pages that I want?

Paul M

Reply to this Message

Marshall Barton - 22 Dec 2005 19:36 GMT

>I am writing a database that transmits information to a report for leases, I
>would like to print only the current page (in the form) that I am using from
>the report, but everytime I click the "print report" button, the entire
>report (every page in it) prints out. what settings do I use in the macro
>for the report to ensure I am only printing the pages that I want?

Modify your macro to use the OpenReport action's
WhereCondition argument with a reference to the record's
primary key.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Klatuu - 22 Dec 2005 19:38 GMT

Use the Where Condition arguement of the OpenReport method. You can do that
in the Click Event of the print report button before you open the report.
If you look in the VB Editor Help for OpenReport, you will find an example
of how it works.

> I am writing a database that transmits information to a report for leases, I
> would like to print only the current page (in the form) that I am using from
[quoted text clipped - 3 lines]
>
> Paul M

Reply to this Message

Paul M - 23 Dec 2005 17:57 GMT

ok, I've located the "where condition" in the macro, but I am still unclear
as to what I am supposed to do. I am not a VB guru so it is still greek to
me, if I could have someone walk me through this I could finish my project.

Paul M

> Use the Where Condition arguement of the OpenReport method. You can do that
> in the Click Event of the print report button before you open the report.
[quoted text clipped - 8 lines]
> >
> > Paul M

Reply to this Message