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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 one page per source table record in this situation? Thanks Regards |
#12
|
|||
|
|||
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 one page per source table record in this situation? Thanks Regards |
#13
|
|||
|
|||
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 |
#14
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 one page per source table record in this situation? Thanks Regards |
|
Thread Tools | |
Display Modes | |
|
|
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 |