[AccessD] Conditional keep together

Debbie delam at zyterra.com
Thu Jan 20 14:42:37 CST 2011


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
>



More information about the AccessD mailing list