Results 1 to 2 of 2

Thread: Help About Ms Access

  1. #1
    zeshan_abasi's Avatar
    zeshan_abasi is offline Senior Member+
    Last Online
    23rd February 2014 @ 12:30 PM
    Join Date
    12 Jan 2008
    Age
    34
    Posts
    318
    Threads
    13
    Credits
    945
    Thanked
    8

    Default Help About Ms Access

    Dear Boass!!

    Kya koi bta skta hai k Ms Access ki reports main header footer ko her page pe kasy fix kia ja skta hai??

    NO BODY LOVES ME....

  2. #2
    registered's Avatar
    registered is offline Senior Member+
    Last Online
    19th June 2010 @ 12:35 PM
    Join Date
    04 Mar 2010
    Location
    Lahore
    Posts
    210
    Threads
    10
    Credits
    1,065
    Thanked
    59

    Default



    in report, add-

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

    If Me.Page = 0 Then Me.Label2.Visible = False 'hide label
    If Me.Page >= 1 Then Me.Label2.Visible = True 'show label

    End Sub


    if it dont work then........use the following

    Click Reports, Create a report in Design view. Click Label in the Toolbox, then click in the Page Header section. Type what you want for the header in the label. That will be at the top of every page of your report. If you want the run date to appear in the header, put a text box in the Page Header section and type "=Date()" as the Control Source for the text box. For page numbers type "=Page()" for the Control Source.
    ------------------------------------------


    ITD Rule..Give Respect & Take respect.. SO simple
    ------------------------------------------------------


Similar Threads

  1. Help about MS Access
    By Aqibsarwar in forum Ask an Expert
    Replies: 2
    Last Post: 26th September 2014, 09:36 PM
  2. need help about Ms Access?
    By MUHAMMAD_ZIA in forum Ask an Expert
    Replies: 0
    Last Post: 9th May 2014, 11:30 AM
  3. what is access ??
    By husnain_shah in forum Ask an Expert
    Replies: 6
    Last Post: 3rd August 2012, 08:21 PM
  4. Replies: 74
    Last Post: 3rd November 2011, 03:32 PM
  5. Help About MS ACCESS
    By mrasif877 in forum Ask an Expert
    Replies: 4
    Last Post: 3rd July 2010, 08:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •