[AccessD] Conditional keep together

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