Solved

MS Access conditionally print a group footer

Posted on 2011-02-16
3
494 Views
Last Modified: 2012-05-11
In an Access report I need to print a group footer if the date range is more than 1 day. If not I need to suppress the group footer altogether. I have code in the in the On Format property of the group footer where I compare the dates. This appears to work but I do not know the code to suppress the group footer. Your assistance is appreciated. Thanks.
0
Comment
Question by:StampIT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
RgGray3 earned 250 total points
ID: 34909392
If you have the logic worked out to decide to cancel the printing of the section

use the Cancel property of the section

Private Sub GroupFooter0_Print(Cancel As Integer, PrintCount As Integer)

    If...  your logic
         Cancel = True
    End if


From microsofts help
"The Print event occurs after data in a report section is formatted for printing, but before the section is printed. "

0
 

Author Closing Comment

by:StampIT
ID: 34917120
Thanks for the help
0
 
LVL 11

Expert Comment

by:RgGray3
ID: 34918102
Glad to help...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question