Debbie
delam at zyterra.com
Fri Jan 21 06:31:37 CST 2011
Several groups can be on one page, they should not break across pages unless they are too long to fit on one page. Debbie Sent from my iPhone On Jan 20, 2011, at 3:37 PM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote: > Does the customer wants each Group to start on a new page? Or can > you have several > groups per page? > > -- > Stuart > > On 20 Jan 2011 at 14:42, Debbie wrote: > >> 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 >