Microsoft Access 2010 VBA Programming Inside Out

Bought this used (arrived in great shape) because it has some advanced concepts that is hard to find in a single product and I was wanting to get into OOP more. This is NOT a beginner's programming book - it assumes you're very well-acquainted with Access and VBA already. It does give you some great ideas on how to do more esoteric functions in Access (connectivity to other files, file handling, Office Integration etc.) as well as how to make simple list controls work better for you (something I'd never thought of), to even drawing dynamic graphics on a form (well, sorta).The book even specifically addresses something I was originally after -- How to make a 'wrapper' class module that allows you to define bulk form control event handling. Unfortunately, the way the book presents this, the way is to make calls for every control -- which is almost pointless, since a form with 15 custom controls would need 15 custom calls. However, using the methods introduced PLUS some StackOverflow tips (which were not working in Access) PLUS a few hours of programming and thinking on my part -- and I've got it down and the solution is beautiful.That's just one small negative so far -- There's a lot of good stuff in the book, lots of code typed out in the pages so you don't have to hunt down the sample files if you're lazy (they still exist) -- and the errata pages are only like 6, which isn't bad at all -- all found online at the link given in the book.Yes, in 2020, this book is still relevant because of the concepts of VBA introduced -- I DO wish the book tackled how to develop an iron-clad way for Access to always pop up a window in the middle of the screen (they don't address that bug -- given that it's a Microsoft book I believe) but otherwise it's a good reference. Anyone who's used pop-up windows in Access, especially on multi-monitor setups, probably feels my frustration.

I am impressed with the information. It does require a little more knowledge of VBA, however, than just walking into this with no knowledge at all. Two things to look at before getting into this book:1) The first two videos of the "Wise Owl Tutorials" video series on VBA. These are done for Excel, so after the first two videos, the language is different. However, the incredibly well presented information on the syntax and layout of programming in general (specific, in this case, to VBA) is completely invaluable. Also, it is worthy of note that the VBA Editor window is identical on ALL MS Office products. Here is the playlist: https://www.youtube.com/playlist?list=PLNIs-AWhQzckr8Dgmgb3akx_gFMnpxTN5 (several of the videos are good general info that will be helpful, so you don't HAVE to stop after the first two! :) )2) You MUST understand the naming conventions that are used in this book! It will COMPLETELY lose you if you don't know a LOT about Access and the naming conventions that are normal. The best and most complete list of normal naming conventions for Access has been assembled by "Reddick", and can be found here: http://www.xoc.net/standards/rvbanc.aspEnjoy this book! With the examples you can download from MS (referenced on the back cover and inside), you can practice and learn very well. This is good!

A very useful book but as with all software books, it would have been better if a few real users of different levels of expertise had been able to read it as it was written because some articles/paragraphs assume you know more than you know. But I have an older VBA programming book for another Microsoft Office program which often helps me understand some of the information in this book. And that is usually the case with these type of books for today's software. You really need two books from different publishers to really grasp the whole information about using a new complicated piece of software. It is too bad that software companies seem to let people from the development group write the manual that comes with the program whether it is a book or a PDF file, or an e-manual. (e-manuals really suck because they could be but usually are not, updated.)

Wasn't easy to figure out how to create an application from the way the material was presented. It builds a foundation with different topics and shows you the different options available (e.g. different UI modes built-in) and then later brings it together. However, this format made it difficult (for me) to figure out how to use VBA and Access.This book is more of a reference for this different aspects of VBA and Access, and covers a lot of material. The author is very knowledgeable of this stuff. So if you're more experienced in using Access with VBA, this book is invaluable. But I'll need a different book to get up to speed on putting it all together.

You will still need to go online to the Microsoft site for a detailed reference of each control and its properties/methods. But this will get you so you know the right questions to research. I haven't read the whole thing cover-to-cover yet, as I bought it to complete a "hurry up and do it now" project a little outside my comfort zone (MS SQL Server and ASP.Net). And maybe it does have the answers to some of my lingering questions. But I got it done anyway. My Access VBA code probably looks more like C# and ASP.Net than a purist would prefer. If they keep sticking me with Access projects I will dig deeper.

Great book lots of good ideas but it's difficult adapting some of the code for you own uses. I'm not an expert programmer.

I am a certified MS Access 2003 developer and needed a book to help with my clients wanting to upgrade the apps I had written for them. This book really had a wealth of great information. I have dozens of sticky notes on it marking areas that I could use in current projects. I also appreciate the downloadable PDF version of the text and code samples ready to copy into my modules. After scanning the book so I knew what was in it, I have used the PDF version to search for things the most.

There are a load of Access programming books on the market but this volume that concentrates on the VBA aspect is just what I was looking for. I have written VBA for a number of years using self tuition, previous programming experience and seeking help on the internet. Even though I thought I was familiar with the development environment I decided to read this book from the beginning and I have found many tools and tips that were totally unknown to me. However it's written in such a way that it is easy to follow and doesn't overly detail obvious basic features.If you're looking for a great no nonsense VBA guide I thoroughly recommend this one.

I can only really confirm what other reviewers have said. This book does exactly what it sets out to do - provide a comprehensive guide to VBA programming ... for readers who already know a fair amount about Access and programming. I started programming professionally in the days of punched cards and magnetic tape but I have never got to grips with VBA previously. This book is exactly what I needed.

Very detailed but it helps if you have some knowledge of Visual Basic. Code and ebook available for download.Other books did not go into enough depth but this one is very good.

The detail of using VBA with Access I was looking for.

Clear, concise book, with the downloads you need to wrap your head around VBA in its current form.