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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Add a Footer to a Table



 
 
Thread Tools Display Modes
  #1  
Old June 24th, 2009, 05:15 PM posted to microsoft.public.access.gettingstarted
RS
external usenet poster
 
Posts: 171
Default Add a Footer to a Table

Is it possible to add a footer (or header) to a table in Access 2003? If so,
how do I go about doing this? I can add one to a form, report, etc., but
cannot find where I can do this for a table if I want to print it out.

Thanks!
  #2  
Old June 24th, 2009, 05:22 PM posted to microsoft.public.access.gettingstarted
Beetle
external usenet poster
 
Posts: 1,254
Default Add a Footer to a Table

Not possible. Tables are for data storage only. They are
not intended for data entry, editing, printing, etc.
--
_________

Sean Bailey


"RS" wrote:

Is it possible to add a footer (or header) to a table in Access 2003? If so,
how do I go about doing this? I can add one to a form, report, etc., but
cannot find where I can do this for a table if I want to print it out.

Thanks!

  #3  
Old June 24th, 2009, 05:29 PM posted to microsoft.public.access.gettingstarted
RS
external usenet poster
 
Posts: 171
Default Add a Footer to a Table

Thank you. However, technically can't you can enter data, edit your data,
and print your data in tables? I am assuming you mean you cannot change the
structure of the table like you can a form or report. Is that correct?

I appreciate your quick response.
"Beetle" wrote:

Not possible. Tables are for data storage only. They are
not intended for data entry, editing, printing, etc.
--
_________

Sean Bailey


"RS" wrote:

Is it possible to add a footer (or header) to a table in Access 2003? If so,
how do I go about doing this? I can add one to a form, report, etc., but
cannot find where I can do this for a table if I want to print it out.

Thanks!

  #4  
Old June 24th, 2009, 05:53 PM posted to microsoft.public.access.gettingstarted
Fred
external usenet poster
 
Posts: 1,451
Default Add a Footer to a Table


A table is a bunch of bits in the computer, so let's assuming that you are
talkinig about the direct table view screen. You shouldn't do any of those
things there.
  #5  
Old June 24th, 2009, 05:56 PM posted to microsoft.public.access.gettingstarted
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Add a Footer to a Table

Yes, technically you can enter data, edit your data and print your data in
tables. That doesn't mean it's appropriate to do so though!

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"RS" wrote in message
...
Thank you. However, technically can't you can enter data, edit your data,
and print your data in tables? I am assuming you mean you cannot change
the
structure of the table like you can a form or report. Is that correct?

I appreciate your quick response.
"Beetle" wrote:

Not possible. Tables are for data storage only. They are
not intended for data entry, editing, printing, etc.
--
_________

Sean Bailey


"RS" wrote:

Is it possible to add a footer (or header) to a table in Access 2003?
If so,
how do I go about doing this? I can add one to a form, report, etc.,
but
cannot find where I can do this for a table if I want to print it out.

Thanks!



  #6  
Old June 24th, 2009, 06:25 PM posted to microsoft.public.access.gettingstarted
fredg
external usenet poster
 
Posts: 4,386
Default Add a Footer to a Table

On Wed, 24 Jun 2009 09:29:01 -0700, RS wrote:

Thank you. However, technically can't you can enter data, edit your data,
and print your data in tables? I am assuming you mean you cannot change the
structure of the table like you can a form or report. Is that correct?

I appreciate your quick response.
"Beetle" wrote:

Not possible. Tables are for data storage only. They are
not intended for data entry, editing, printing, etc.
--
_________

Sean Bailey

"RS" wrote:

Is it possible to add a footer (or header) to a table in Access 2003? If so,
how do I go about doing this? I can add one to a form, report, etc., but
cannot find where I can do this for a table if I want to print it out.

Thanks!


Printing the table already includes a built-in Header and Footer,
which is Table Name and Date in the header, and Page Number in the
footer (all you need do is set the top and bottom margins large enough
to display them. Try 1 inch.)

Yes, you can do all of those things you mentioned, however since
tables are not DESIGNED for printing you have no options such as
changing the header or footer.
Why not print the table data correctly and create a report. Now you
can set up a Report/PageHeader and Report/Page Footer with whatever
information you wish.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #7  
Old June 24th, 2009, 08:03 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Add a Footer to a Table

You can drive nails with a chainsaw. Not recommended, but you can do it.
Neither safe nor accurate.

Access forms and reports display data. Access tables store data.

Just because an Access table looks like a spreadsheet doesn't mean that it
is one...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"RS" wrote in message
...
Thank you. However, technically can't you can enter data, edit your data,
and print your data in tables? I am assuming you mean you cannot change
the
structure of the table like you can a form or report. Is that correct?

I appreciate your quick response.
"Beetle" wrote:

Not possible. Tables are for data storage only. They are
not intended for data entry, editing, printing, etc.
--
_________

Sean Bailey


"RS" wrote:

Is it possible to add a footer (or header) to a table in Access 2003?
If so,
how do I go about doing this? I can add one to a form, report, etc.,
but
cannot find where I can do this for a table if I want to print it out.

Thanks!



  #8  
Old June 24th, 2009, 08:57 PM posted to microsoft.public.access.gettingstarted
RS
external usenet poster
 
Posts: 171
Default Add a Footer to a Table

I appreciate all of the responses. They were very helpful. All of your
advise is well taken and I will put it into practice.

Thank you all!!

"Jeff Boyce" wrote:

You can drive nails with a chainsaw. Not recommended, but you can do it.
Neither safe nor accurate.

Access forms and reports display data. Access tables store data.

Just because an Access table looks like a spreadsheet doesn't mean that it
is one...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"RS" wrote in message
...
Thank you. However, technically can't you can enter data, edit your data,
and print your data in tables? I am assuming you mean you cannot change
the
structure of the table like you can a form or report. Is that correct?

I appreciate your quick response.
"Beetle" wrote:

Not possible. Tables are for data storage only. They are
not intended for data entry, editing, printing, etc.
--
_________

Sean Bailey


"RS" wrote:

Is it possible to add a footer (or header) to a table in Access 2003?
If so,
how do I go about doing this? I can add one to a form, report, etc.,
but
cannot find where I can do this for a table if I want to print it out.

Thanks!




 




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 11:40 PM.


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