Need big time help with report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Busch - 08 Jan 2006 23:57 GMT

I have set up a report from a query which prints a invoice type report. I
tired to write code to only print one report at a time. I couldn't get that
code so I tried only bringing up one record by using a parameter in the
query. When I print the report I get the report the way I need it, in an
invioce looking print, then I get a blank page, then I get everything for one
table, and nothiong form the table assigned as a subform, and then another
blank page. Can anyone help. Thanks

Reply to this Message

Duane Hookom - 09 Jan 2006 01:31 GMT

Blank pages usually suggests your report width plus your left and right
margins is greater than your page/paper width.

There is information at http://www.fontstuff.com/access/acctut08.htm
describing how to limit a report output to a single record.

Signature

Duane Hookom
MS Access MVP
--

>I have set up a report from a query which prints a invoice type report. I
> tired to write code to only print one report at a time. I couldn't get
[quoted text clipped - 5 lines]
> table, and nothiong form the table assigned as a subform, and then another
> blank page. Can anyone help. Thanks

Reply to this Message

Mike Busch - 09 Jan 2006 23:00 GMT

Thanks for the tip on the blamk pages, but now I get the the report I want
and on the second page I get the header and footer printed. Is there any way
to get rid of them. Thanks. My goal here is to have only the report print the
one full page. Like I saide it's printing that on the first page and the same
header and footer on the second page. Thanks again

> Blank pages usually suggests your report width plus your left and right
> margins is greater than your page/paper width.
[quoted text clipped - 11 lines]
> > table, and nothiong form the table assigned as a subform, and then another
> > blank page. Can anyone help. Thanks

Reply to this Message

Duane Hookom - 10 Jan 2006 02:42 GMT

I can't tell without knowing where the blank page is coming from. Figure it
out and maybe someone can tell you how to get rid of it.

Signature

Duane Hookom
MS Access MVP
--

> Thanks for the tip on the blamk pages, but now I get the the report I want
> and on the second page I get the header and footer printed. Is there any
[quoted text clipped - 24 lines]
>> > another
>> > blank page. Can anyone help. Thanks

Reply to this Message