Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning Access VBA
This is the forum to discuss the Wrox book Beginning Access 2002 VBA by Robert Smith, Dave Sussman, Ian Blackburn, John Colby, Mark Horner, Martin Reid, Paul Turley, Helmut Watson; ISBN: 9780764544026
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Access VBA 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 January 22nd, 2004, 02:16 AM
Registered User
 
Join Date: Jan 2004
Location: Mission, BC, Canada.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Beginning Access VBA

Hello,
I recently saw the Book advertised at our local book store. I work in a jail and have been trying to develop a database to manage inmate programs, work, and wages. As a beginner in Access I decided to pay for some professional help. I posted to a newsgroup and found a local Access "Guru" who knew Access and VBA programming very well... but as it turns out he knew ZIP about the "project development lifecycles". He did not listen to my needs and as a result, I have a cute db with a separate db and front end. It does nothing for us. I am out of pocket $1000 for the table development and normalization... and a few queries... but have had to revert back to excel to manage the data.

So, realizing that I am going to have to learn this and do it myself, I found the book from WROX... that appears .. or at least CLAIMS to be aimed at novice Access users. I am no computer dummy... having 26,000 hours experience. I know a little bit about everything.... and not enough about one thing (ACCESS!!) to use it properly.

My question then is this..... Does this book really have what it takes for the beginner at VBA to pick up and run? To build my database, I realize I will have to be able to write lots of VBA code.

Sorry for the lengthy intro.... but here I am ... very frustrated!!


:D

N. Walsh
 
Old January 22nd, 2004, 10:19 AM
Authorized User
 
Join Date: Dec 2003
Location: Middletown, CT, USA.
Posts: 81
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I can only speak about the WROX ASp books...having a good knowledge of html and of access, I needed the 'connection' so to speak. The WROX book was one of three on ASP that I bought. One book was very graphic and task oriented, the second was very technical...both good in what they did. The third book i purchased was the WROX book on ASP...it was by far the best in its style, ability to understand, the useful appendices of information and of course introduced me to this forum. If their access book is anything like the ASP book, I would highly recommend it. Please also peruse the ACCESS thread here on a regular basis. There is something I learn everyday...even if it is a simple technique.

John

 
Old January 22nd, 2004, 11:58 AM
Registered User
 
Join Date: Jun 2003
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I teach a community college course using this book as my only textbook. The book has its failings (some errors), but it is the best book I have found for teaching VBA to students. The book I use is the Access 2002 VBA book and it was rewritten from the Access 2000 VBA book. They obviously planned on making some changes to the way they present the data, but did not always follow thru with the files needed. This is primarily evident in chapter 7, where they refer to a database for that chapter that does not exist. If you use this forum, you will get information and help on these few drawbacks. I still think that it is a good learning book and I am able to build assignments for my students around the material covered. Good luck.
 
Old January 22nd, 2004, 03:50 PM
Registered User
 
Join Date: Jan 2004
Location: Mission, BC, Canada.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

:)
Thank you both for the responses. I have searched extensively for many months to get to this point. I believe the WROX book is the one that is going to make the difference for me. I get anxiety attacks when I think about the time I have wasted when I could have been studying Access. I am determined to master this stuff. Even today at work the shift scheduler called me to assist on an excel problem. We have over 250 staff members to schedule. We control their hours through excel. To complicate things, we have seniority rankings. When one staff from say... the #100 spot gets more hours than the #99 spot, for example, then 100 overtakes 99. Seniority is base on how many hours you have. So they are always jumping each other. In excel, when the scheduler moves one single person, the sheets for the remaining months also need to be changed. It is hours of work.

Access should be able to handle this easily. I will start working on it soon. I have bookmarked the forum at home and work and will check back daily.

Thanks again.

Nick.

N. Walsh




Similar Threads
Thread Thread Starter Forum Replies Last Post
Beginning Access 2002 VBA Chapter 3 Olivia54 BOOK: Beginning Access VBA 3 January 24th, 2006 12:11 PM
Beginning Access 2002 VBA Chapter 5 Olivia54 BOOK: Beginning Access VBA 2 August 16th, 2004 02:20 PM
Beginning Access 2002 VBA Code pajiyar BOOK: Beginning Access VBA 0 July 12th, 2004 08:04 AM
Does anyone have the Beginning Access 2002 VBA CD? sristm Access VBA 0 March 21st, 2004 04:27 PM





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