[AccessD] Conditional keep together

Jim Lawrence accessd at shaw.ca
Thu Jan 20 14:20:27 CST 2011


Hi Debbie:

That should never ever happen. 

There is something more that is causing the problem. In your situation, I
would probably check for any updates on the offending machine and/or do a
re-install of Access. I have had problems mixing Office 11 and 12
components...

Jim

  

-----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




More information about the AccessD mailing list