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 » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

printing "blank" pages



 
 
Thread Tools Display Modes
  #1  
Old July 5th, 2005, 05:46 PM
John
external usenet poster
 
Posts: n/a
Default printing "blank" pages

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


  #2  
Old July 5th, 2005, 06:17 PM
Joseph Meehan
external usenet poster
 
Posts: n/a
Default

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


  #3  
Old July 5th, 2005, 06:22 PM
John
external usenet poster
 
Posts: n/a
Default

In the preview it shows only one page.

"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



  #4  
Old July 5th, 2005, 06:33 PM
Wayne Morgan
external usenet poster
 
Posts: n/a
Default

You say your are placing the Invoice Numbers "at the top". Which report
section have you placed the textbox in that contains the invoice numbers?

--
Wayne Morgan
MS Access MVP


"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




  #5  
Old July 5th, 2005, 07:25 PM
Rick B
external usenet poster
 
Posts: n/a
Default

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




  #6  
Old July 5th, 2005, 07:44 PM
John
external usenet poster
 
Posts: n/a
Default

page header

"Wayne Morgan" wrote in message
...
You say your are placing the Invoice Numbers "at the top". Which report
section have you placed the textbox in that contains the invoice numbers?

--
Wayne Morgan
MS Access MVP


"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






  #7  
Old July 5th, 2005, 07:46 PM
John
external usenet poster
 
Posts: n/a
Default

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






  #8  
Old July 5th, 2005, 07:52 PM
Rick B
external usenet poster
 
Posts: n/a
Default

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








  #9  
Old July 5th, 2005, 07:53 PM
Rick B
external usenet poster
 
Posts: n/a
Default

You could also put your invoice number in the detail section and then use
the "force new page" property.

--
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








  #10  
Old July 5th, 2005, 09:12 PM
Joseph Meehan
external usenet poster
 
Posts: n/a
Default

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


 




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 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
Prevent Blank Records being written. Need Help. Robert Nusz @ DPS Using Forms 4 December 29th, 2004 05:15 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 01:53 PM.


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