visual basic

So you have created your Access database and have exhausted every wizard and control that you can use without actually coding. You still need a little something, but aren't sure how to get a little (or a lot) more out of Access - then this is the book for you.
This book will ease you into writing come code while jumping right in with both feet. The examples are simple enough to understand, but you are given enough information to make them work for you. Many times when you are beginning, the example is exactly what you want to do, but you are not given enough information to insert it into your project and make it work - this is not the case here. I had this book (and its predicessor) open on my desk regularly during my first Access project and still crack it open for ideas and reference. (Sure I could look it up in an advanced book - but why?)
If you can only buy one beginner book on VBA - this should be it.

Callahan takes the newbie by the hand and reviews the basics of VBA in a very useful and easy to understand style. If you've mastered the basics of Access and want to see how they do all that cool stuff in forms and reports, this is a great place to start. BUT if you've already done a little programming, this book will waste your time! Go for Beginning Access 2000 VBA by Sussman and Smith. A true intermediate book which no one should try to read until they know some of the fundamentals and a book I keep right next to Access Developers Handbook.

This book helped me a lot. I was at the point where I knew the basics of Access, but nothing about writing code. This book is excellent for taking you by the hand and helping you to start learning VBA. Another feature I really like is that the examples are examples that you are likely to find useful for the application you are developing. So I was able to got a very practical use out of this book (the Access 97 version is very similar).
On the negative side, sometimes the book gives poor explainations. For example, they never really explain why create variables, what's the advantage. There are several similar areas where the author simply never thought of explaining something that, to a beginner, is very confusing without an explaination.
So, by itself, the book is very helpful but you need other books to fill in the gaps. However, as far as I've seen, it's the best book I've seen to get you started in VBA.