Rating: 
Summary: Where have all the Macros gone?
Review: After developing in Access & SQL Server for a number of years, I was always intimidated by VB development and had made a conscious effort to develop "work-arounds" for my lack of hard-coding skill. However, my current project required that I take-over and inherit someone else's work. Imagine my horror when I discovered that the person who built the database I had to maintain had done so almost entirely in VBA (and didn't document a single word of code). Where were all the macros? Where had my happy place gone? I begrudgingly accepted the fact that I would have to learn VBA in order to fix this database and support it. Although I'm not quite through the book, I felt like it was written specifically for guys like me. You must know your Access and your basic theory of database, but if syntax and coding experience is what you need, this book is great. I plan on getting the "Professional" version by Wrox as well.
Rating: 
Summary: Love it
Review: Am about 180 pages in and I'm getting a lot of use out of this
book. Liked programming in VB for Dummies but this book doesn't skip any steps explaining the code so you're not wondering how they got from A to F.
Many useful ideas, pieces of code.
Some typos. CD helpful
Rating:
Summary: Love it
Review: Best book on VBA i've ever had the misfortune of reading. Not the most pleasant of subjects, but this book did a masterful job of presenting ideas, structures and syntax in a clear, easy-to-read format. I am now programming like an ox thanks to this book. Avoid the horrible Susan Novalis Access VBA Handbook and get this one instead. Full of sample code, and the CD has many apps you can steal and modify to suit your needs. Bravo, Wrox.
Rating:
Summary: Pork loaf
Review: Best book on VBA i've ever had the misfortune of reading. Not the most pleasant of subjects, but this book did a masterful job of presenting ideas, structures and syntax in a clear, easy-to-read format. I am now programming like an ox thanks to this book. Avoid the horrible Susan Novalis Access VBA Handbook and get this one instead. Full of sample code, and the CD has many apps you can steal and modify to suit your needs. Bravo, Wrox.
Rating:
Summary: Self taught? Frustrated by syntax? Get this book!
Review: Do you really want to learn code? Do you even know what DAO and ADO are? When you do get behind Forms into VBA do you know what all that syntax means? Are you writing your own Functions? Do you know what every line of this code means? If you answer 'no' to any of these questions, get this book. It is great! You'll learn the nuts and bolts of Access 2000 and VBA. You will have to apply yourself some. I now know what this code means because I wrote it (and dozens and dozens of more lines) and you can too! (the code got messed up by the review formatting)Private Sub SaveThisRecord_Click() Dim db As Database Dim rec As Recordset Set db = CurrentDb() Set rec = db.OpenRecordset("tbljobhoursdetail") rec.AddNew rec!EmployeeID.Value = Me![Text2].Value rec("job#").Value = Me("txtjob#").Value rec!DateWorked = Me!txtDateWorked.Value rec.Update rec.Close End Sub
Rating:
Summary: Are you self taught? Does syntax frustrate you? Get this one
Review: For all of us that use Access and want to code a bit, but can't find a good source to explain syntax, this is the perfect book. Don't think less of this book because it doesn't have a lot of ADO in it. If you don't understant DAO and Access objects well you won't be using ADO anytime soon. After applying myself to this book I can write my own functions, routines and understand the nuts and bolts of VBA and Access 2000. If you don't know what each of these lines mean, get this book. (Thanks to Rob and Dave I now do, because I wrote them and dozens more - who knows how this display in the review) ++++++++++++++++++++++++++++++++++++++++++++++++++++ Private Sub FISCAL_2000_PROJECTED_AfterUpdate() Dim varProj As Variant varProj = DLookup("fiscal 2000 projected", "tblCustCode-Projections", "forms!frmSaleman!Custcode =[custcode]") End Sub ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Function laborcodetext(REGOT2x As Integer) As String If REGOT2x = 1 Then laborcodetext = "Reg" ElseIf REGOT2x = 2 Then laborcodetext = "OT" ElseIf REGOT2x = 3 Then laborcodetext = "2X" End If End Function ++++++++++++++++++++++++++++++++++++++++++++++++++++ Private Sub SaveThisRecord_Click() Dim db As Database Dim rec As Recordset Set db = CurrentDb() Set rec = db.OpenRecordset("tbljobhoursdetail") rec.AddNew rec!EmployeeID.Value = Me![Text2].Value rec("job#").Value = Me("txtjob#").Value rec!DateWorked = Me!txtDateWorked.Value rec.Update rec.Close End Sub
Rating: 
Summary: Definitely NOT recommended for the beginner
Review: I bougth this book and discovered that it was not for someone like me just learning Access VBA. In fact I had to buy Access 2000 VBA Handbook by Susann Novalis (ISBN 0782123244) simply this book did not cut is for me as a beginner. If you are starting out and know little or nothing about Access VBA DO NOT BUY THIS BOOK. Instead I recommend Novalis. With Novalis, you will learn to create forms, print to list box, sort records, create recordset, simple SQL and much more that can get you started on creating greate Access databases using VBA.
Rating:
Summary: Detailed examples, clear progression, lucid explanations.
Review: I felt this book was written for me. I received it, turned to chapter 8, and there in front of me was a solution I had been searching for weeks. My relational database is now easily searchable for those inept at constructing queries. Yay! The book's strongest feature is the many detailed examples that are clearly explained and progess in a logical order. The book also serves as a useful refresher for basic object-oriented concepts, and contains a CD with all of the code. If you're new to SQL or wonder what "events" are, look for a simpler book. This book is definitely for those who understand basic SQL and relational database design, have designed customized forms/queries/reports, and want to take their Microsoft Access database to the next level.
Rating:
Summary: Excellent, excellent tutorial. (Did I mention excellent?)
Review: I have about 12 books on Access development in my bookcase and this is one that I can't stop reading. Why? Because it's done like I think a good beginners book should be. Many books contain a lot of babbling and not enough 'good' examples. This one is different. Hundreds of useful examples, well explained, waiting to be typed (or used from the CD) can be found. The book explains very well their choice of using DAO over ADO, I thing it's a very good idea. As far as I'm concerned, I thing it's one of the best solid introduction to Access VBA you can find. As an Access teacher, I found some very good concepts and approaches in their projects. You're very familiar with Access interface? Was exposed to VBA a little? Willing to bring your apps to new heights? Want to see some examples? Then this book IS for you. The pace is reasonable, the writing is great, there are easy to more complex concepts explained. As the title implies, this is a beginning VBA book, not a developer's handbook. But don't be misled by the word 'Beginning', there is serious stuff in there like Class objects, networking issues and approaches to solving good problems. You're tired of books saying, you could do this or do that without explaining how? This book is not like that. Finally, a book that left out that Northwind omnipresent database and came up with something different!
Rating:
Summary: Nice follow up to Access 97 VBA
Review: I previously bought Access 97 VBA and recently ran into problems in Access 2000. After realizing that I was lost just enough to do damange to myself and my job, I bought this book. It explains the differences between ADO and DAO, which was the cause of most of my troubles, very well. As was the case with the 97 version, the examples clearly show how to do most of the things that I wanted to accomplish. This is listed as a beginning book but I think I'd recommend having some programming experience first. This is a nice companion to the 97 version or just a good place to start in on extending the functionality of Access 2000 with VBA.
| 
