serial no (2k)

[ashrafk]

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

[HansV]

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

[MarkLiquorman]

I'm a little confused. Do you just want to print the Page Number on the report?

[ashrafk]

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

[ashrafk]

Up

[HansV]

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.

[HansV]

What do you mean by this?

[ashrafk]

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

[HansV]

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.

[HansV]

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.