Even though this is for Access 2000, I don't think there's a better book out there to really wrap your head around VBA coding quickly: It's called Beginning Access 2000 VBA by Robert Smith and David Sussman, WROX press.
I taught Access VBA for a couple years and have been doing Access development work for over 10 years... this book is a 700 page tutorial (best done AS a tutorial) that reads fast (and somewhat entertaining as well). CD-rom has tons of code snippets and samples to use with the text. Very, very, well done.
Im looking for a good access VBA book. Im advanced in access but completely new to VBA but have done other programming languages like c, c++, java, php and a few others