Adding a Page

[Guest]

in my previous post I said I was having trouble running a report.

If I were able to run it. there is another problem.

the report generates an invoice, but the person who designed the databse,
only made it so the invoice has a maximum of 3 pages; but now some of the
invoices are more than 3 pages, and you have to manually copy paste the
macros and manually input the info, rather than access simply generating the
report in 4+ pages.

how do you fix this.

 

[Guest]

Hi

This sounds a little strange.

You could remove all the forceing of new pages and ssimply set the page size
so that it will run on the correct number of pages for the invoice.

I assume that you have some form of title/summery/etc on the invoice so
leave the force new page in the page and report header and just remove it
from the detail section.

 

[RBear3]

How did they make it 3 pages? Typically an invoice would have a header
section with the customer information, then a detail section with each line
item. That detail section would be a subreport and could contain one item,
or a thousand items. Then, you'd have page footers and report footers as
needed.

Not sure how they built this, but I would consider redoing it. You might
take a look at some of the sample databases available (like Northwind which
ships with Access) and see how their invoice is built.

 

[Guest]

where can get these samples?

How did they make it 3 pages? Typically an invoice would have a header
section with the customer information, then a detail section with each line
item. That detail section would be a subreport and could contain one item,
or a thousand items. Then, you'd have page footers and report footers as
needed.

Not sure how they built this, but I would consider redoing it. You might
take a look at some of the sample databases available (like Northwind which
ships with Access) and see how their invoice is built.

--
Hope that helps!

RBear3
..

 

[Guest]

See answer to post below

 

[RBear3]

The Northwind database ships with Access.