Debbie
delam at zyterra.com
Thu Jan 20 15:31:38 CST 2011
Correct Debbie Sent from my iPhone On Jan 20, 2011, at 3:16 PM, "Boyd Trimmell" <accesscoach at hitechcoach.com > wrote: > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com