Holiday Dates in Footer

[eckert1961]

Hello,

This is for Access 2003. I have a query, qrySpecialDays, and I would like to
get a list of dates to print in the footer section of the report. Currently I
have a textbox in the Page Footer that is bound to the dteSpec fieldname of
the query. When I preview the report only the 1st date from the query results
is displayed. What I want displayed is as follows.

Monday, May 24, 2010
Friday, July 1, 2010
Friday, August 27, 2010

Is it possible to have a list of all dates displayed in the footer?

 

[John Spencer]

To do what you want you would need to put a SUB-Report in the footer that is
based on the qrySpecialDays. And is somehow limited to show you only the
dates you want to see.

One problem: Page footer's do not have a can grow property. The size of Page
Headers and Page Footers are a constant. Therefore you would have to size the
sub-report to fit into the size of the page footer - or size the page footer
to accept the maximum size needed for the maximum number of records returned
and displayed by the sub-report.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[eckert1961]

Thanks John. That worked great. I created the subreport in the footer and
sized it according to the max size of the list.

 

[eckert1961]

I added the following code to the footer's On Format event so that the list
of dates only prints on the 1st page.

Private Sub PageFooter2_Format(Cancel As Integer, FormatCount As Integer)
If Me.Page Mod 2 = 0 Then
Me.PageFooter2.Visible = False
Else
Me.PageFooter2.Visible = True
End If

End Sub