[AccessD] Conditional keep together

Does the customer wants each Group to start on a new page? Or can you have several 
groups per page?

-- 
Stuart

On 20 Jan 2011 at 14:42, Debbie wrote:

> The section starts printing on the first page and continues to page 2.
>  Subsequent groups may get split over 2 pages though and is not what 
> the customer wants.
> 
> Debbie
> 
> Sent from my iPhone
> 
> On Jan 20, 2011, at 2:03 PM, "Rocky Smolin" <rockysmolin at bchacc.com> 
> wrote:
> 
> > What happens if you set the section to Keep Together with First 
> > Record?
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
> > Sent: Thursday, January 20, 2011 11:02 AM To: Access Developers
> > discussion and problem solving Subject: Re: [AccessD] Conditional
> > keep together
> >
> > Section or header both crash. I get this program has encountered an
> > unexpected error and has to close. It backs up. Repairs and compacts
> >  and restarts every time I put it in any type of format event.
> >
> > Debbie
> >
> > Sent from my iPhone
> >
> > On Jan 20, 2011, at 11:47 AM, "Rocky Smolin"
> > <rockysmolin at bchacc.com> wrote:
> >
> >> On format of the report or the header or the footer section? What 
> >> kind of crash?
> >>
> >> R
> >>
> >> -----Original Message-----
> >> From: accessd-bounces at databaseadvisors.com
> >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
> >> Sent: Thursday, January 20, 2011 8:40 AM To: Access Developers
> >> discussion and problem solving Subject: Re: [AccessD] Conditional
> >> keep together
> >>
> >> I started to put a conditional keep together in code on format.
> >> This actually crashes Access. Only in the on open event will it
> >> work.
> >>
> >> I have started experimenting with adding a conditional page break.
> >> I can get it to work only when I want, but the records still start
> >> on page 2. I just get a page break in the middle of page 2 rather
> >> than moving the first part of the records to page 1
> >>
> >> Debbie
> >>
> >> Sent from my iPhone
> >>
> >> On Jan 20, 2011, at 9:21 AM, "Rocky Smolin"
> >> <rockysmolin at bchacc.com> wrote:
> >>
> >>> Is it a function of how many records there are in the group?  I
> >>> wouldn't want to hard code a test for a specific data value if I
> >>> could avoid it.
> >>>
> >>> You can, of course, set the keep together property through code,
> >>> but the question is where to do it?
> >>>
> >>> I've never tried this but I'd experiment with the Format event of 
> >>> the group header.
> >>>
> >>> Rocky
> >>>
> >>>
> >>> -----Original Message-----
> >>> From: accessd-bounces at databaseadvisors.com
> >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie
> >>> Sent: Thursday, January 20, 2011 6:48 AM To: Access Developers
> >>> discussion and problem solving Subject: [AccessD] Conditional keep
> >>> together
> >>>
> >>> I have a report with 2 grouping levels. The first group is keep
> >>> together with first record and the second is keep all records
> >>> together on one page. 99.9% of the time this is perfect.
> >>>
> >>> Now I have the situation where my first keep all records together
> >>> group fits perfectly on a page all by itself. This means I have a
> >>> report header, further group header, then a page break. Not until
> >>> page 2 do I see this first set of detail records because if the
> >>> keep together.
> >>>
> >>> I do not want to set this to keep with first record just to cover
> >>> this one instance with one user, but I have to admit it is pretty
> >>> awful. Is there any way to determine that this has happened ahead
> >>> of time and reset the keep together property?  Better yet only
> >>> reset it on the group having problems.
> >>>
> >>> I can set the keep together, but only on open. By the time I can 
> >>> tell if it is needed, my window of opportunity is lost and I am
> >>> better  off just setting this group to keep together with first
> >>> record and just be dine with it.
> >>>
> >>> Debbie
> >>>
> >>> Sent from my iPhone
> >>> --
> >>> AccessD mailing list
> >>> AccessD at databaseadvisors.com
> >>> http://databaseadvisors.com/mailman/listinfo/accessd
> >>> Website: http://www.databaseadvisors.com
> >>>
> >>> --
> >>> AccessD mailing list
> >>> AccessD at databaseadvisors.com
> >>> http://databaseadvisors.com/mailman/listinfo/accessd
> >>> Website: http://www.databaseadvisors.com
> >>>
> >> --
> >> AccessD mailing list
> >> AccessD at databaseadvisors.com
> >> http://databaseadvisors.com/mailman/listinfo/accessd
> >> Website: http://www.databaseadvisors.com
> >>
> >> --
> >> AccessD mailing list
> >> AccessD at databaseadvisors.com
> >> http://databaseadvisors.com/mailman/listinfo/accessd
> >> Website: http://www.databaseadvisors.com
> >>
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>