473,511 Members | 14,975 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Report: incremental field and page break

I have to create a report, that contains in the section body a list of
record.
For every record it has to appear an incremental additional field that
begins from One; when he reaches the record 50, it is had to activate a page
break and the following record leaves again with numeration equal to one.

How can I do?
Dec 5 '06 #1
1 2312
Assuming you are not using Can Grow or Can Shrink, it's not too difficult to
design a page that prints 50 records per page.

Get your page height.
Subtract the Top and Bottom margins (File | Page Setup.)
Subtract the height of any Page Header and Page Footer.
Divide the result by 50
Set this as the Height of the Detail section.

To display the count, add a text box to the Detail section, with these
properties:
Control Source =1
Running Sum Over All
Format General Number
Visible No
Name txtCount
Now add another text box to show the count, and set its Control Souce to:
=(([txtCount] -1) Mod 50) + 1

If you have other complications (such as a Report Header or Group Headers),
you can add a Page Break control (from the toolbox) and programmatically set
its Visible property in the Format event of the Detail section, based on the
number of records so far on the page. You can use the counter described
above, or use a module-level variable that you increment in the Print event
of the Detail section, and reset in the Format event of the Page Header.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Daniele" <da*****@tiscalinet.itwrote in message
news:45*********************@news.tiscali.it...
>I have to create a report, that contains in the section body a list of
record.
For every record it has to appear an incremental additional field that
begins from One; when he reaches the record 50, it is had to activate a
page break and the following record leaves again with numeration equal to
one.

How can I do?

Dec 6 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
5186
by: Andy V | last post by:
Hi. I've got a multi page report of my monthly purchases. I'd like a running total (month to date) at the end of each page and to have that total at the top of the following page. So far all I can...
1
12397
by: Shiz | last post by:
I currently have a Form with Option buttons (to give you the option of sorting by name, or by Field, etc), these are referenced in a module which then formats the report contingent on the option...
6
4683
by: noway | last post by:
I have greated a report and have included a page break in it. The report breaks were it is supposed to but then it creates a blank page between the two pages. Since this report will print out...
1
6841
by: pemigh | last post by:
I have a report with pages breaking in the middle of text box controls. And it's not just on a line-by-line basis, but sometimes (in a situation that I can no longer recreate) just the bottom...
4
21535
by: Rico | last post by:
Hello, I'm looking for a way to force a pagebreak in code. I'm having a tough time, the first page formats properly until the condition is met and then forces a new page. The problem is, every...
1
1516
by: Julian | last post by:
One of the fields I have is a Client Number which is entered manually in a Table. This Column is sorted ascending in a Report I have, but insted of sorting them incremental ascending the Report...
2
3939
by: Lennart | last post by:
We have recently moved a ClearQuest database to db2 V8 on linux. We take a full compressed backup on sundays (~400Mb) and compressed incremental/incremental delta other weekdays. What puzzles me is...
4
4215
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...
0
7153
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
7371
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7432
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
7517
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...
0
5676
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5077
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
4743
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
3230
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1583
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 ...

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.