Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / January 2006

Tip: Looking for answers? Try searching our database.

How to create multi pages invoice report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vensia - 29 Dec 2005 15:06 GMT
Dear all,

Please help me how to create multi pages invoice report.
Thanks.

Vensia
Allen Browne - 29 Dec 2005 15:36 GMT
Please clarify.

Do you mean you want to print 2 copies of the same invoices, such as an
"Original" and a "Copy"?

Or do you mean an invoice with lots of items so that it runs over multiple
pages?

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Dear all,
>
> Please help me how to create multi pages invoice report.
> Thanks.
>
> Vensia
Vensia - 30 Dec 2005 02:23 GMT
I mean an invoice with lots of items.
I want the invoice footer (such as signature, invoice amount) is printed at
the fixed position and last page, so I put the invoice footer at page
footer. I put several vertical lines at Detail section. Can I make the
vertical line at detail section to be printed until below although the
invoice contains few items ?
Because the invoice footer just printed at the last page, there is a  blank
space at the pages before the past page which if it's possible, I can use it
to print several items more. How to do it if it's possible ?
Thanks.

> Please clarify.
>
[quoted text clipped - 15 lines]
> >
> > Vensia
Allen Browne - 30 Dec 2005 03:26 GMT
Before the days of computers, the printed invoice form would have the
summary at the bottom of the page, because there was no way to know how many
items would be needed at the time the page was printed. This is no longer
the case. In fact, a good argument could be made that placing the summary
immediately after the last item helps prevent the fraudlent addition of
items being typed onto the printed invoice that are not included in the
total at the bottom. Trying to make the computerized invoice fit the
old-school look is counter-productive (i.e. wasted effort that decreases
reliability.)

If you want to do it anyway, it sounds like you have simulated it with
unbound controls in the page footer. This works, but has the side-effect of
making that space unusable on previous pages of the invoice. Another
approach is to identify the last item in the invoice, and in the Format
event of the Detail section, continue to print the space for that item until
you are far enough down the page to print the report/group footer. You can
do that by toggling the report's runtime properties (PrintSection,
MoveLayout, NextRecord) until the report's Top property is far enough down
the page. (Top is in twips, where 1440 twips = 1 inch.) This is still quite
messy if the section CanGrow.

To get vertical lines on the page, use the Line method in the Page event of
the report.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I mean an invoice with lots of items.
> I want the invoice footer (such as signature, invoice amount) is printed
[quoted text clipped - 23 lines]
>> > Please help me how to create multi pages invoice report.
>> > Thanks.
Vensia - 30 Dec 2005 13:28 GMT
So you mean that it's better I put the invoice summary at the report footer
section than the page footer section ?
For your information, the item description Can Grow.
My user also want there is a total summary for each page and the total
summary will be brought to the next page and placed before the first row of
item. How to do it ?
Why the line width made by  Line control and Line method can't be same ?
Thanks.

> Before the days of computers, the printed invoice form would have the
> summary at the bottom of the page, because there was no way to know how many
[quoted text clipped - 52 lines]
> >> > Please help me how to create multi pages invoice report.
> >> > Thanks.
Allen Browne - 30 Dec 2005 15:03 GMT
To get a progressive aggregate of the Amount field in a report, add a text
box with these properties:
   Control Source        =[Amount]
   Running Sum          Over Group
   Format                   Currency
   Visible                    No
   Name                     txtAmountRS

Now in the Page Footer section, you can add a text box with Control Source:
   =[txtAmountRS]

You can set the ScaleMode property if you wish, but I find it easiest to
work in twips.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> So you mean that it's better I put the invoice summary at the report
> footer
[quoted text clipped - 73 lines]
>> >> > Please help me how to create multi pages invoice report.
>> >> > Thanks.
Vensia - 31 Dec 2005 03:52 GMT
Thanks for your help. But I want the Amount at the first page bring the
second page and put before the first line of item, and so forth. How to do
it?
Thanks.

> To get a progressive aggregate of the Amount field in a report, add a text
> box with these properties:
[quoted text clipped - 92 lines]
> >> >> > Please help me how to create multi pages invoice report.
> >> >> > Thanks.
Allen Browne - 31 Dec 2005 04:24 GMT
Use the Page Header to show the running total.
Text box with Control Source of:
   =[txtAmountRS]

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks for your help. But I want the Amount at the first page bring the
> second page and put before the first line of item, and so forth. How to do
[quoted text clipped - 110 lines]
>> >> >> > Please help me how to create multi pages invoice report.
>> >> >> > Thanks.
Vensia - 04 Jan 2006 01:46 GMT
Thanks Allen for helping.

> Use the Page Header to show the running total.
> Text box with Control Source of:
[quoted text clipped - 119 lines]
> >> >> >> > Please help me how to create multi pages invoice report.
> >> >> >> > Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.