Boyd Trimmell
accesscoach at hitechcoach.com
Thu Jan 20 15:16:31 CST 2011
Debbie, Ah... so it is OK to have more than one group on a page. You just don't want a group to span multiple pages if possible. Is that correct? 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:59 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Conditional keep together Hmm. The customer might go for that as an alternate to keeping the sections together. I think I may even have some code that will give me similar results, not just start every section on a new page. Thanks for taking me on a new track here. This has possibilities. Debbie Sent from my iPhone On Jan 20, 2011, at 2:52 PM, "Boyd Trimmell" <accesscoach at hitechcoach.com > wrote: > 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 > > -- > 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