Holiday Dates in Footer
in [Reports]
|
From: eckert1961 on 21 Apr 2010 00:41 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? -- Regards, Chris
From: John Spencer on 21 Apr 2010 08:42 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 wrote: > 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?
From: eckert1961 on 21 Apr 2010 10:44 Thanks John. That worked great. I created the subreport in the footer and sized it according to the max size of the list. -- Regards, Chris "John Spencer" wrote: > > 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 wrote: > > 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? > . >
From: eckert1961 on 21 Apr 2010 12:44 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 -- Regards, Chris "eckert1961" wrote: > Thanks John. That worked great. I created the subreport in the footer and > sized it according to the max size of the list. > -- > Regards, > Chris > > > "John Spencer" wrote: > > > > > 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 wrote: > > > 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? > > . > >
|
Pages: 1 Prev: Calculating overtime in report footer Next: Help finding the inches... |