Multiple tables printed in different sections

  • Thread starter Thread starter NeoFax
  • Start date Start date
N

NeoFax

OK, here is my problem. I have multiple tables with different info
however they have a common thread. The different tables are
Cars/Modifications/Maintenance/Employees. The cars table is linked to
the other tables so that I can check on a car and then any outstanding
modification(Recall) shows and any Maintenance that has been done and
each of these shows the employee. However, I would like to now create a
report that conforms to our company's already created forms. Here is
what it looks like:

=============
Employees Page 1
+++++++++++++
Subsection 1 First 10 Open Maintenance
=============

=============
Next 25 Open Maintenance
+++++++++++++
subsection 1 First 10 Open Modifications
=============

=============
Any remaining Open Maintenance
any remaining Open Modifications
(These two together will come out to 25 records)
+++++++++++++
Any previous Maintenance or Modifications
=============

I do not know how to make the records break at 25 records and then start
off at record 26 on the next page. Same goes with the first 10 write-ups
and then continuing on to the next page. Any suggestions?

NeoFax
 
NeoFax said:
OK, here is my problem. I have multiple tables with different info
however they have a common thread. The different tables are
Cars/Modifications/Maintenance/Employees. The cars table is linked to
the other tables so that I can check on a car and then any outstanding
modification(Recall) shows and any Maintenance that has been done and
each of these shows the employee. However, I would like to now create a
report that conforms to our company's already created forms. Here is
what it looks like:

=============
Employees Page 1
+++++++++++++
Subsection 1 First 10 Open Maintenance
=============

=============
Next 25 Open Maintenance
+++++++++++++
subsection 1 First 10 Open Modifications
=============

=============
Any remaining Open Maintenance
any remaining Open Modifications
(These two together will come out to 25 records)
+++++++++++++
Any previous Maintenance or Modifications
=============

I do not know how to make the records break at 25 records and then start
off at record 26 on the next page. Same goes with the first 10 write-ups
and then continuing on to the next page.
Click to expand...

Not sure I followed all that, but the general idea of
breaking pages after a specific number of records is to use
a conditional Page Break control. The condition is based on
a record counter text box control.

Add a text box named txtRecCount to the detail section. Set
its control source expression to =1 and RunningSum property
to Over Group. You can make it invisible after everything
is working.

Also add a Page Break control at the very bottom of the
detail section and name it pgEject.

Now add code to the detail section's Format event to turn
the page break on or off:

Me.pgEject.Visible = ((txtRecCount + 15) mod 25 = 0)
 
Back
Top