[AccessD] Conditional keep together

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