I am looking for suggestions on a good book to learn VBA. I have not
programmed anything since 1979 when I wrote programs in Basic on a Commodore
Pet with 8K of memory and saved them on audiocassettes. I am a little behind
the times. I've worked with Access somewhat and am proficient in designing
tables, writing queries and designing reports. I worked as a SQL Server
admin for three years and have a fairly good background in relational
databases and writing SQL code, but I don;t know any object oreinted
programming. I'm doing a lot of work now in Access and need to go to the
next level which is, I believe, learning some VBA. Need to know what DoCmd
is and what Me. is and what DIM is and Set rs = CurrentDb.OpenRecordset.
Guess I need to start simple.

Any suggestions much appreciated!

Thanks,

Peter Hack

Que - Using Access ____ (Sometimes in Special Edition)
    This is a great book for starting out with VBA. It
gives a lot of detail on other stuff too (Tables, forms,
reports, etc.), and has some chapters for beginners level
VBA in the back.

Sybex - Access ____ Developer's Handbook
     This book is a gold mine of technical information for
how to do very complex VBA tasks. It's best to read the
VBA chapters of the previous book before starting this
one, since it's a more advanced level.

Que - Access ____ Expert Solutions
     Where the Sybex book is great at listing raw details
of VBA programming, this book gives you more finesse. It
approaches Access more from the standpoint of
creating "professional looking" applications. It goes over
the whole application development process, including
things like interviewing end-users prior to development,
deploying the application, as well as good suggestions for
design.

And, of course, if there's something you can't find in a
book, this newsgroup is a great resource!

If you can only afford one, I usually find myself in the
Access ____ Developer's Handbook more than anything else.

Hope that helps!

However, let me caution that knowing VBA is not, in itself, enough. You have
to be well-versed in the Access object model, the properties, and how things
are done manually with Access, too. That's because a major part of what we
do with VBA is to automate things we could do manually.

  Larry Linson
  Microsoft Access MVP

--
HTH
Van T. Dinh
MVP (Access)