Headers/Footers in Access Tables
in [Tables]
|
From: Lance on 1 Apr 2010 16:41 If you don't want to construct a report but want to include a header/footer, just push the table out to Excel. In Access 2007, open the table. In the External Data tab, go to the Export group and select Excel. The table data will be pushed out to Excel and you can add the header/footer you want easily without messing with a report. Anne Walter wrote: I am Shirley's colleague with the table header issue and you are right -I did 11-Feb-10 I am Shirley's colleague with the table header issue and you are right - I did not create the table with the header/heading. I presume it was made with an earlier version of Access. But I have the table open in print preview clearly showing a header. Jerry Whittle;3641093 Wrote: -- Anne Walter Previous Posts In This Thread: On Wednesday, February 10, 2010 4:45 AM shirl wrote: Access 2007 Table Header and Footers Hi A colleague wants to know if it is possible to put a header and footer in a table in Access 2007, she used to be able to do it in previous versions. I have had a look and cannot find a way of doing it, I know that a report could be setup as a table but she does not want to use a report. Shirl -- shirl On Wednesday, February 10, 2010 9:22 AM Jerry Whittle wrote: No she did not. You can have header and footers in a report or form though. No she did not. You can have header and footers in a report or form though. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "shirl" wrote: On Wednesday, February 10, 2010 11:47 AM John W. Vinson wrote: Tables are for data storage.Forms are for data display and interaction. Tables are for data storage. Forms are for data display and interaction. Reports are for printing. Use the right tool for the job!!! Tables do NOT have headers and footers (and never have). I suspect your friend was either using a continuous Form (which does have headers and footers and shows one row per record) or a Report. -- John W. Vinson [MVP] On Thursday, February 11, 2010 5:14 AM shirl wrote: John W. John W. Vinson;3641317 Wrote: Thanks for the replies, she has now got round it by exporting to RTF and puting in Headers and Footers. Shirl -- shirl On Thursday, February 11, 2010 7:51 AM Anne Walter wrote: I am Shirley's colleague with the table header issue and you are right -I did I am Shirley's colleague with the table header issue and you are right - I did not create the table with the header/heading. I presume it was made with an earlier version of Access. But I have the table open in print preview clearly showing a header. Jerry Whittle;3641093 Wrote: -- Anne Walter On Thursday, February 11, 2010 2:40 PM Jerry Whittle wrote: Hi Anne,By default it shows the table or query name and date on the top and Hi Anne, By default it shows the table or query name and date on the top and the page number on the bottom when printing. However I do not know of any way to change these to put something like a company name up there. You have much more control with a report. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Anne Walter" wrote: On Saturday, February 13, 2010 9:20 AM Jeff Boyce wrote: That's certainly a solution.... That's certainly a solution. .... but it seems like a lot more work than simply using the built-in tool Access provides, i.e., a Report. -- Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. Submitted via EggHeadCafe - Software Developer Portal of Choice File-Based Cache for Web and non-Web Apps plus Extend ASP.NET 4.0 OutputCacheProvider http://www.eggheadcafe.com/tutorials/aspnet/56161e9e-7fa3-48e8-9dfe-9f7a28f4d58e/filebased-cache-for-web.aspx
|
Pages: 1 Prev: Choices to display dependent on previous choices... Next: Writing and IIf statement in Access? |