Write Name of Report Query in Report Footer
in [Reports]
|
Prev: Hide Sub Report(s) when records are null
Next: Sorting/Grouping ... Show a month if Zero (Access 2007)
From: Steve Stad on 24 May 2010 09:33 Is it possible to programmatically write the name of the query the report is based on in a text box in the report footer.
From: Allen Browne on 24 May 2010 09:55 "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message news:A1B0F793-C14A-4101-AB45-807BE72A4A11(a)microsoft.com... > Is it possible to programmatically write the name of the query the report > is based on in a text box in the report footer. Place a text box on your report, and set its Control Source property to: =[Report].[RecordSource] -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
From: Steve Stad on 24 May 2010 10:59
Thank you mate. "Allen Browne" wrote: > "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message > news:A1B0F793-C14A-4101-AB45-807BE72A4A11(a)microsoft.com... > > Is it possible to programmatically write the name of the query the report > > is based on in a text box in the report footer. > > Place a text box on your report, and set its Control Source property to: > =[Report].[RecordSource] > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. > > . > |