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 / New Users / July 2005

Tip: Looking for answers? Try searching our database.

Printing a report by page

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John - 29 Jul 2005 11:59 GMT
Hi,
   I have a report which shows all  my customers and the totaled amount
they have paid in the previous year. It prints about 12 customers in
landscape format per page, however I want just one customers details per
page so that I can send them a year end statment for each individuals
account. How can I achieve this with Access 2003. Tia, John
Wolfgang Kais - 29 Jul 2005 12:25 GMT
Hello John.

> I have a report which shows all  my customers and the totaled amount
> they have paid in the previous year. It prints about 12 customers in
> landscape format per page, however I want just one customers details
> per page so that I can send them a year end statment for each
> individuals account. How can I achieve this with Access 2003.

I hope you have a group header for something like CustomerID.
In the properties window of that section, set the ForceNewPage
property to "before section".

Signature

Regards,
Wolfgang

John - 30 Jul 2005 12:54 GMT
That worked great Wolfgang tvm, but how can I get the header details to
print on each page, stuff like the logo,company name,etc.At present it is
displayed on only the first page and all the others dont show those details.
> Hi,
>    I have a report which shows all  my customers and the totaled amount
> they have paid in the previous year. It prints about 12 customers in
> landscape format per page, however I want just one customers details per
> page so that I can send them a year end statment for each individuals
> account. How can I achieve this with Access 2003. Tia, John
John - 30 Jul 2005 23:48 GMT
> That worked great Wolfgang tvm, but how can I get the header details to
> print on each page, stuff like the logo,company name,etc.At present it is
[quoted text clipped - 6 lines]
>> page so that I can send them a year end statment for each individuals
>> account. How can I achieve this with Access 2003. Tia, John
 
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.