hhammash
asked on
Limit Number of Records Per Page - Access Report
Hi,
I have a list of tutors, each tutor has taught a number of hours. Some teachers have 10 hours and some others have more than 50. The Official form has a place for only 15 hours, "Date, Sign, remarks".
I designed (imitated) the form in Access, it looks fine.
Now how can I limit each form to 15 records or less. If Dr. X has 10 hours, they can fit in one form, if Dr. M has 52 hours, I want the hours to be printed on 4 forms. Also when the Teacher's name changes a new form should begin.
Thanks a lot
I have a list of tutors, each tutor has taught a number of hours. Some teachers have 10 hours and some others have more than 50. The Official form has a place for only 15 hours, "Date, Sign, remarks".
I designed (imitated) the form in Access, it looks fine.
Now how can I limit each form to 15 records or less. If Dr. X has 10 hours, they can fit in one form, if Dr. M has 52 hours, I want the hours to be printed on 4 forms. Also when the Teacher's name changes a new form should begin.
Thanks a lot
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you guys,
I'll try the suggestions.
Nico!
I used the header and footer to display the fixed parts of the form. The details section will have the data. How to mainpulate the details section to print only 15 records without coding?
Thanks
I'll try the suggestions.
Nico!
I used the header and footer to display the fixed parts of the form. The details section will have the data. How to mainpulate the details section to print only 15 records without coding?
Thanks
Just make the height to fit 15 rows.
Optionally you can increase the header of footer by dragging the "bar" or the lowest border of the footer to limit the detailsection size.
Perhaps you can add a line to show the start and end of the detailsection to show the header and footer sections when "tuning" the report on paper.
Nic;o)
Optionally you can increase the header of footer by dragging the "bar" or the lowest border of the footer to limit the detailsection size.
Perhaps you can add a line to show the start and end of the detailsection to show the header and footer sections when "tuning" the report on paper.
Nic;o)
ASKER
Hi,
The details section will grow with the data, if I have 50 records the details section will grow. Can I make it fixed in design?
The details section will grow with the data, if I have 50 records the details section will grow. Can I make it fixed in design?
Hello,
Textboxes, some other controls, and sections have a .CanGrow property. If you choose No, their size is fixed. It is even possible to have growing textboxes on a non-growing section, at the risk of loosing some data if the text is too long. This is used for example on mailing labels.
Cheers!
(°v°)
Textboxes, some other controls, and sections have a .CanGrow property. If you choose No, their size is fixed. It is even possible to have growing textboxes on a non-growing section, at the risk of loosing some data if the text is too long. This is used for example on mailing labels.
Cheers!
(°v°)
ASKER
Hi harfang,
The CanGrow property in the details section is already No, it is this way from the beginning.
The CanGrow property in the details section is already No, it is this way from the beginning.
ASKER
Hi harfang,
I tried your code, the field with source =1 and running sum= over group is a great idea. I did some adjustments to suite my application.
It is working perfectly.
Thanks a lot
I tried your code, the field with source =1 and running sum= over group is a great idea. I did some adjustments to suite my application.
It is working perfectly.
Thanks a lot
I'm gald you it worked for you.
Good luck with your project!
(°v°)
Good luck with your project!
(°v°)
ASKER
Thank you both
For skipping per teacher select the teacherID (Name?) as a grouping when creating the report or by pressing the [= looking button. The indicate a Header is needed for the teacher and add the teacher field(s) to that section.
You can also indicate that the section needs to be repeated and that a pageskip is needed in the properties of the header section (click the header bar).
Nic;o)