Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 25th, 2011, 10:38 AM
Authorized User
 
Join Date: Sep 2010
Posts: 45
Thanks: 12
Thanked 0 Times in 0 Posts
Default page break on Access 2007 doesn't work

Hello Everyone,

I tried to put a page break on my school year footer, but it doesn't work.

What should I do? Do I need to add some code in [Event Procedure]?

Please help!

Thanks,
Cindy
 
Old August 25th, 2011, 12:06 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Are you wanting to split the footer so is prints on two separate pages or do you want the entire footer section on to start on a new page?

There is a property setting for the section to force it to start on a new page. You do not need to insert a page break control unless you want to split the section between pages.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
 
Old August 25th, 2011, 01:43 PM
Authorized User
 
Join Date: Sep 2010
Posts: 45
Thanks: 12
Thanked 0 Times in 0 Posts
Default start a new page

Thanks, HiTechCoach.

I want to start a new page. For example, grouping by school year. In each school year, there are student enrolled data, teacher info....

Thanks,
Cindy
 
Old August 25th, 2011, 02:49 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

If you want each new grouping on a separate back you have two choices.

1) Use a group header and set to force a new page before section

2) use a group footer and set to force a new page after section.


I generally use (#1) force a new page before each group.

See: Print each group of your Access report on a separate page


Boyd Trimmell aka HiTechCocah
Microsoft MVP - Access Expert
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
 
Old August 30th, 2011, 10:06 AM
Authorized User
 
Join Date: Sep 2010
Posts: 45
Thanks: 12
Thanked 0 Times in 0 Posts
Default not work on 2007

Thanks. I tried it, but it doesn't work on Access 2007.

Cindy
 
Old August 30th, 2011, 10:59 AM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Cindy,

What exactly did you try?

I have many report where each group starts on a new page. I do not have any issues. When Printing or Previewing.

Ah ... just thought of something. Are you using Report View to view the report on the screen? Is yes, try Print Preview.


I generally disable the Report View. Not sure what is is good for except to cause mass confusion for users.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
The Following User Says Thank You to HiTechCoach For This Useful Post:
IMGR8EST (March 14th, 2014)
 
Old August 30th, 2011, 12:46 PM
Authorized User
 
Join Date: Sep 2010
Posts: 45
Thanks: 12
Thanked 0 Times in 0 Posts
Default thanks

Thanks, HiTechCoach.

Sorry, I just used "Open Report" since I use drop down list on the FORM to select a value, then open the report. now, I am using "Preview Report" instead of "Open Report", it works.

Thank you so much,
Cindy
 
Old August 30th, 2011, 02:49 PM
Authorized User
 
Join Date: Sep 2010
Posts: 45
Thanks: 12
Thanked 0 Times in 0 Posts
Thumbs up thanks

Thanks, HiTechCoach.

Sorry, I just used "Open Report" since I use drop down list on the FORM to select a value, then open the report. now, I am using "Preview Report" instead of "Open Report", it works.

Thank you so much,
Cindy
 
Old August 30th, 2011, 06:10 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Cindy,

You're welcome.

Glad it is now working for you.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
 
Old March 14th, 2014, 11:14 PM
Registered User
 
Join Date: Mar 2014
Posts: 1
Thanks: 1
Thanked 0 Times in 0 Posts
Thumbs up Bingo!

I had the same problem and after searching for solutions, I finally found it here!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Grand Total Code does not work in Access2003 Data Access Page ferretti40 Excel VBA 0 April 20th, 2010 09:15 PM
How to specify relative path to Access 2007 in ADO connection string? [Excel 2007] sektor Excel VBA 4 September 3rd, 2009 11:59 PM
Page break grstad Classic ASP Basics 5 December 31st, 2006 01:27 PM
Page Break Neal Crystal Reports 1 August 31st, 2006 10:33 AM
Page Break Dhawood ASP.NET 2.0 Basics 0 August 8th, 2006 08:02 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.