Wrox Programmer Forums
|
BOOK: Microsoft Access 2010 24-Hour Trainer
This is the forum to discuss the Wrox book Microsoft Access 2010 24-Hour Trainer by Geoffrey L. Griffith, Truitt L. Bradly; ISBN: 978-0-470-59167-3
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Microsoft Access 2010 24-Hour Trainer 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 2nd, 2012, 03:02 PM
Registered User
 
Join Date: Feb 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Lesson 35

I have followed the book and video instruction for this lesson. All seems well except...when my reports appear in the subform only one report in the database shows all records. The other three only show one record at a time with navigation tools at the bottom. All four reports were created from quiries. I have checked the properties of all four reports, they are all set to default report view.

Maybe important to note my form is not exactly the same as the lesson example. My subform is on a page, in a tab control, on my form. But why this would effect all but one of my four reports I don't know.

Any help would be greatly appreciated.
Janice

Last edited by jlbrown; February 2nd, 2012 at 04:17 PM.. Reason: Correction
 
Old February 3rd, 2012, 09:19 AM
gjgriffith's Avatar
Wrox Author
 
Join Date: Jul 2009
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default Working with Subforms and Subreports

Hello Janice,

Thank you so much for reading Chapter 35: Working with Subforms and Subreports in the Microsoft Access 2010 24-Hour Trainer book and for posting your question here! You said:

Quote:
...when my reports appear in the subform only one report in the database shows all records. ... my form is not exactly the same as the lesson example. My subform is on a page, in a tab control, on my form. But why this would effect all but one of my four reports I don't know.
So, my guess to fixing your problem would be to check the "Link Master Fields" and "Link Child Fields" properties of the Subform/Subreport control. If you just want to show each report AS-IS (without automatic filtering from the record selected in the parent form), just leave both of those properties blank. Does this make sense and does that solve your issue?


One thing that is not mentioned in the book (that I should probably have mentioned and I apologize for) is how the settings for the "Link Master Fields" and "Link Child Fields" properties of the Subform/Subreport control affect the data shown inside of the Subform/Subreport control. When the "Link Master Fields" and "Link Child Fields" properties are set for the Subform/Subreport control, the data source of whatever object that is shown in the control is filtered on the record that is selected in the parent form. Does that make sense?

For example, using the Northwind sample database, if I create a new form, set it's "Record Source" property to the "Orders" table, I have a simple form that is tied to the records in the "Orders" table. Now, if I drop a Subform control (from the Form Design Tools Ribbon, and NOT by grabbing the Form from the Navigation Pane) onto the new Form, and simply set it's "Source Object" property to the "Order Details" table, it will show ALL "Order Details" records in the table, no matter what is selected in the parent form.

But, let's say I want the Subform control to show ONLY the "Order Details" records for the particular "Order ID" of the record that is selected in the PARENT form. In that case, I can set the "Link Master Fields" property to the "Order ID" field (from the "Orders" table) and "Link Child Fields" property to the "Order ID" field (from the "Order Details" table), and now the Subform control auto-magically filters the "Order Details" records shown in the control based upon which "Order" record is selected in the Parent form. Pretty AWESOME stuff and you didn't even have to write a query to make this functionality possible!!!

One other thing that is not mentioned in Chapter 35 (that I should probably add in the next edition) is that when you drop a Form/Report from the Navigation Pane on to another Form or Report (to create the subform/subreport control), it starts the "Subform wizard" and depending on the choices that were made in that wizard, Access MAY automatically set the "Link Master Fields" and "Link Child Fields" properties for the Subform/Subreport control.


Anyway, I hope this information helps solve your problem, but if you have any more questions, please let me know and I'll do my best to provide a solution. And thank you again for reading the Microsoft Access 2010 24-Hour Trainer book, we truly appreciate your readership!

Thanks,
__________________
Geoffrey L. Griffith
http://www.ImagineThought.com

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->
 
Old February 3rd, 2012, 04:34 PM
Registered User
 
Join Date: Feb 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Geoffery,

Thanks for the quick reponse to my post. I reviewed my controls setup after reading your suggestion but unfortunately that wasn't the answer to my problem. Everything seemed to be set up correctly.

I ended up deleting and recreating my subform and reports. Now everything works great!!

Thanks again. I have been working on this database for a year now...mostly self taught through books like yours. I must say yours has been one the best for content and simplified language...very important to someone like me...first time database designer. You may hear from me again as I continue to venture into the programming part of this project.

Have a great day!
Janice
 
Old February 4th, 2012, 05:59 AM
Hermaarlson
Guest
 
Posts: n/a
Default lesson 35

what kind of lesson 35 which type

EFaucets Coupons
Received Infraction
 
Old February 4th, 2012, 08:13 PM
gjgriffith's Avatar
Wrox Author
 
Join Date: Jul 2009
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default Thanks

Hi Janice,

Thank you so much for your kind words about the Microsoft Access 2010 24-Hour Trainer book, that was so nice of you to say about the book! My only hope is that people find it helpful and learn from it and I really appreciate your readership!

Also, I'm extremely glad to hear that you got your problem worked out. Hopefully your Subreports are working correctly now, but if you have any more questions, please just let me know and I'll do what I can to help!

Thanks again,
__________________
Geoffrey L. Griffith
http://www.ImagineThought.com

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->

Last edited by gjgriffith; February 4th, 2012 at 08:20 PM.. Reason: spelling





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 1 p 35 step 6 Frodo BOOK: Beginning Building Mobile Application Development in the Cloud 1 April 14th, 2013 12:16 AM
"Chapter 35: Reporting" Lert_commander BOOK: Visual Basic 2010 Programmer's Reference 6 May 10th, 2012 04:03 PM
Problems in Listing 8-35: Asynchronous command processing using the callback approach Pegasus40218 BOOK: Professional ASP.NET 3.5 SP1 Edition: In C# and VB 2 May 29th, 2011 02:20 PM
Page 35 Errata LongJohnSilver BOOK: Professional Visual Basic 2008 ISBN: 978-0-470-19136-1 2 January 9th, 2009 09:26 AM
Page 35 error. Patrick Cambria BOOK: Professional Visual Basic 2008 ISBN: 978-0-470-19136-1 0 December 24th, 2008 07:36 AM





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