Question about Office Equipment & Supplies
In Ms Access Reports - How to get Page Totals in the Page Footer Section
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!
curTotal = 0 'Reset the sum to zero each new Page.
If PrintCount = 1 Then curTotal = curTotal + Me.Amount
Me.PageTotal = curTotal
Option Explicit 'Optional, but recommended for every module.
Dim curTotal As Currency 'Variable to sum [Amount] over a Page.
Posted on Jan 17, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Oct 13, 2008 | Office Equipment & Supplies
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.
The following reports may be viewed from the Embedded Web Server:
Printer Server Setup Page
Jul 25, 2012 | Lexmark E260dn Laser Printer
Jul 25, 2011 | HP LaserJet 1200 Printer
Jun 18, 2010 | HP Deskjet D1341 InkJet Printer
Sep 29, 2009 | Pentax PocketJet 3 Plus Portable Printer...
Feb 10, 2009 | Canon ImageRunner 2220I Copier
Feb 01, 2009 | Lexmark Office Equipment & Supplies
Sep 18, 2008 | Lexmark Office Equipment & Supplies
Apr 05, 2008 | Office Equipment & Supplies
245 people viewed this question
Usually answered in minutes!