I should have a file to insert for this perennial question:
-Sybex for sure
-Access 2000 Power Programming, Scott Barker, Sams Pub
Good intro with useful stuff:
-Intro to Access 97/2000 VBA, Smith Sussman, Wrox
Also keep Notepad in your toolbar and read this forum religiously. There are some real ringers in here who are very generous with their time and talents.