Charlotte Foust
charlotte.foust at gmail.com
Fri Jan 21 11:01:11 CST 2011
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 >