473,387 Members | 1,721 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

display several records per report - Access 2010

15
I have a table with 10 records in it, and I have created a report and added existing fields.
The report shows one record on each page (There are therefore 10 pages)
I need all 10 records on one page.
Jan 25 '13 #1
5 4434
Seth Schrock
2,965 Expert 2GB
The first thing that comes to my mind is that you possibly have one or more of your report sections (first guess would be the details section) heights to tall. Without more information about what you are doing, all we can do is guess.
Jan 25 '13 #2
M0ji
15
no they are not too tall.
I know what you are saying, I can make pages very small, but that will show all the records in a sequence. I would like to place the records anywhere on the page. (10 records placed on one page)
let me know if I am not explaining this whole thing correctly.
Jan 25 '13 #3
Anas Mosaad
185 128KB
What Seth has been trying to tell you is that you have multiple sections in your report. Make sure you are putting the records in the right section (i.e. details section not the header).
Jan 25 '13 #4
Seth Schrock
2,965 Expert 2GB
If your sections (not the controls) aren't too tall, then do you have any page breaks in your details section? Is there any code in the report's OnLoad event that could affect the layout of the report?
Jan 26 '13 #5
NeoPa
32,556 Expert Mod 16PB
Moji:
let me know if I am not explaining this whole thing correctly.
You are absolutely not explaining this at all clearly.

There are many points that might cause this behaviour, but as you give no real information about what you actually do have in the design of the report we could spend a long time guessing one after the other.

Alternativlely, you could actually consider what you have in your report and tell us, so we have something to work with.

If the sections of the report are not what you would think of as too big for one of your pages then you might check all the sections for the following properties :
  1. Force New Page
  2. New Row Or Col
  3. Keep Together
This may help you find it anyway, but if not you really need to consider sharing the information of what you're working with if you expect help.
Jan 26 '13 #6

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

Similar topics

2
by: rakesh | last post by:
Hi I have a form which displays the rows from the table. The table does not have a unique index.It has the following columns: studentname todate fromdate location Now a particular...
9
by: Greg | last post by:
Hi, I have a table with "dates", i'd like to display those dates on a calendar. I've put a calendar in a form, linked to my "date" field, and it works, but only showing one "date" per calendar....
4
dnb
by: dnb | last post by:
Hi.... How to set perticular number of records to display on one page of datareport in vb6.0? I want to display 10 records on one page of datareport.
2
by: puneetmca | last post by:
hi i m new in php.... i want to generate a report of my database records having field names FirstName ,LastName and Age in student table and test database.....and i want to display these records in...
5
by: jaad | last post by:
Hello, I have a database that was written in access 2007 on my pc. I wanted to work off site with the database so I uploaded it onto my laptop which is loaded with access 2010 beta. When I...
2
by: sierra7 | last post by:
It seems Access 2010 is associating an 'input mask' or field type with a combo box when a form is opened, even though there is no Format setting on the control. I have a form which has been...
2
by: dougancil | last post by:
I have a user who had deleted some records from a database today using Access 2010. They have an ID field that's autonumbered. They have No Duplicates allowed. When they created a new record today,...
1
by: Alan Yim | last post by:
Hi folks, My company recently upgraded our Office suite from 2003 to 2010. The problem in particular is with an Access database that was originally designed in Access 2003. The code in question...
5
by: colsoft | last post by:
I am using Access 2010. Am generating reports for the records, one record per page. The records on the even pages have a light black background shading which appears when am printing. Please i need...
2
by: Bill Boord | last post by:
I need to be able to shut off the AutoCorrect "feature" within Access 2010 code. I have utilized Application.SetOption with method strings for other startup requirements, but I cannot seem to find a...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.