Results 1 to 8 of 8
  1. #1
    farzad_1354 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    5

    Unhappy Report Page Footer Problem in print

    Hi all ,


    I have a report with Report header , page header , page footer
    I did set Page header (Not with Rpt Hdr/Ftr) because i want to show page header showing in page 2 and more not in page 1 , this section work fine

    i want page footer show just in page 1 and i set event like this

    Private Sub PageFooterSection_Print(Cancel As Integer, FormatCount As Integer)
    On Error GoTo Err_PageFooterSection_Print

    Cancel = (Me.Page <> 1)

    Exit_PageFooterSection_Print:
    Exit Sub
    Err_PageFooterSection_Print:
    MsgBox "???"
    Resume Exit_PageFooterSection_Print
    End Sub

    This work fine too .
    i have a command button on my form to preview this report as well
    But problem is , when i preview the report in other pages <> 1 blank space already show instead of page footer
    because of this, i set this event too in report

    Private Sub Report_Page()
    On Error GoTo Err_Report_Page

    If Me.Page >= 1 Then
    Me.Section(4).Visible = False
    End If

    Exit_Report_Page:
    Exit Sub
    Err_Report_Page:
    MsgBox "???"
    Resume Exit_Report_Page
    End Sub

    this work fine in Print preview too ,but my final problem when i print pdf or print hard copy to real printer the page footer is totally gone and just print out the detail
    i hope some one could help me ....

    thanks
    farzad

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Try Page Format event.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    farzad_1354 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    5
    hi June7
    Where is the Page format event , we have not this event !!!!
    i Forgot to say , with my command button i said
    Problem appeared after i use "acPreview" with this DoCmd.OpenReport "ReportName", acPreview
    If i use "acNormal" Problem will be solved but i don't want Report be direct print , i need preview before print
    Thanks before
    farzad

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    That might not be possible. I have a report with some code behind it and have the same issue. If I preview then print the open report it won't print properly but if it goes straight to printer it is fine. You will have to close the report then send direct to printer.

    Select the Page header or footer section then look at the properties sheet. I see Format event but I am using Access 2007/2010. Maybe 2003 doesn't have.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    farzad_1354 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    5
    thanks for your quick reply ,
    in pre post you mentioned page format event , i said this not exist
    page footer and header format exist i know that and i tried those ,it is not different issue.
    as you know that , this is not really good , you say to user just preview report with button 1 and then close it after that with other button print out
    thanks any other idea
    farzad

  6. #6
    farzad_1354 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    5
    isn't any other idea

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    No, that's the same situation I have and no other idea.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    farzad_1354 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    5
    anyway thanks for your time

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How do I not print a page in a report
    By SFC in forum Reports
    Replies: 3
    Last Post: 08-15-2012, 11:47 AM
  2. Replies: 1
    Last Post: 09-14-2011, 05:21 PM
  3. Replies: 3
    Last Post: 08-07-2011, 09:22 PM
  4. Page Breaks and the Report Footer
    By dssrun in forum Reports
    Replies: 4
    Last Post: 05-03-2011, 03:23 PM
  5. Replies: 4
    Last Post: 04-11-2011, 04:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums