Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | 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 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 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
Reply With Quote
  #2 (permalink)  
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

Reply With Quote
  #3 (permalink)  
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.
Reply With Quote
  #4 (permalink)  
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
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
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



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


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