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  dBforums > PC based Database Applications > Microsoft Access > Print footer on each page that prints

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-30-12, 10:25
LindaSoph LindaSoph is offline
Registered User
 
Join Date: Jan 2012
Posts: 7
Print footer on each page that prints

Tried a report, page & Group footer to print footer data on every page. Of course report and group footer data printed on last page. I need the data in footer to print on EVERY page. Worked with Section Expert check boxes with no success. Any ideas?
Reply With Quote
  #2 (permalink)  
Old 01-30-12, 11:42
Sam Landy Sam Landy is offline
Registered User
 
Join Date: May 2004
Location: New York State
Posts: 931
Are you sure that the page footer is visible? If it isn't, that also means that there are no controls in the section. Even adding VBA code to a section doesn't make it visible. The only ways to make it visible are:

1) Design the report using the report wizard, and fill it out completely and correctly, or

2) Place the cursor on the bottom of the line that's pointed to by the words "Page Footer", and drag it down to reveal some real estate. Then you can add controls as necessary.

Come to think of it, if you use the wizard, you'll always have a page footer, because that's where Access puts the Page information. You probably don't have that either, do you?

For what it's worth, I've been an Access designer for ages, and I still always use the wizards.

Sam
Reply With Quote
  #3 (permalink)  
Old 01-30-12, 12:30
LindaSoph LindaSoph is offline
Registered User
 
Join Date: Jan 2012
Posts: 7
Print footer on each page that prints

Sam,
I am working with an existing report and have tried placing page footer then a report footer and then group footer. Deleting each one and trying another.
The page footer displays blank data when excuted, the report and group footer displayed the data (which is a small amount of data I copied from the header) only on the last page. I would like it displayed on each page printed. Any idea?
Reply With Quote
  #4 (permalink)  
Old 01-30-12, 16:37
Sam Landy Sam Landy is offline
Registered User
 
Join Date: May 2004
Location: New York State
Posts: 931
How about uploading it to the forum so we can have a peek at it?

Sam
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On