<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Andy:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>She's a-still no work. I tried After Section
because these are the footers. But, of course, I've got three footers so that
doesn't work out too well. Before section would be better for the header
sections, no?, but then it leaves the report header on a separate
page. :(</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Not sure how to get around this one.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Yet.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=andy@minstersystems.co.uk
href="mailto:andy@minstersystems.co.uk">Andy Lacey</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, May 15, 2003 11:57
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Extra page with
page break in section footer</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=870455518-15052003><FONT face=Arial color=#0000ff
size=2>Rocky</FONT></SPAN></DIV>
<DIV><SPAN class=870455518-15052003><FONT face=Arial color=#0000ff size=2>I'd
set it to 1 (ie Before Section) if I were you. That's what I always use and
never have any bother. I take it you've removed the manual page breaks cos
they'd be messing you up otherwise.</FONT></SPAN></DIV>
<DIV><SPAN class=870455518-15052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=870455518-15052003><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk">http://www.minstersystems.co.uk</A><BR><BR></FONT></P></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> <A
href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</A>
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Rocky
Smolin - Beach Access Software<BR><B>Sent:</B> 15 May 2003
19:47<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] Extra page with page break in section footer<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Andy:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>There's a 'page break' check box on the calling
form. So I set the page breaks (up to three because there can be three
sort fields selected) visible or not depending on the check box.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I tried setting them in code:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT face=Arial size=2>
<DIV><FONT color=#0000ff></FONT><BR>If
Forms!frmRoomInventoryReport!chkPageBreak = False Then<BR>
'PageBreak1.Visible = False<BR> 'PageBreak2.Visible =
False<BR> 'PageBreak3.Visible =
False<BR> Me.Section(6).ForceNewPage =
0<BR> Me.Section(8).ForceNewPage = 0<BR>
Me.Section(10).ForceNewPage = 0<BR>Else<BR>
Me.Section(6).ForceNewPage = 2<BR>
Me.Section(8).ForceNewPage = 2<BR>
Me.Section(10).ForceNewPage = 2<BR>End If<BR></DIV>
<DIV>but it's not coming out right. The sections are breaking in funny
places. I tried commenting out 6,8, and 10 in various combinations but
nothing seems to work just right. </DIV>
<DIV> </DIV>
<DIV>Do you see anything I'm doing wrong here or is there perhaps another
way to suppress that last blank page?</DIV>
<DIV> </DIV>
<DIV>MTIA</DIV>
<DIV> </DIV>
<DIV>is</DIV>
<DIV> </DIV>
<DIV>but it leaves the page header by itself.</DIV></FONT>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=andy@minstersystems.co.uk
href="mailto:andy@minstersystems.co.uk">Andy Lacey</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, May 15, 2003 10:54
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Extra page
with page break in section footer</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=020335317-15052003><FONT face=Arial color=#0000ff
size=2>Rocky</FONT></SPAN></DIV>
<DIV><SPAN class=020335317-15052003><FONT face=Arial color=#0000ff
size=2>Rather than do that just set the Force New Page property of the
Group Header to Before Section.</FONT></SPAN></DIV>
<DIV><SPAN class=020335317-15052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=020335317-15052003><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk">http://www.minstersystems.co.uk</A><BR><BR></FONT></P></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> <A
href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</A>
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Rocky
Smolin - Beach Access Software<BR><B>Sent:</B> 15 May 2003
18:44<BR><B>To:</B> <A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><B>Subject:</B>
[AccessD] Extra page with page break in section
footer<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Dear List:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have a couple of reports which the client
wants to page break on the major sort field. SO I put a page break
control in the section the section footer which works just fine
except I'm getting an extra blank page at the end of the
report.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Is there a way to suppress this last
page?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MTIA</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access
Software</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>