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...e-for-web.aspx
Similar Threads
