Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 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 Display Modes
  #1 (permalink)  
Old February 2nd, 2012, 03:02 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Location: Cumberland, BC
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
Reply With Quote
  #2 (permalink)  
Old February 3rd, 2012, 09:19 AM
gjgriffith's Avatar
Wrox Author
Points: 503, Level: 8
Points: 503, Level: 8 Points: 503, Level: 8 Points: 503, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 109
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! *** ---------------------------------------------------------------------------------------------------------->
Reply With Quote
  #3 (permalink)  
Old February 3rd, 2012, 04:34 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2012
Location: Cumberland, BC
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
Reply With Quote
  #4 (permalink)  
Old February 4th, 2012, 05:59 AM
Hermaarlson
Guest
 
Posts: n/a
Default lesson 35

what kind of lesson 35 which type

EFaucets Coupons
Reply With Quote Received Infraction
  #5 (permalink)  
Old February 4th, 2012, 08:13 PM
gjgriffith's Avatar
Wrox Author
Points: 503, Level: 8
Points: 503, Level: 8 Points: 503, Level: 8 Points: 503, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 109
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
Reply With Quote
Reply


Thread Tools
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
Chapter 1 p 35 step 6 Frodo BOOK: Beginning Building Mobile Application Development in the Cloud 1 April 14th, 2013 01:16 AM
"Chapter 35: Reporting" Lert_commander BOOK: Visual Basic 2010 Programmer's Reference 6 May 10th, 2012 05: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 03: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



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


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