A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2007 Table Header and Footers



 
 
Thread Tools Display Modes
  #1  
Old February 10th, 2010, 10:45 AM
shirl shirl is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Mar 2005
Posts: 39
Default 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
  #2  
Old February 10th, 2010, 03:22 PM posted to microsoft.public.access.tablesdbdesign
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default Access 2007 Table Header and Footers

No she didn't. 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:


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

  #3  
Old February 10th, 2010, 05:47 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Access 2007 Table Header and Footers

On Wed, 10 Feb 2010 04:45:22 -0500, shirl
wrote:


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


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]
  #4  
Old February 11th, 2010, 11:14 AM
shirl shirl is offline
Experienced Member
 
First recorded activity by OfficeFrustration: Mar 2005
Posts: 39
Default

Thanks for the replies, she has now got round it by exporting to RTF and puting in Headers and Footers.

Shirl
  #5  
Old February 11th, 2010, 01:51 PM
Anne Walter Anne Walter is offline
Member
 
First recorded activity by OfficeFrustration: Feb 2010
Posts: 2
Default

I am Shirley's colleague with the table header issue and you are right - I didn't 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.

[quote=Jerry Whittle;3641093]No she didn't. 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.

QUOTE]
  #6  
Old February 11th, 2010, 01:54 PM
Anne Walter Anne Walter is offline
Member
 
First recorded activity by OfficeFrustration: Feb 2010
Posts: 2
Default

I totally agree with you, but what do I do if a student is asked in an exam to edit a table in Access and the print the table with their name in the header?
Anyway- I found the best solution was to export as rtf, then add a header.


Quote:
Originally Posted by John W. Vinson View Post
On Wed, 10 Feb 2010 04:45:22 -0500

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]
  #7  
Old February 11th, 2010, 08:40 PM posted to microsoft.public.access.tablesdbdesign
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default Access 2007 Table Header and Footers

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 don't 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:


I am Shirley's colleague with the table header issue and you are right -
I didn't 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:
No she didn't. 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.

QUOTE]





--
Anne Walter
.

  #8  
Old February 13th, 2010, 03:20 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default Access 2007 Table Header and Footers

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.


"shirl" wrote in message
...[color=blue][i]

John W. Vinson;3641317 Wrote:
On Wed, 10 Feb 2010 04:45:22 -0500, shirl
wrote:


(snip)


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]


Thanks for the replies, she has now got round it by exporting to RTF and
puting in Headers and Footers.

Shirl




--
shirl



  #9  
Old April 1st, 2010, 09:41 PM posted to microsoft.public.access.tablesdbdesign
Lance Culbert
external usenet poster
 
Posts: 1
Default Headers/Footers in Access Tables

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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.