By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Muti page report question

P: n/a
Evening,

I have a form that uses 5 pages (it's an electronic copy of the paper
version) we are going to use for manufacturing non conformances and
product deviations. In case your wondering, it's 5 pages to get the
risk assessment done before it gets to my area in QA and the db is a way
to electronically archive the information for regulatory compliance
reporting. Anyway, I've been merrily going along making a report the
same as the form, but found out for the first time today that Access has
limitations on the page length etc.

That's cool, nothings perfect. After trolling through this group at
work, I've found archived stuff that relates to the ability of Access to
print multiple reports, specifically the ability to print one report
after another based on the same/similar information on a form. It
sounds like what I need with two questions. Firstly, how do I pop some
code in the first report that ensures the second report prints
sequentially? I'm not worried about page numbering as I found some code
today for that. Secondly, how do I make the second report print the
remaining information from the form? The db has a primary key of the
unique NCF number.

I've got absolutely no worries about the first report printing the first
3 pages of the form and it's working well, but linking the last two
pages using the same unique key that printed the first report record is
eluding me. I've done a heap of reports only one or two pages, so this
is really new and exciting territory for me and I'd rather not have to
go the mail merge option with Word. I'm more than happy to give my work
address to anyone who may wish to take this further. In case your
wondering, I cannot post at work due to firewall restrictions, but can
merrily read all day long.

Thanx in anticipation,

Peter ;-)
Aug 24 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Answer to first question: You don't need code in the first report, you need
only to code printing the first report and then the second report. You can
do this very simply in a macro with two sequential OpenReport actions.

As to the second question, a report will print what you tell it to print.
You didn't state if you were trying to print parts of the same field over
multiple reports. If you are, then that is a different story, otherwise, you
place the text and fields from queries and/or tables in the report(s) where
you want it. If you need to print a field over multiple pages, say pages 3
and four, then you print only the first 2 pages in your first report and the
last 3 in the second or if the one filed covers pages 2 through 4 then you
print page 1 on a report, pages 2 through 4 on a second report and page 5 on
a third report, etc.
Stinky Pete wrote:
>Evening,

I have a form that uses 5 pages (it's an electronic copy of the paper
version) we are going to use for manufacturing non conformances and
product deviations. In case your wondering, it's 5 pages to get the
risk assessment done before it gets to my area in QA and the db is a way
to electronically archive the information for regulatory compliance
reporting. Anyway, I've been merrily going along making a report the
same as the form, but found out for the first time today that Access has
limitations on the page length etc.

That's cool, nothings perfect. After trolling through this group at
work, I've found archived stuff that relates to the ability of Access to
print multiple reports, specifically the ability to print one report
after another based on the same/similar information on a form. It
sounds like what I need with two questions. Firstly, how do I pop some
code in the first report that ensures the second report prints
sequentially? I'm not worried about page numbering as I found some code
today for that. Secondly, how do I make the second report print the
remaining information from the form? The db has a primary key of the
unique NCF number.

I've got absolutely no worries about the first report printing the first
3 pages of the form and it's working well, but linking the last two
pages using the same unique key that printed the first report record is
eluding me. I've done a heap of reports only one or two pages, so this
is really new and exciting territory for me and I'd rather not have to
go the mail merge option with Word. I'm more than happy to give my work
address to anyone who may wish to take this further. In case your
wondering, I cannot post at work due to firewall restrictions, but can
merrily read all day long.

Thanx in anticipation,

Peter ;-)
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1

Aug 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.