473,473 Members | 1,535 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

I have a report in Access 2007 that I am trying to force page breaks

1 New Member
I would like to divide my report by our departments and then sites. I've gone into properties for each of my sorts and put in page breaks but nothing happens. Everything just runs together on one long report. I need to send the report to the different sites. I was able to do this in Access 2000 but am not able to get it to work in 2007.
Sep 21 '10 #1
1 1402
jimatqsi
1,271 Recognized Expert Top Contributor
What I have done in prior Access versions is to add a footer for my sort item and put a page break after whatever I am printing in the footer. You can find page breaks on the toolbox toolbar.

I don't see a page break property in prior Access versions.

Jim
Sep 22 '10 #2

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

Similar topics

1
by: Scott | last post by:
Was not sure if this was the place to post this or not, so if not, can someone point me in the right direction. Here is my problem - I have an ASP page the is generating a file with HTML that is...
1
by: David | last post by:
Folks, I have four subreports in a report in the detail section. I suppose I could move them to the footer of the report. Anyway, if any of them have data, I want the main report to force a...
4
by: mikeDA | last post by:
I have an invoice report in Access. I have three invoices. I want to force a page break after each invoice# so I end up with three invoices, each with a header (invoice# date etc.), detail (items...
4
by: lupo666 | last post by:
Hi everybody, this time I have three problems driving me nuts :-((( (1) I have a report with 20 or so Yes/No "squares". Is there a way to either hide/show the "square" or change the yes/no...
2
by: Taftheman | last post by:
Hi, i have a problem forceing page breaks in word via a vb6 application i have the following code but it does not seem to like it , can any body help .Tables(1).Split.AllowPageBreaks = True
5
by: LadyIlsebet | last post by:
I'm not a fantastic Access developer, but I'm trying to help get Inventory and whatnot organized at work. They are used to 5 year budget plans that list out exactly what has to be purchased what...
10
by: Lou O | last post by:
I have been using Access 2007 for a number of months and have successfully deployed ACCDR files on many client machines. The client machines have the "free" Access runtime version installed. I...
2
by: sphinney | last post by:
OK, is Access 2007 driving anyone else nuts? I've got three lines of VBA code that sends a report to the printer: DoCmd.OpenReport RPT_NAME, acViewPreview, , , , ARGS DoCmd.RunCommand...
1
by: pusparaj | last post by:
I had developed an application using MS Access 2003 and in my reports I have no problem whether viewing or printing it in one page from my PC or Notebook. Also no problem when I opened this...
4
by: Tennotrumps | last post by:
I am trying to export a report to excel but the "excel" option is greyed out. I can export the query the report is based on, but not the report. However, if I open the database on another PC I...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
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...
0
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...
0
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...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
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...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
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 ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.