Add Page to undound report

[Gary]

Hello All,



I am new to the forum and totally stuck!

I am creating a database at work, and am still relatively new to ms access.

basically what the database does is allows maintenance employees to log equipment breakdowns, then at the end of the day print out a report listing the breakdowns, the down time, etc. as well as a calculated value for the operational availability of the shop. it is important to point out here that the shop is broken into 5 separate zones.

The issue lies in that my employer wants to keep the existing report format (which is an excel spreadsheet). I managed to accomidate this by creating an unbound report and using a VB macro to access the table that stores the logged data and sorts it into text boxes placed over top of an OLE of the spread sheet file. This method works fine, but it limits the number of breakdowns featured on the report to 8 break downs per zone.

I have tried to convince my employer to allow me to change the format, but they are extremely resistant.

is it possible to do something like this:


if #breakdowns in zone (i) >8 then

add page

end if

and then continue logging breakdowns 9 and greater on page 2?

I know it's overly complicated, but it wouldn't be horrible if there were a simple command to add a page and then refer to the controls on the second page independant of those on the first.

thanks in advance,

Gary

[Gary]

Hey all

I see that some people have had a quick look at my issue here. I think I may have found a solution.

what about when the button that opens the report is clicked I use a VB script to open the record set, and quickly check the number of breakdowns in each zone.

if any of the zones have more than 8 breakdowns use a createreportcontrol function to create all the additional controls to generate the form.

if otherwise then set the form back to its default.

the main problem I am running into is the OLE object that I have used to hide the excel spreadsheet format in the background. I don't know how to use the create report control to generate this


is this do able?

-gary