A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

printing "blank" pages



 
 
Thread Tools Display Modes
  #11  
Old July 5th, 2005, 09:45 PM
John
external usenet poster
 
Posts: n/a
Default

What I have noticed is that if I don't put anything in details and gradually
increase its height then the number of pages start to increase from 1 and
eventually come to the number of pages required. If I increase it further
then more pages than are records come up!!! So one number appears on more
than one page. Very weird. Is there a sure short way to get the exact number
of pages without resorting to trial and error?

Thanks

Regards

"Rick B" Anonymous wrote in message
...
Well, if you are printing "blank invoices" I'd think you'd have lots of
stuff in the detail section. You aren't trying to simply print a page
with
nothing on it but a number are you?

Just add some controls to the detail section. Make them invisible if you
really don't want to see them.

OR,

Put your invoice number in the detail section and include a PAGE FEED
after
it. There is one in the report toolbox.

--
Rick B



"John" wrote in message
...
Done, no luck. Still one page. The only thing that makes any difference
is
to add anything in detail. Either the invoice number filed or anything

else
such as a box or line.

Regards

"Rick B" Anonymous wrote in message
...
If your invoice number is used as the sort and grouping, just add a

group
header. In the header, put the invoice number. In the group header or
footer properties box, look at the "force new page" feature.

--
Rick B



"John" wrote in message
...
Hi

I need to print "blank" invoices with invoice numbers only at the top.

I
have a table full of invoice numbers which I am using as the record
source
for the invoice report. I have placed the invoice number field on the
page
header and nothing in detail as there are no transactions. The problem

is
that even though there are several invoice number records in the
source
table, the report displays only one page. How can I make the report

print
one page per source table record in this situation?

Thanks

Regards










  #12  
Old July 5th, 2005, 10:00 PM
Rick B
external usenet poster
 
Posts: n/a
Default

Yes, use the suggestion I mentioned to FORCE NEW PAGE AFTER.

--
Rick B



"John" wrote in message
...
What I have noticed is that if I don't put anything in details and

gradually
increase its height then the number of pages start to increase from 1 and
eventually come to the number of pages required. If I increase it further
then more pages than are records come up!!! So one number appears on more
than one page. Very weird. Is there a sure short way to get the exact

number
of pages without resorting to trial and error?

Thanks

Regards

"Rick B" Anonymous wrote in message
...
Well, if you are printing "blank invoices" I'd think you'd have lots of
stuff in the detail section. You aren't trying to simply print a page
with
nothing on it but a number are you?

Just add some controls to the detail section. Make them invisible if

you
really don't want to see them.

OR,

Put your invoice number in the detail section and include a PAGE FEED
after
it. There is one in the report toolbox.

--
Rick B



"John" wrote in message
...
Done, no luck. Still one page. The only thing that makes any difference
is
to add anything in detail. Either the invoice number filed or anything

else
such as a box or line.

Regards

"Rick B" Anonymous wrote in message
...
If your invoice number is used as the sort and grouping, just add a

group
header. In the header, put the invoice number. In the group header

or
footer properties box, look at the "force new page" feature.

--
Rick B



"John" wrote in message
...
Hi

I need to print "blank" invoices with invoice numbers only at the

top.
I
have a table full of invoice numbers which I am using as the record
source
for the invoice report. I have placed the invoice number field on

the
page
header and nothing in detail as there are no transactions. The

problem
is
that even though there are several invoice number records in the
source
table, the report displays only one page. How can I make the report

print
one page per source table record in this situation?

Thanks

Regards












  #13  
Old July 5th, 2005, 10:14 PM
John
external usenet poster
 
Posts: n/a
Default

Now I have. Only one page. It seems that the number of pages printed are
somehow related to the height of the detail section. As I increase height of
detail section I get more and more pages until I have all the pages. If I
increase height further I get more pages than are records!! One number
appears on more than one page. What is this black magic?

Thanks

Regards

PS: A screen shot is attached. At this detail height I get 3 pages while
there are 5 records in the source table.


"Joseph Meehan" wrote in message
.. .
John wrote:
In the preview it shows only one page.


Have you tried actually printing it?


"Joseph Meehan" wrote in message
. ..
John wrote:
Hi

I need to print "blank" invoices with invoice numbers only at the
top. I have a table full of invoice numbers which I am using as the
record source for the invoice report. I have placed the invoice
number field on the page header and nothing in detail as there are
no transactions. The problem is that even though there are several
invoice number records in the source table, the report displays only
one page. How can I make the report print one page per source table
record in this situation?
Thanks

Regards

If I understand you correctly, it should be printing the report,
one page for each Invoice number in the number field in the record
source. Have you actually tried printing it?

--
Joseph Meehan

Dia duit


--
Joseph Meehan

Dia duit






Attached Images
File Type: jpg report.JPG (62.3 KB, 17 views)
  #14  
Old July 6th, 2005, 12:43 AM
Joseph Meehan
external usenet poster
 
Posts: n/a
Default

John wrote:
Now I have. Only one page. It seems that the number of pages printed
are somehow related to the height of the detail section. As I
increase height of detail section I get more and more pages until I
have all the pages. If I increase height further I get more pages
than are records!! One number appears on more than one page. What is
this black magic?
Thanks

Regards

PS: A screen shot is attached. At this detail height I get 3 pages
while there are 5 records in the source table.


Rick is likely right, but if I remember all the stuff I read, you don't
have anything in the detail section. I suggest you the invoice number to
the detail section. Just make the font white so it will not show.


"Joseph Meehan" wrote in message
.. .
John wrote:
In the preview it shows only one page.


Have you tried actually printing it?


"Joseph Meehan" wrote in message
. ..
John wrote:
Hi

I need to print "blank" invoices with invoice numbers only at the
top. I have a table full of invoice numbers which I am using as
the record source for the invoice report. I have placed the
invoice number field on the page header and nothing in detail as
there are no transactions. The problem is that even though there
are several invoice number records in the source table, the
report displays only one page. How can I make the report print
one page per source table record in this situation?
Thanks

Regards

If I understand you correctly, it should be printing the report,
one page for each Invoice number in the number field in the record
source. Have you actually tried printing it?

--
Joseph Meehan

Dia duit


--
Joseph Meehan

Dia duit


--
Joseph Meehan

Dia duit


  #15  
Old July 6th, 2005, 12:44 AM
Joseph Meehan
external usenet poster
 
Posts: n/a
Default

John wrote:
Now I have. Only one page. It seems that the number of pages printed
are somehow related to the height of the detail section. As I
increase height of detail section I get more and more pages until I
have all the pages. If I increase height further I get more pages
than are records!! One number appears on more than one page. What is
this black magic?
Thanks

Regards

PS: A screen shot is attached. At this detail height I get 3 pages
while there are 5 records in the source table.


Forgot to add, make sure you have force new page selected as Rick
suggested.

--
Joseph Meehan

Dia duit


  #16  
Old July 6th, 2005, 02:10 AM
John
external usenet poster
 
Posts: n/a
Default

Ok, putting the invoice no and the page feed control worked. Thanks for all
the help.

Regards

"Rick B" Anonymous wrote in message
...
Yes, use the suggestion I mentioned to FORCE NEW PAGE AFTER.

--
Rick B



"John" wrote in message
...
What I have noticed is that if I don't put anything in details and

gradually
increase its height then the number of pages start to increase from 1 and
eventually come to the number of pages required. If I increase it further
then more pages than are records come up!!! So one number appears on more
than one page. Very weird. Is there a sure short way to get the exact

number
of pages without resorting to trial and error?

Thanks

Regards

"Rick B" Anonymous wrote in message
...
Well, if you are printing "blank invoices" I'd think you'd have lots of
stuff in the detail section. You aren't trying to simply print a page
with
nothing on it but a number are you?

Just add some controls to the detail section. Make them invisible if

you
really don't want to see them.

OR,

Put your invoice number in the detail section and include a PAGE FEED
after
it. There is one in the report toolbox.

--
Rick B



"John" wrote in message
...
Done, no luck. Still one page. The only thing that makes any
difference
is
to add anything in detail. Either the invoice number filed or anything
else
such as a box or line.

Regards

"Rick B" Anonymous wrote in message
...
If your invoice number is used as the sort and grouping, just add a
group
header. In the header, put the invoice number. In the group header

or
footer properties box, look at the "force new page" feature.

--
Rick B



"John" wrote in message
...
Hi

I need to print "blank" invoices with invoice numbers only at the

top.
I
have a table full of invoice numbers which I am using as the record
source
for the invoice report. I have placed the invoice number field on

the
page
header and nothing in detail as there are no transactions. The

problem
is
that even though there are several invoice number records in the
source
table, the report displays only one page. How can I make the report
print
one page per source table record in this situation?

Thanks

Regards














 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
printing "blank" pages John Running & Setting Up Queries 15 July 6th, 2005 02:10 AM
Printing Multiple Pages When One Is Needed Chuck Setting Up & Running Reports 0 March 22nd, 2005 12:33 AM
Printing multiple pages in 1 problem Anthony General Discussion 1 January 10th, 2005 11:18 AM
Printing selected pages from renumbered sections wkrasl General Discussion 1 January 4th, 2005 11:58 PM
Extra pages printing while doing Access Reports J C Desmukes Setting Up & Running Reports 1 September 28th, 2004 10:16 PM


All times are GMT +1. The time now is 03:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.