If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Holiday Dates in Footer
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 |
#2
|
|||
|
|||
Holiday Dates in Footer
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? |
#3
|
|||
|
|||
Holiday Dates in Footer
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? . |
#4
|
|||
|
|||
Holiday Dates in Footer
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? . |
Thread Tools | |
Display Modes | |
|
|