Results 1 to 10 of 10

Thread: serial no (2k)

  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    serial no (2k)

    Can i do serial No like 1.2.3.4 etc for evry page alone in one report contain 10 pages .
    Ashraf

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: serial no (2k)

    Put an unbound text box txtSerial in the Detail section of the report.
    Add the following code to the report module:

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If FormatCount = 1 Then
    Me.txtSerial = Me.txtSerial + 1
    End If
    End Sub

    Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
    If Me.Page > 1 Then
    Me.txtSerial = 1
    End If
    End Sub

    Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
    Me.txtSerial = 0
    End Sub

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: serial no (2k)

    I'm a little confused. Do you just want to print the Page Number on the report?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: serial no (2k)

    Hello Hanz i do it already but not that i want no serial i found .
    See report ( r_serial )
    Ashraf

  5. #5
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: serial no (2k)

    Up

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: serial no (2k)

    I cannot make the report in your database at all, because my version of Windows/Access does not understand Arabic. I have attached a demo created in an English language version of Windows/Access. I don't know if it will work on your system.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: serial no (2k)

    What do you mean by this?

  8. #8
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: serial no (2k)

    ur attachment file work good but the same i do in my mdb and my mdb not work . i try to found the rong .
    UP= to make my subjext above .
    Thanks
    Ashraf

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: serial no (2k)

    It's OK to "bump" a thread if you don't get a reply for many days, but your previous post was only 8 hours before. As I have told you before, you shouldn't be so impatient - you cannot expect Loungers to reply immediately. We all have other things to do beside answering questions in the Lounge.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: serial no (2k)

    Make sure that you use the correct name for the sections of your report in the code. I used the default English language names Detail, PageHeaderSection and ReportHeader, but in your Arabic language version they have different names.

Posting Permissions

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