 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Adding a Page
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.  SignatureWayne Manchester, England. > in my previous post I said I was having trouble running a report. > [quoted text clipped - 7 lines] > > 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. SignatureHope that helps! RBear3 . > in my previous post I said I was having trouble running a report. > [quoted text clipped - 8 lines] > > how do you fix this. 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 [quoted text clipped - 18 lines] > > > > how do you fix this. See answer to post below SignatureWayne Manchester, England. > where can get these samples? > [quoted text clipped - 20 lines] > > > > > > how do you fix this. The Northwind database ships with Access. SignatureHope that helps! RBear3 . > where can get these samples? > [quoted text clipped - 26 lines] >> > >> > how do you fix this. |
Reply to this Message |
 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.