Debbie
delam at zyterra.com
Fri Jan 21 11:56:33 CST 2011
Yep trying that now. Still some issues but getting close. Debbie Sent from my iPhone On Jan 21, 2011, at 11:01 AM, Charlotte Foust <charlotte.foust at gmail.com> wrote: > Don't try the keeptogether dynamically, use pagebreak dynamically. > > Charlotte Foust > > On Fri, Jan 21, 2011 at 4:43 AM, Debbie <delam at zyterra.com> wrote: >> The code that works is >> >> Sub report_open >> Me.grouplevel(3).keeptogether = 1 >> end sub >> >> I striped out my conditions to make sure that this worked first. It >> works >> fine on report open, but crashes anywhere else. >> >> Debbie >> >> Sent from my iPhone >> >> On Jan 20, 2011, at 2:38 PM, "Boyd Trimmell" <accesscoach at hitechcoach.com >> > >> wrote: >> >>> Are you try8bng to change the Keep together property with VBA code? >>> >>> What VBA code are you using? Please include the sub to end sub >>> lines. >>> >>> >>> >>> 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 1:02 PM >>> 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 >