Creating a report that show limited numbers of record.

  • Thread starter Thread starter JoyJoy329
  • Start date Start date
J

JoyJoy329

I'm a self learn Access Beginner and currently I'm creating a database for my
company that needs to create a report that shows 23 records per-page. and in
the same time, once the page are over, i what to show the page heading
again.. can anyone help me with this? (the report is created base on a query
that allows the us to input the period of days we wants to show in the
report. eg. input 7= from today - a week later, what we have to delivery to
the customer.
 
Hi Duane,
I did able to do what you stated in the thread. but as soon as i try to see
the actual report, access keeps telling me that the function me can't be find
and open "me"
 
I expect you entered a line of code into the Property of the On Format. I
should have been more clear that the Me.PgBrk.Visible .... goes into the
module of the report. The actual property should state:
On Format: [Event Procedure]
You can then click the [...] button to the right of the property to open the
code window. That is where you enter the Me.PgBrk.Visible....

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.PgBrk.Visible = (Me.txtCount Mod 23 = 0)
End Sub
 
Back
Top