PC Review


Reply
Thread Tools Rate Thread

Detect when detail section pushes to 2nd page

 
 
wallymeister
Guest
Posts: n/a
 
      19th Apr 2010
Is there a way of detecting when detail section pushes to 2nd page via code.

Sometimes my report group needs 2 pages and sometimes it don't, but I need a
diiferent set of conditions when it does.

Thanks, for any help!
Wally
 
Reply With Quote
 
 
 
 
Steve
Guest
Posts: n/a
 
      19th Apr 2010
A possibility is to count the number of records in the detail section. If
the count exceeds some number depending on the design of your report, your
report will go o a second page.

Steve
(E-Mail Removed)


"wallymeister" <(E-Mail Removed)> wrote in message
news:6BC9EB70-6BC3-44B8-9C65-(E-Mail Removed)...
> Is there a way of detecting when detail section pushes to 2nd page via
> code.
>
> Sometimes my report group needs 2 pages and sometimes it don't, but I need
> a
> diiferent set of conditions when it does.
>
> Thanks, for any help!
> Wally



 
Reply With Quote
 
wallymeister
Guest
Posts: n/a
 
      19th Apr 2010
Hi steve,
My Detail section has, for example 138 total lines to print for report, this
is over 3 page breaks on model#. (46 per break) Only 42 lines will fit on a
page so each model will push 4 lines to a 2nd page. I've tried everything I
can think of to get the 138 lines to count 46 at a time and then start at 1
again for each model# change. Nothing works.

I could place code to keep track of the lines and pages but if there's a
better way to just detect when I'm on 2nd page of a model#. The lines per
model# will vary from time so nothing is constant. The only Constant is the
number of lines my detail section will print before pushing to 2nd page.

Hope this explains a little better what I need.
Wally

"Steve" wrote:

> A possibility is to count the number of records in the detail section. If
> the count exceeds some number depending on the design of your report, your
> report will go o a second page.
>
> Steve
> (E-Mail Removed)
>
>
> "wallymeister" <(E-Mail Removed)> wrote in message
> news:6BC9EB70-6BC3-44B8-9C65-(E-Mail Removed)...
> > Is there a way of detecting when detail section pushes to 2nd page via
> > code.
> >
> > Sometimes my report group needs 2 pages and sometimes it don't, but I need
> > a
> > diiferent set of conditions when it does.
> >
> > Thanks, for any help!
> > Wally

>
>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Odd/even page different detail section CJay Microsoft Access Reports 4 29th Jan 2008 12:36 PM
I need to SUM the detail section in the Page footer.... please help! Kelvin Beaton Microsoft Access 2 18th Dec 2006 08:47 PM
Section Detail on new page Mark Microsoft Access Reports 3 30th Apr 2004 08:47 PM
3 page detail section - is it possible? Jeff Microsoft Access 1 14th Feb 2004 03:10 AM
Can you tell if a detail section flows over to the next page? Robert LeBlanc Microsoft Access Reports 4 22nd Dec 2003 06:08 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:41 AM.