473,659 Members | 3,031 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Cannot get my access 2010 report to perform a page break after change of record

2 New Member
I am a newbe Access 2010 'person' and have designed a simple membership record database consisting of a main and subform. I want to print a membership handbook with a page for each member. I Created a report consisting of data from the main and subtables and although I can see all the data i cannot get the report to page break after each member record. I have tried to place the 'force page break' after the section, but I think it is something to do with the report layout and grouping.
Jun 4 '18 #1
4 1127
twinnyfo
3,653 Recognized Expert Moderator Specialist
macctravelman,

Welcome to Bytes!

Where are you putting the "Force Page Break" in your Report? There are several places it may go, which may affect how your report is functioning?

Also, as a general rule, users and experts on this forum will not download someone's Access project (especially a first time user) for obvious security reasons. There may be times when we ask for it, but it is rare.
Jun 5 '18 #2
macctravelman
2 New Member
hi
Thanks for your advise, I had changed the data within the tables to ensure that the names and other data was fictitious. I have zipped the tables, forms and reports so you should be able to determine where the force page break is located
Jun 5 '18 #3
twinnyfo
3,653 Recognized Expert Moderator Specialist
Again, as a general rule we don't download projects. Please respond to the question directly please.
Jun 5 '18 #4
NeoPa
32,568 Recognized Expert Moderator MVP
How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION! should help you to get more from this forum.
Jun 9 '18 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
3418
by: Les Desser | last post by:
I am trying to use a conditional page-break by setting the Visible property of the page-break control - as per the Access Help. However, my page-break controls do not have a Visible property! :( If I try setting it in code I get an error that there is no such property, and the property sheet indeed does not show such a property. What am doing wrong? --
1
2330
by: tngoe | last post by:
I haven't programmed in Access for five years. The budget analyst asked me for help. Her report has page break after each group of organization. However, when posting this report on e-print server(web), the page breaks are messed up. I would like to force a page break after every 55 lines. If there are 10 records per organization, I want to write extra 45 blank lines before the page break. If there is 65 records per organization, I want...
0
1670
by: Tom East | last post by:
I am a special ed teacher. I am using Access to track data. My ultimate goal is to provide parents with a scatter chart with a trend line based on two fields from a trial results database. The fields are Trial_Date and Trial_AVG. Basically one student will have a number of results from work in one goal over a number of days. When I create a report with the two fields sorted by Date, the report correctly lists a date and a bunch of Trial_AVG's...
3
19457
by: minnichj | last post by:
Is there a way to force an Access 2010 report to resize so all columns print out on one page (I'm looking for something similar to the "Fit to:" Page setup feature in Excel)? VB Code preferred.
4
10512
beacon
by: beacon | last post by:
Hi everybody, My title may not exactly describe my issue, so please forgive my lack of creativity today. I've got a database that was created in Access 2003 that I've opened in Access 2010. I intend on keeping the .mdb format for the time being, so I'm not performing a true conversion...just trying to get it to work in the new version. I'm familiar with a number of areas in 2003 that have to be modified to work in 2010, but my issue today...
7
8905
by: Sophia Olivas | last post by:
I am trying very hard to make this work - i found a question posed a few years ago to do the same thing and tried the solution but it doesn't work... I have a standardized form that I am trying to duplicate and populate w/data from my database. the form has 29 lines for data entry - with 10 columns of data. I want all 29 lines to show wether there is a record or not to put in the line. I have one field that is only on the form - it...
1
1834
by: newtoaccessvba | last post by:
I am not too familiar with VBA in Access, but I would like if someone could show me how to ignore a caption and it's field in an Access 2010 Report and an Outlook Email when the field value is it is empty. 'Here is some relevant code (next three lines): Dim DesiredRequiredDate As String DesiredRequiredDate = Me!DesiredRequiredDate "Desired Required Date:" & " " & DesiredRequiredDate 'In the body of email, if the value is null/empty,...
3
1832
by: jyellis | last post by:
My customer wants to see the records updated in the last 30 days to change color on his report. There is no update date field in report. Can this be done?
3
14653
by: rahul2310 | last post by:
I have created joining letter in access 2010,as it is a letter it is not in column and row format. When i export report to word it does not shows report instead it shows column headings and data below it. what will be the code to export entire report in ms word as it is in access on button click. thank you
0
8337
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8748
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8531
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8628
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5650
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4335
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2754
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1978
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1739
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.