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.

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.


--
Wayne
Manchester, England.



"help1080" wrote:

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

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

"help1080" <(E-Mail Removed)> wrote in message
news:7043D170-6DCE-4EA2-8EF5-(E-Mail Removed)...
> 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.

where can get these samples?

"RBear3" wrote:

> 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
> ..
>
> "help1080" <(E-Mail Removed)> wrote in message
> news:7043D170-6DCE-4EA2-8EF5-(E-Mail Removed)...
> > 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.
>
>
>

See answer to post below

--
Wayne
Manchester, England.



"help1080" wrote:

> where can get these samples?
>
> "RBear3" wrote:
>
> > 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
> > ..
> >
> > "help1080" <(E-Mail Removed)> wrote in message
> > news:7043D170-6DCE-4EA2-8EF5-(E-Mail Removed)...
> > > 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.
> >
> >
> >

The Northwind database ships with Access.

--
Hope that helps!

RBear3
..

"help1080" <(E-Mail Removed)> wrote in message
news:78BD6447-4532-4356-8181-(E-Mail Removed)...
> where can get these samples?
>
> "RBear3" wrote:
>
>> 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
>> ..
>>
>> "help1080" <(E-Mail Removed)> wrote in message
>> news:7043D170-6DCE-4EA2-8EF5-(E-Mail Removed)...
>> > 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.
>>
>>
>>