An expert who has achieved level 3 by getting 1000 points
An expert that got 10 achievements.
An expert that got 5 achievements.
An expert whose answer got voted for 100 times.
Re: Page Totals in Reports
Reports: Page Totals
Each section of a report has a Format event, where you can alter properties such as Visible, Color, Size, etc in a manner similar to the Current in a form. (See Runtime Properties: Forms for details.) For example to force a page break when certain conditions are met, include a PageBreak control in the Detail Section and toggle its Visible property. In addition, the Print event can be used to perform tasks like adding the current record to a running total.
You have an Amount field, and want to display the Amount total for that page in the Page Footer. Totals are not normally available in the Page Footer, but the task requires just four lines of code!
In the PageHeader's Format event procedure, add: curTotal = 0 'Reset the sum to zero each new Page.
In the DetailSection's Print event, add: If PrintCount = 1 Then curTotal = curTotal + Me.Amount
Place an unbound control called PageTotal in the Page Footer. In the PageFooter's Format, add: Me.PageTotal = curTotal
In the Code Window under Declarations enter: Option Explicit 'Optional, but recommended for every module. Dim curTotal As Currency 'Variable to sum [Amount] over a Page.
That's it! Don't forget to rate 4 stars for this solution.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
1) Make sure your hp 1200 is selected as your DEFAULT printer.
2) Check to make sure that it will/will not print standard wordprocessing doecuments from MS Word, MS Wors, etc. If iot does go to next step.
3) Turn the printer off, unplug it from the computer, them unplug the power from the printer. . wait 3 minutes, then power up again. Try printing again. If not successful, go to next step.
3) Unplug the printer's USB cable from the computer. Uninstall, then reinstall the printer's driver software from the original CD that came with the printer. Follow the prompts during the installation and plug the printer's USB cable into the computer whan prompted. Test print again.
If are using Vista or Windows 7 operating system, go to VIEW at the top of the document you are going to print and in the drop down under VIEW select and click on the FOOTER & HEADER and click on it.Then when the Footer & Header page comes up DELET everything in both of them and then on the right of the Footer & Header click on CLOSE and it should take care of the problem.
This also applies to other Operating System’s. Hope this helps, Bud
To Print out the Department ID Print totals: 1. Select Additional Functions on the Control Panel. 2. Select System Settings. 3. Department ID Management. 4. Select On 5. Select Print TotalsPage Totals. 6. Print List.
depending on the program you are using - you may need to go into the page setup section or footer section and either disable the footer or delete "confidential" from the footer section so that it doesn't print on your documents. Text in a header/footer will not display on the screen you are working on but will print on the final page.
What application are you printing from? Basically its the software that handles these features
Please try the following:
1. Have your document up on your screen. 2. Click on "INSERT" "PAGE NUMBERS". 3. Select the options you prefer (as header or footer), (right, left, center, inside outside, etc.). 4. Make sure that these page numbers are not outside of the printable area or margin area.
If you are placing the page numbers as a footer:
1. Click on "FILE" "PRINT". 2. Click on "PROPERTIES". 3. Click on the "PAPER" tab. 4. Choose "MAXIMUM". 5. Click on "YES".
This will enlarge your printable area so that you can set your bottom margin as small as .12 inches. This will help in printing the page numbers as a footer.
If this does not resolve your issue, please contact Microsoft for further assistance. This particular issue is software related.