Question about Printers & Copiers

1 Answer

Page Totals in Reports

Sir,

In Ms Access Reports - How to get Page Totals in the Page Footer Section

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 741 Answers

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!

  1. In the PageHeader's Format event procedure, add:
    curTotal = 0 'Reset the sum to zero each new Page.
  2. In the DetailSection's Print event, add:
    If PrintCount = 1 Then curTotal = curTotal + Me.Amount
  3. Place an unbound control called PageTotal in the Page Footer. In the PageFooter's Format, add:
    Me.PageTotal = curTotal
  4. 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.

Posted on Jan 17, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Repeating print


it's the footer on the page which is printed, deleting the footer on the editing page will solve the problem.

May 04, 2013 | HEWLETT-PACKARD CP1525NW Laser Printer

3 Answers

Problem printing MS access report on SEP 350PLUS printer


when you change the paper size do you click--- apply--- that is necessary.

Oct 13, 2008 | Printers & Copiers

1 Answer

How can I print a configuration page from the E260dn Lexmark?


Type the printer IP address into the address field of your Web browser.

Note: If you do not know the IP address of the printer, then print a network setup page and locate the IP address

in the TCP/IP section.

Click Reports.

The following reports may be viewed from the Embedded Web Server:

Reports

Device Statistics

Device Settings

Device Information

Profiles List
Printer Server Setup Page

Jul 25, 2012 | Lexmark E260dn Laser Printer

1 Answer

Have been unable to print web pages, emails, etc. When I go to print preview all I see is a blank page. same when I print. All I get is a header: page 1 of 1 and a footer: file://c:\ docume...


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.

Jul 25, 2011 | HP LaserJet 1200 Printer

2 Answers

Disable footer header


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

Sep 29, 2009 | Pentax PocketJet 3 Plus Portable Printer...

1 Answer

Detailed reports of when copies were made


Is this what u want ?????



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 Totals Page Totals.
6. Print List.

Feb 10, 2009 | Canon ImageRunner 2220I Copier

1 Answer

Remove from text


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.

Feb 01, 2009 | Lexmark Printers & Copiers

1 Answer

Printer will not print web pages


have you check your PAGE SETUP under the FILE option at the menu bar at the top of IE.

The PAGE SETUP settings ahould look like this:

PAGE
---------------------

SIZE:
-------------
LETTER

SOURCE:
-----------------
AUTOSELECT

Header and Footer:
----------------------------

Header
&w&bPage &p of &P

Footer
&u&b&d

Orientation
-------------------
PORTRAIT

-----------------------------

All margins (inches) set to: 0.75

Also, try these sites:

http://www.windows-help.net/windows98/ie50-17.htm

http://www.akalg.com/pub/webref/print/faq.htm#q008

Sep 18, 2008 | Lexmark Printers & Copiers

1 Answer

MY PRINTER DOES NOT LABEL IT'S Pages


What application are you printing from? Basically its the software that handles these features

Try this:

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.

Apr 05, 2008 | Printers & Copiers

Not finding what you are looking for?
Printers & Copiers Logo

Related Topics:

245 people viewed this question

Ask a Question

Usually answered in minutes!

Top Printers & Copiers Experts

kakima

Level 3 Expert

96396 Answers

old marine
old marine

Level 3 Expert

1461 Answers

Donald DCruz
Donald DCruz

Level 3 Expert

17129 Answers

Are you a Printer and Copier Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...