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 » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Deleting page headers on pages w/o records



 
 
Thread Tools Display Modes
  #1  
Old May 26th, 2010, 09:41 PM posted to microsoft.public.access.reports
WebJunkey
external usenet poster
 
Posts: 2
Default Deleting page headers on pages w/o records

Hey guys, first post, be gentle.

Doing my first access 2003/2007 report (file format is access 2003 but using
2007 as a front end, mainly due to network issues, but thats another issue)
and i'm running into an issue where the report won't stop putting the record
headers on pages w/o records (ie, footer section has its own page w/ just a
text label). Currently, i have the text for the fields in the 'page header'
section (which is probably why its popping up on every page), but if i try
giving it its own section, it only shows the text for the fields on the first
page, and not other pages.

Thanks in advance.

  #2  
Old May 26th, 2010, 09:49 PM posted to microsoft.public.access.reports
WebJunkey
external usenet poster
 
Posts: 2
Default Deleting page headers on pages w/o records

WebJunkey wrote:
Hey guys, first post, be gentle.

Doing my first access 2003/2007 report (file format is access 2003 but using
2007 as a front end, mainly due to network issues, but thats another issue)
and i'm running into an issue where the report won't stop putting the record
headers on pages w/o records (ie, footer section has its own page w/ just a
text label). Currently, i have the text for the fields in the 'page header'
section (which is probably why its popping up on every page), but if i try
giving it its own section, it only shows the text for the fields on the first
page, and not other pages.

Thanks in advance.



...on a side note, any suggestions on a good, more on the technical than
beginner side, for access? Note i'm using access 2003 file format but 2007
as the front end, so i'm not sure which copy i should pick up (2003 or 2007
access book).

Thanks again.

  #3  
Old May 27th, 2010, 02:09 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Deleting page headers on pages w/o records

WebJunkey wrote:
Doing my first access 2003/2007 report (file format is access 2003 but using
2007 as a front end, mainly due to network issues, but thats another issue)
and i'm running into an issue where the report won't stop putting the record
headers on pages w/o records (ie, footer section has its own page w/ just a
text label). Currently, i have the text for the fields in the 'page header'
section (which is probably why its popping up on every page), but if i try
giving it its own section, it only shows the text for the fields on the first
page, and not other pages.



Which footer?

If it's the report footer, then try setting the report's
PageHeader property to Not With Rpt Footer.

If it's a group footer, then it gets tricky, especially if
the group footer is sometimes on the same page as the last
detail and sometimes not. Please provide more specific
details about the footer.

--
Marsh
MVP [MS Access]
  #4  
Old May 27th, 2010, 10:03 PM posted to microsoft.public.access.reports
WebJunkey via AccessMonster.com
external usenet poster
 
Posts: 2
Default Deleting page headers on pages w/o records

Marshall Barton wrote:
Doing my first access 2003/2007 report (file format is access 2003 but using
2007 as a front end, mainly due to network issues, but thats another issue)

[quoted text clipped - 4 lines]
giving it its own section, it only shows the text for the fields on the first
page, and not other pages.


Which footer?

If it's the report footer, then try setting the report's
PageHeader property to Not With Rpt Footer.

If it's a group footer, then it gets tricky, especially if
the group footer is sometimes on the same page as the last
detail and sometimes not. Please provide more specific
details about the footer.


I found the little check box to fix my issue finally, but ty for the help.
The report footer wasn't an issue, the issue was the labels i had on top of
columns of data was printed on the top of pages that had no data. TY for the
timely response though.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201005/1

 




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 08:30 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.