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 September 4th, 2007, 09:50 PM
Authorized User
 
Join Date: Sep 2007
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default A good Access book

I need an Access book that is [u]easy to understand</u>, but handles some of the complex stuff I need to know. Any ideas?
What would be nice would be an actual case book that would take you through step-by-step. Northwind, the Access sample, is pretty neat, but it lacks some bells and whistles that I am trying to achieve.

Reply With Quote
  #2 (permalink)  
Old September 5th, 2007, 09:47 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

What is the complex stuff you need to know? What parts do you want to be easy to understand?

Like, you might get a book on database design, and one on Access forms and reports, kind of thing.

mmcdonal
Reply With Quote
  #3 (permalink)  
Old September 5th, 2007, 10:50 AM
Authorized User
 
Join Date: Sep 2007
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the reply. I want something that shows me how to do some of the things I have just asked. I have just dabbled a bit in Visual Basic and am not an expert. I have gone to the local bookstore and have gotten the 4-inch thick Access books that start with how to design a table. What I would like to see is a casebook of problems that have been solved, complete with simple explanations and screen captures taking me through the whole process.

For example, you gave me a great reply about the combo boxes. I will do my best to try to follow it. I would love to have a book that took me through it step-by-step, showing me the whole process in pictures and words.

Reply With Quote
  #4 (permalink)  
Old September 5th, 2007, 11:17 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

The problem you will find is that if it has pictures, it is for users. Most Access books, while laid out in the usual order of things, are reference works.
The closest you may get are ... don't tell them I told you this ... O'Reilly Cookbooks and Hack books, and one book by MS Press called "Building Microsoft Access Applications". Wrox also has a good one, although somewhat limited in scope: "Expert One-on-One Microsoft Access Application Development."

Otherwise, I think that is why most people post here, is that there doesn't seem to be anything like you want, especially with pictures.


mmcdonal
Reply With Quote
  #5 (permalink)  
Old September 5th, 2007, 06:53 PM
Registered User
 
Join Date: Aug 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There are many different books out there and everyone learns differently.

I have personally found the following to be very helpful. It covers many different subjects and has you enter the code on a step by step process. Basically, walking you through the process. It does a great job at explaining what is happening at each step.

http://www.wordware.com/Merchant2/me...ode=1556222238

And I think you can even find it cheaper on Amazon.

Cheers,

John

Reply With Quote
  #6 (permalink)  
Old September 13th, 2007, 11:23 AM
Registered User
 
Join Date: Sep 2007
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Do any of these books explain cascading combination boxes? I need a step by step because I can't get mine to work using online help.

Thanks

Reply With Quote
  #7 (permalink)  
Old October 3rd, 2007, 10:20 PM
Authorized User
 
Join Date: May 2007
Location: , , .
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default

what do you mean by cascading combo boxes?

one combo boxes results based on the chosen field in another?

The answers are posted all over the net which do work. However there is one issue - what type of form are you using the combo boxes on?

As I understand it, right or wrong, its generally not possible to have cascading combo boxes on continous or datasheet forms. Building MS Access Applications book does give an explanation and an example of how to do this however I've never managed to replicate it successfully.


Reply With Quote
  #8 (permalink)  
Old October 4th, 2007, 09:25 AM
Registered User
 
Join Date: Sep 2007
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

one combo boxes results based on the chosen field in another?
YES, I want the second combo box to filter based on the selection made in the first box. I have a simple databse I create to "play" with this. The second filters based on the first, however, the field names can not be seen in the drop down once the second filters. AGH!

These 2 combo boxes are in a regular form.

Reply With Quote
  #9 (permalink)  
Old October 22nd, 2007, 05:15 AM
Authorized User
 
Join Date: May 2007
Location: , , .
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default

ok, using this scenario, picking the category then selecting the product

product category =cboprodcat
product = cboproduct

private sub cboprodcat_afterupdate()
me.cboproduct.requery
end sub

private sub cboproduct_beforeupdate()
me.cboprodcat.requery
end sub

make sure the category key in the query for product is set to me.cboprodcat

That works for me.


Reply With Quote
  #10 (permalink)  
Old October 22nd, 2007, 05:16 AM
Authorized User
 
Join Date: May 2007
Location: , , .
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default

For books try "access hacks" and "fixing access annoyances" reasonably cheap from amazon

There's no one book that will solve all your problems with access

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
Good In-between book? wilbo ASP.NET 2.0 Basics 0 April 18th, 2008 09:37 AM
Good Foxpro book M_Eslinger Wrox Book Feedback 1 June 2nd, 2005 06:46 AM
Looking for a good sql book method SQL Server 2000 1 April 27th, 2005 10:04 AM
good book Jim Shores BOOK: Expert One-on-One Access Application Development 1 July 8th, 2004 07:26 PM



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


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