Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Form /Report Page Header on First Page Only
- Thread starter number2
- Start date
Yes...Report Header will only be printed once on the first page. However Page Header will be printed at the top of every page. Hope this clears up some confusion you may have on difference in Report Header/Footer and Page Header/Footer you may have.
- Thread starter
- #3
Thanks for the help. Maybe you can help me come up with a solution to what seems like an esay question:
I need to produce a form which will serve as a narrative medical legal report writing tool. (I am building this under Access Runtime and avoiding the terrible confusion and problems with letter merging. By using the form I can merge much of the required database feilds into the form/report.)
Here's the question: should I create a form from where the writer writes the report by filling memo feilds and the produce the report from that report? OR should I make the form layout printable as the final document?
I am having problems with laying out the report using either method. In particular:
Page control - I can not get the feilds to fill in to new pages on print out.
Which idea is best: Using a form to write the report then build a report to print, or use a printable form?
I need to produce a form which will serve as a narrative medical legal report writing tool. (I am building this under Access Runtime and avoiding the terrible confusion and problems with letter merging. By using the form I can merge much of the required database feilds into the form/report.)
Here's the question: should I create a form from where the writer writes the report by filling memo feilds and the produce the report from that report? OR should I make the form layout printable as the final document?
I am having problems with laying out the report using either method. In particular:
Page control - I can not get the feilds to fill in to new pages on print out.
Which idea is best: Using a form to write the report then build a report to print, or use a printable form?
Personally I'd make a form that allowed the user to change all the items on the report that they are allowed to alter or set. Then using the different states that the user has choosen on that screen, populate a report.
I'd basically have a table to hold all the information that can be set specifically by the user. Create a form that allows them to add/edit this information. Once all the information that is required is entered, then Enable the button used to call up the report.
The actual report you can build all of it that stays the same and place Unbound controls where you want to control the information coming into the form dynamically. Then in the code for the report write your functions that will return the correct information out of the tables. Then in the data field of the Unbound controls simply put '=<Their function name here>' to call the correct information.
I'm not completely sure everything your trying to do, but I would think it would be very hard to make it all work in a single report, without any forms.
I'd basically have a table to hold all the information that can be set specifically by the user. Create a form that allows them to add/edit this information. Once all the information that is required is entered, then Enable the button used to call up the report.
The actual report you can build all of it that stays the same and place Unbound controls where you want to control the information coming into the form dynamically. Then in the code for the report write your functions that will return the correct information out of the tables. Then in the data field of the Unbound controls simply put '=<Their function name here>' to call the correct information.
I'm not completely sure everything your trying to do, but I would think it would be very hard to make it all work in a single report, without any forms.
- Status
Similar threads
