The book I used, and recommend, is:
Beginning Access 97 VBA Programming by Robert Smith and David Sussman, WROX Press. There is a 2000 version also.
The reason I liked this book better than some I reviewed is that the authors concentrate on VBA and provide very good step by step exercises and each exercise is fully explained. The book comes with a full set of sample databases with a lot of code examples.
Hope this helps.
Larry De Laruelle
ldelaruelle@familychildrenscenter.org