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

February 10th, 2004, 12:03 PM
|
Friend of Wrox
|
|
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|

February 10th, 2004, 12:10 PM
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|

February 10th, 2004, 03:09 PM
|
Friend of Wrox
|
|
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|

February 10th, 2004, 03:16 PM
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|

February 13th, 2004, 11:53 AM
|
Friend of Wrox
|
|
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Thanks Beth you are a star :-)
Gaz
|

February 13th, 2004, 11:56 AM
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Thanks Gaz. But unfortunately I think I'm classified as a 'falling' star instead of 'shooting'! :0
Beth M
|

February 13th, 2004, 03:25 PM
|
Friend of Wrox
|
|
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|

February 13th, 2004, 03:30 PM
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|

February 13th, 2004, 06:38 PM
|
Friend of Wrox
|
|
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Thanks for all your help
Gaz
|

February 13th, 2004, 10:41 PM
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
It's been my pleasure!
|
|
 |