473,387 Members | 1,535 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.

Can Access 2000 set something like page break in Report?

48
I am using Access 2000 to create report. I need to print training history for every worker in my department.

Currently my report group the training record by worker's name but it continues with the next worker and his/her record on the same page.

I do not want to print each worker's training history by selecting the specific name using query in report one by one. This is because I need to print the training history for all the workers in my department for the first time and file them seperately in their personal file.

Is there anything like page break after each worker's last record? So that no matter how long or how short is the training history, it starts with new page for next worker.
Apr 10 '08 #1
4 2373
Stewart Ross
2,545 Expert Mod 2GB
Hi. Open your report in design view, right-click on the detail section (which prints the details of the training record for each staff member) and select Properties. Change the Force New Page property to After Section. This will force a page break after each record is printed.

A screenshot of the property is attached.

-Stewart
Attached Images
File Type: jpg ScreenHunter_6.jpg (6.2 KB, 250 views)
Apr 10 '08 #2
HowHow
48
Hi,

I cannot find the "Force New Page" in property. Is this function available for Access 2000?

Not sure how to attach the printscreen here but what I saw in Report/Design view/ Worker Name Field (right click)/ Property/All tab are:
Name......................
Countrol Source.......
Format....................
Decimal Places.......

Did I missed any step? Please show me how to get to Force New Page again if you don't mind. Thanks
Apr 11 '08 #3
Stewart Ross
2,545 Expert Mod 2GB
Hi. You need the properties for the detail section itself, not for one of the controls within it. Right-click on the detail section separator bar or a blank area within the detail section of your report, then click on properties. See attached screenshot.

Also note that the properties tab will show that it is the detail section you are viewing if you have selected the correct item - see second screenshot.

-Stewart
Attached Images
 
Attached Images
File Type: jpg ScreenHunter_8.jpg (10.2 KB, 230 views)
Apr 11 '08 #4
HowHow
48
Yes!! Thanks a lot Stewart! It works! :)
Apr 11 '08 #5

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

Similar topics

5
by: Bob | last post by:
Hi, I am using Access 2000 to print out an address book. I have designed the report based on a database whose first record is not blank. In the design there is a one line report header, a onle...
2
by: Sharon | last post by:
I've had an Access 2000 app running successfully for many months on both Windows XP and Windows 2000. Recently when my Windows 2000 users call a particular report, they get first a dialog...
3
by: MT 2MB | last post by:
I created an access journal entry program many years ago. It works for all and was working for an individual until recently. The report shows ?Name! for every instance it repeats in the report. ...
11
by: James P. | last post by:
Hello, I have a report with the Priority field is used as sort order and grouping. The problem is the data in this Priority field if sorted in ascending order is: High, Low, and Medium. How...
2
by: Rick Caborn | last post by:
I am having a problem with an Access 2000 report getting data from SQL Server 2000. Here are the specifications for it: RecordSource: a stored procedure (tested via query analyzer and working...
7
by: manning_news | last post by:
I've got a report that's not sorting correctly. I build a SQL statement and assign it to the recordsource in the Open event, sorting the data the way the user chooses. The user can choose up to 3...
8
by: jbonifacejr | last post by:
This is my first day here, so please be patient. I do not know how to search very well so the search I tried to get the answer showed me topics from the year 2000 and they really don't cover what I...
8
by: babyangel43 | last post by:
Hello, I have a query set up in Access. I run it monthly, changing "date of test". I would like this query to be merged with a Word document so that the cover letter is created in Word, the fields...
7
by: bhavin30 | last post by:
Is there a way to obtain user information (using LOGON_USER server variables) when you have set up the security to Anonymous Access? I have tried setting the security to both Anonymous + Window...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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...

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.