Boyd Trimmell
accesscoach at hitechcoach.com
Thu Jan 20 14:52:03 CST 2011
Debbie, With the keep together property set to no, have you tried setting the it to start on a new page for each group? Boyd Trimmell aka HiTechCoach at UtterAccess.com and other support sites Microsoft Access MVP 2010 ( MVP Profile ) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie Sent: Thursday, January 20, 2011 2:43 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Conditional keep together 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