[AccessD] Force a new page in code

Jim Lawrence accessd at shaw.ca
Tue Aug 28 13:54:16 CDT 2007


Hi Rocky:

I am not usually this slow but a senior moment.... extending into hours has
over come me. Maybe a sample would help???

TIA
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Tuesday, August 28, 2007 10:37 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Force a new page in code

It sounds like you need to add a grouping level, if it's not already there,
and then add the header and the footer.  In the footer you drag the page
break control from the report design toolbar  and drop it into the footer.
So it will page break on that group level.  In the format event of the
header for that group, ask if this is the group that you want to break on.
If so, make the page break control visible, if not make it invisible.

Clear as mud?

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Tuesday, August 28, 2007 9:07 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Force a new page in code

Hi Rocky:

How is that control setup? Is it a group, a command or a piece of code? A
client has a fairly straight forward report but at times wishes to have a
certain group start at the top of a new page. I can think of certain long
clumsy methods to do this but there must be some eloquent method like:

Me.page.newpage  < this is just pseudo code

TIA
Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Tuesday, August 28, 2007 5:02 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Force a new page in code

Jim:

There's a page break control which I have made visible and invisible
programmatically during report generation, depending on whether I want it
active.   

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Monday, August 27, 2007 11:19 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Force a new page in code

Hi all:

Is there a way to force a new page in Access reports under program control? 

TIA
Jim 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.484 / Virus Database: 269.12.10/976 - Release Date: 8/27/2007
6:20 PM
 

--
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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.484 / Virus Database: 269.12.10/976 - Release Date: 8/27/2007
6:20 PM
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list