Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 10th, 2004, 12:03 PM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default MS Acess 2000 Report Paging Problem

I am having to develop a database application for a local charity using MS Access 2000, having not used this application in a while my skills are a little rusty. Having now almost completed the database I am now in the process of getting rid of the odd bug I have encountered.

One of the problems is with one of my reports. I have created a report that allows the user to view all the records held on the database. On running the report although it's outputting the correct data it keeps producing odd blank pages and am a little puzzled why.

I was wondering whether anyone else had experienced similar problems and had any suggestions?

Gaz
__________________
Gaz
 
Old February 10th, 2004, 12:10 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Your detail section and margins probably total more than your page width, or you may have a control that is extending past the page width settings in your Page Setup dialog box.

One way to check and see if it is an oversized control, set the properties for the controls to Border = Solid and then run the report and see if anything is pouring over to the second page.

Regards,

Beth M
 
Old February 10th, 2004, 03:09 PM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks so much. It was like you said one of my graphics on the report was spanning out of range.

Now that I have sorted that out my only other problem relates to the how the data is presented on the report. Is there a way to force a page break when a group of related information will not fit on the page as a group? and how can I force the report header to be output on the page when this happens?

Gaz
 
Old February 10th, 2004, 03:16 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Gaz,

As you stated, you wish to use a page break and keep together a 'group'. So, in design view go to View > Sorting and Grouping and set a field to 'group'. in the bottom section of the dialog box, for Group Header and Group Footer say Yes. You also have the options to 'Group On' and 'Keep Together' Click Ok.

Back in the report design, click on the footer section and then open the properties box and tell it to Force New Page = After Section.

You can play with the settings and see what the different resluts are for each one.

Regarding the report header, place your header info in the Group Header, this way it will appear with each new group.

Regards,

Beth M
 
Old February 13th, 2004, 11:53 AM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Beth you are a star :-)

Gaz
 
Old February 13th, 2004, 11:56 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Gaz. But unfortunately I think I'm classified as a 'falling' star instead of 'shooting'! :0

Beth M
 
Old February 13th, 2004, 03:25 PM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default


I am hoping you might be able to help me one final time. I feel quite silly really as it's the simple things in Access I have forgotten and can't seem to find answers for in the help files. Basically I have now completed the database, however I cannot recall how to set focus for bound text box when an event such as the ADD button is pressed. I have checked my tab order and all is correct yet after the Add button is pressed the cursor is not placed at the first entry point. Any ideas?

PS Beth you are a STAR is my books :-)

Gaz
 
Old February 13th, 2004, 03:30 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You probably should have started another topic for this one, but after your command to do whatever, you would use:

me.[controlname].setfocus

Regards,

Beth M
 
Old February 13th, 2004, 06:38 PM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for all your help

Gaz
 
Old February 13th, 2004, 10:41 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It's been my pleasure!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with PAGING for Report Viewer Somesh Reporting Services 0 April 30th, 2008 06:01 AM
Problem with Paging in Report Viewer Probleminfinity ASP.NET 3.5 Professionals 0 November 12th, 2007 12:11 PM
Change check box field to false in MS Acess VB saban ASP.NET 1.0 and 1.1 Basics 0 March 13th, 2007 05:19 AM
Acess 2000 to Sql Server mikersantiago Classic ASP Databases 4 November 16th, 2004 10:26 AM
Inserting data into MS Acess "Urgent Help needed" todeepu Access 2 May 10th, 2004 09:24 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.