Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > BOOK: Access 2010 VBA Programmer's Reference
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
BOOK: Access 2010 VBA Programmer's Reference
This is the forum to discuss the Wrox book Access 2010 Programmer's Reference by Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison; ISBN: 978-0-470-59166-6
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Access 2010 VBA Programmer's Reference 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 August 16th, 2011, 06:27 PM
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2011
Posts: 1
Thanks: 1
Thanked 0 Times in 0 Posts
Unhappy Problem finding Application that go with code

I everyone, maybe I'm missing something or it just isn't included. In a few of the chapter code downloads, Chapter 6 and Chapter 13 there is no applications just code in txt files. On page 481 it referances Chamber Application files inclued with this chapter. There is no application files in this directory. I found this application in the application directory however it is a runtime.
Does anyone have an answer?
Reply With Quote
  #2 (permalink)  
Old August 16th, 2011, 08:30 PM
gjgriffith's Avatar
Wrox Author
Points: 517, Level: 8
Points: 517, Level: 8 Points: 517, Level: 8 Points: 517, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default Chamber Application Source Code for Chapters 6 and 13

Hello Aubrey,

Thank you so much for reading the Access 2010 Programmer's Reference, we really appreciate you taking the time and effort to post your questions here. Specifically, you said:
Quote:
Chapter 6 and Chapter 13 there is no applications just code in txt files.
First, I just wanted to say that you're not the only person to be confused about this issue, and we apologize for the confusion. The "Chamber Application", that is referenced in these chapters is actually included in the Appendix I source code files, which you can download from here:
http://media.wiley.com/product_ancil...ps_samples.zip

If you click the link, download the ZIP file, and then unzip it, you will get a folder that contains a file named "Chamber Application.accdb" (among the other files). When you open this file, you may get a macro error if the database is not trusted (the first time you open it for sure). So, if you just want to open the Navigation Pane (which is hidden by default in the application), before opening the database file, hold down the SHIFT key when opening the database to enable the Nav Pane.

Anyway, I really hope this helps answer your questions, but if you have anything else, please let me know! And thank you again for reading the book, we really appreciate your patronage!

Graciously,
__________________
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; October 11th, 2011 at 01:49 PM..
Reply With Quote
The Following User Says Thank You to gjgriffith For This Useful Post:
AubreyLawrence (August 16th, 2011)
  #3 (permalink)  
Old October 8th, 2011, 01:07 AM
Registered User
Points: 9, Level: 1
Points: 9, Level: 1 Points: 9, Level: 1 Points: 9, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default

When I open "Chamber Application.accdb" I can't see the Nav Pane, because it's hidden in the Access Options dialog box. Thanks, now I understand this.
But what's with the ribbon? I can't see the full ribbon, only if I start the database file holding down the shift key. I try to understand this. There is no "USysRibbons" table and the file extension is accdb not accdr or accde. I got the full Access-Version not the runtime. Please explain me, why "Chamber Application.accdb" starts like in runtime mode. What are the things I have to do, if I want to get the same behavior to my database?

Thanks, Roland
Reply With Quote
  #4 (permalink)  
Old October 11th, 2011, 02:01 PM
gjgriffith's Avatar
Wrox Author
Points: 517, Level: 8
Points: 517, Level: 8 Points: 517, Level: 8 Points: 517, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default Check the "Current Database" tab in the "Access Options" dialog.

Hello pro0011,

Thank you so much for your follow up to this posting, I'm so sorry it has taken me so long to get back to you on this, but I wanted to follow up on your question! Specifically, you said:

Quote:
Please explain me, why "Chamber Application.accdb" starts like in runtime mode. What are the things I have to do, if I want to get the same behavior to my database?
To try to answer these questions: The reason that the "Chamber Application" start's up with menus and navigation disabled is due to the settings that are provided on the "Current Database" tab of the "Access Options" dialog (which are the properties of the specific database, and not the Access application itself). For example, if you uncheck the "Display Navigation Pane" checkbox on this tab, this will set the database properties for the application so that the Navigation Pane is not shown the next time the application is opened. Does this make sense?

Hopefully this helps, but if you have other questions about this, please let me know and I'll do what I can to help out!

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
  #5 (permalink)  
Old October 11th, 2011, 02:55 PM
Registered User
Points: 9, Level: 1
Points: 9, Level: 1 Points: 9, Level: 1 Points: 9, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Thanks for your answer, but how to hide the navigation Pane I already knew.

I want to know why the ribbon of "Chamber Application.accdb" is not completely? Only I start the database holding shift key down I get the normal ribbon. I can't comprehend this, because the file extension isn't *.accdr or *.accde

Thanks, Roland
Reply With Quote
  #6 (permalink)  
Old October 11th, 2011, 04:03 PM
gjgriffith's Avatar
Wrox Author
Points: 517, Level: 8
Points: 517, Level: 8 Points: 517, Level: 8 Points: 517, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default

Hi Roland,

Thanks for the follow up. The normal Ribbon is disabled because the "Allow Full Menus" option is unchecked on the "Current Database" tab, under the "Ribbons and Toolbars" section (which is just below the "Navigation Options" section I mentioned earlier) on the Access Options Dialog. Is this the specific setting you are looking for?

Otherwise, if are there are other specific questions that you have about the Access 2010 Programmer's Reference book itself, please just let me know!

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
The Following User Says Thank You to gjgriffith For This Useful Post:
prro0011 (October 11th, 2011)
  #7 (permalink)  
Old October 11th, 2011, 04:43 PM
Registered User
Points: 9, Level: 1
Points: 9, Level: 1 Points: 9, Level: 1 Points: 9, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2011
Posts: 3
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Thank you so much. Now I've got it.

I was wondering why all tabs on the access options Dialog under "Customize Ribbon" were checked and I still saw a disabled Ribbon. The "Allow Full Menus" option on the "Current Database" tab I didn't know until now. Thanks for your good explanation and your patience

Roland
Reply With Quote
  #8 (permalink)  
Old October 19th, 2011, 04:50 PM
gjgriffith's Avatar
Wrox Author
Points: 517, Level: 8
Points: 517, Level: 8 Points: 517, Level: 8 Points: 517, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Talking Glad to hear you got it working!

Hello Roland,

Awesome, I'm extremely glad to hear that you got it working correctly and that you see these setting now! Please let me know if there is anything else we can do to help out with this issue.

And thank you again for reading the Microsoft Access 2010 Programmer's Reference, we truly appreciate your patronage!

Thank 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! *** ---------------------------------------------------------------------------------------------------------->
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 in Finding Hours Duration Between two Dates vishnu108mishra SQL Language 1 January 7th, 2010 10:22 AM
finding "c# data security handbook" code gzfarmer C# 2 April 26th, 2006 03:32 AM
Problem regarding finding the node in xslt. rohitjain13 XSLT 1 October 6th, 2005 03:26 AM
Help me in finding the source code. mpbalshetwar All Other Wrox Books 1 April 6th, 2005 10:00 AM
problem with finding Classified.mdb ali786 Classic ASP Databases 0 March 9th, 2005 05:42 AM



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


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