Keep together - Microsoft Access / VBA

John M

Hi
For reporting grades and comments about students, I use one subreport per
subject. This includes a number of text boxes, some containing numerical
data, but one containing a textual report. Depending on how much is
written, sometime there are three on a page, sometimes two etc. What I
cannot seem to do is to get it to 'not start a report for a subject unless
it can fit it on a page'. The keep together option seem to have no effect
in this case. I feel I want to put an elastice band round the various
fields, but there is no 'ealstic band option!!
Thanks in advance

Nov 13 '05 #1

Subscribe Reply

3945

Allen Browne

Put each of your subreports into a different section on the main report.

1. Open the main report in design view.

2. Open the Sorting and Grouping dialog.

3. Select the primary key field (probably StudentID).

4. In the lower pane, set Yes for both Group Header and Group Footer.
Access adds 2 new sections to the report.

5. Move the first subreport into the StudentID Group Header.
Move the last subreport into the StudentID Group Footer.
Leave the middle one in the Detail section.

Make sure the Keep Together is Yes for the 3 sections. Access won't start
the new section unless it will all fit on the page.

If necessary, you can add the StudentID again on the 2nd row of the
Sortin'n'Groupi ng box to get more group header/footers sections for your
subreports.
There is a design issue here that really bothers me though: you should not
run into this issue if you have a Student table, a Subject table, and a
junction table betweeen them. More info:
Relationships between Tables (School Grades example)
at:
http://members.iinet.net.au/~allenbrowne/casu-06.html

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

"John M" <jo**@jmawer.de mon.co.uk> wrote in message
news:cs******** ***********@new s.demon.co.uk.. .

For reporting grades and comments about students, I use one subreport per
subject. This includes a number of text boxes, some containing numerical
data, but one containing a textual report. Depending on how much is
written, sometime there are three on a page, sometimes two etc. What I
cannot seem to do is to get it to 'not start a report for a subject unless
it can fit it on a page'. The keep together option seem to have no effect
in this case. I feel I want to put an elastice band round the various
fields, but there is no 'ealstic band option!!
Thanks in advance

Nov 13 '05 #2

John M

Excellent, thanks

In answer to your design issue point ... I think my way may be ok really!
All the basic data can be cut an pasted from out School information
management system (which does not have a decent reporting package). By
basic I mean personal details, classes, and teachers of those classes. I
create tables for each 'block' (this usually equate to subject). These
contain the reports, grades etc, and link to the basic data via student ID.
The fields are common to all of these so not only do I type no names, but
all the same forms reports code etc can be used. It all comes together
through a report. (Even this I ought to be able to get to reuse the same
one but fill it with different blocks. (I guess I've answered your point as
I'm not that confident that it is a good design!)

PS I gather it's poor form to ask of two Newsgroups, but I only just thought
of using the specific Reports Newsgroup after posting this.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:41******** *************** @per-qv1-newsreader-01.iinet.net.au ...

Put each of your subreports into a different section on the main report.

1. Open the main report in design view.

2. Open the Sorting and Grouping dialog.

3. Select the primary key field (probably StudentID).

4. In the lower pane, set Yes for both Group Header and Group Footer.
Access adds 2 new sections to the report.

5. Move the first subreport into the StudentID Group Header.
Move the last subreport into the StudentID Group Footer.
Leave the middle one in the Detail section.

Make sure the Keep Together is Yes for the 3 sections. Access won't start
the new section unless it will all fit on the page.

If necessary, you can add the StudentID again on the 2nd row of the
Sortin'n'Groupi ng box to get more group header/footers sections for your
subreports.
There is a design issue here that really bothers me though: you should not
run into this issue if you have a Student table, a Subject table, and a
junction table betweeen them. More info:
Relationships between Tables (School Grades example)
at:
http://members.iinet.net.au/~allenbrowne/casu-06.html

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

"John M" <jo**@jmawer.de mon.co.uk> wrote in message
news:cs******** ***********@new s.demon.co.uk.. .

For reporting grades and comments about students, I use one subreport per subject. This includes a number of text boxes, some containing numerical data, but one containing a textual report. Depending on how much is
written, sometime there are three on a page, sometimes two etc. What I
cannot seem to do is to get it to 'not start a report for a subject unless it can fit it on a page'. The keep together option seem to have no effect in this case. I feel I want to put an elastice band round the various
fields, but there is no 'ealstic band option!!
Thanks in advance

Nov 13 '05 #3

Similar topics

1202

Keep together in reports

by: John M | last post by:

Hi, I have devised a system to produce pupil reports for our school using Access. Each subject report consists of a series of numerical / simple text data together with a written report written using amemo field. In the final printed report these appear one subject after another. Sometimes 3 subjects will fit on a page, sometimes 4, depending on how much each teacher has written. The problem is that at the moment I'm getting 3 and a...

Microsoft Access / VBA

8643

Section keep-together within subreport?

by: Steve Jorgensen | last post by:

I tried to fix a problem for a client today in which report sections and even individual text controls in some of their reports are being split across page boundaries. Of course, I was thinking the answer was just going to be setting some Keep Together properties to Yes. Alas, it was not to be. It turns out that the report in question is actually a combination of 2 other reports based on different tables. The reports should follow one...

Microsoft Access / VBA

1594

SubReport - Keep Together

by: Johnny M | last post by:

I have a main report that consists of 15 subreports. When a main detail item is produced only selected subreports are produced depending on a certain control. The subreports generally occupy only 3 columar inches of space and I want to keep the entire subreport on a page. The keep together property on the detail section of each subreport is set to Yes but the subreports still break across a page even if it is the last of three subreports...

Microsoft Access / VBA

2913

Keep track of Session value

by: Alan Wang | last post by:

Hi there, Once my application gets complicated and complicated. I found it's really hard to keep track of Session value I am using in my asp.net application. I am just wondering if anyone have any experience on how to keep track of session value. Any help it's appreciated. Thanks Alan

ASP.NET

2504

keep section head and detail together

by: tbee | last post by:

I have a multicolumn report with one group header section. The header has "new col or row before and after" to make sure the header always starts on a new line. Basically I have two problems: 1. the minor problem: the header section is as wide as the detail. This is survivable, but when a "before and after" is set, the section always has room to span the page. Is there a trick to achieve this? If I would use "page before" then I could use...

Microsoft Access / VBA

1619

Report Detail Section & Keep Together Property

by: Tim Marshall | last post by:

Access 2003. A report of mine was hanging on print preview. It turned out the issue was a bound text box where the data was too big to fit all on one page. When I changed the "keep together" property for the detail section to NO, the report previewed and performed as expected. However, I'm now faced with a minor irritant I'd like to be able to deal with. Some other records with far less content in the text box at issue end up getting...

Microsoft Access / VBA

17890

usage of   to keep input and label together

by: ckirchho | last post by:

Hallo, In a form I have several text or checkbox inputs with their appropriate labels. I'd like to keep label and input together, so I connect them with a  , like: <input type="checkbox" name="h" value="1" id="chk"/> <label for="chk">Schreibweisentolerant</label> Apparently this doesn't work in Firefox 2. It works in IExplorer and Opera. As well I tried:

HTML / CSS

921

Keep-together bug in A97?

by: Les Desser | last post by:

I have a problem in an A97 report. The detail section of the report has Keep-together and CanGrow set to Yes The detail section contains a sub-report which can grow quite large. If the subreport cannot fit on the page then it skips to the top of the next page.

Microsoft Access / VBA

1469

Trying to keep certain units together

by: CoreyReynolds | last post by:

Hello, so I'm not sure how to go about this. My table is below: Each piece of equipment we have has an equipmentID, and can have multiple Compartments (parts in the machine), which are dueIn (due to be inspected) in a certain number of hours of use. So, I want to go through the list, find the lowest "dueIn" reading for a piece of equipment with the Compartment "Engine", list it first, then all of the other compartments belonging to that...

MySQL Database

9680

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10012

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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

General

9052

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7548

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6788

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5575

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4118

transfer the data from one system to another through ip address

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

C# / C Sharp

3731

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2926

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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

General