Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 10th, 2004, 12:03 PM
Friend of Wrox
 
Join Date: Aug 2003
Location: Warks, Warks, United Kingdom.
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
Reply With Quote
  #2 (permalink)  
Old February 10th, 2004, 12:10 PM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
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
Reply With Quote
  #3 (permalink)  
Old February 10th, 2004, 03:09 PM
Friend of Wrox
 
Join Date: Aug 2003
Location: Warks, Warks, United Kingdom.
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
Reply With Quote
  #4 (permalink)  
Old February 10th, 2004, 03:16 PM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
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
Reply With Quote
  #5 (permalink)  
Old February 13th, 2004, 11:53 AM
Friend of Wrox
 
Join Date: Aug 2003
Location: Warks, Warks, United Kingdom.
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Beth you are a star :-)

Gaz
Reply With Quote
  #6 (permalink)  
Old February 13th, 2004, 11:56 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
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
Reply With Quote
  #7 (permalink)  
Old February 13th, 2004, 03:25 PM
Friend of Wrox
 
Join Date: Aug 2003
Location: Warks, Warks, United Kingdom.
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
Reply With Quote
  #8 (permalink)  
Old February 13th, 2004, 03:30 PM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
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
Reply With Quote
  #9 (permalink)  
Old February 13th, 2004, 06:38 PM
Friend of Wrox
 
Join Date: Aug 2003
Location: Warks, Warks, United Kingdom.
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for all your help

Gaz
Reply With Quote
  #10 (permalink)  
Old February 13th, 2004, 10:41 PM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It's been my pleasure!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 06:51 PM.


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