Report Group headers etc

[mousemat]

Any advice here would be great....

I have DB which will allow engineers to print a copy of the H & S Policy and Method Statement when they go on site.

Basically, the only changeable values on the report are company name, site details and engineer name. These all go on the first page. The other 5 pages are just static text.

Im at a loss as to how to set this up on a report. I have tried the grouping thing but can't seem to get to grip with it.

Any help would be great.

 

[pbaldy]

One option would to provide a form for the user to input each of those pieces of info, and the control source of a textbox on the report would point to it:

=Forms!FormName.ControlName

The form could be bound to a table if you wanted to save the info.

 

[mousemat]

Hi Paul

Thanks for that.

Sounds like the way forward. Not interested in saving the information though.

What concerns me however is getting the report to print all 6 pages. I just can't seem to get my head round how to format the report for all the pages.

 

[pbaldy]

6 pages of static text will be a problem, as the height limit on a report section is I think 22 inches. Your options include putting the desired text into table fields (memo data type) and basing the report on that table, splitting the text into separate reports and printing them all, etc. An Access report is more suited to printing data out from a table than static text. You could probably also create a Word document and push the text from the form to it (I haven't done it, but I think it involves Word bookmarks. I've pushed a lot to Excel, never Word).

 

[mousemat]

Hmmm, I thought that would be the case. I have dne word merges before, there not the best of things though.