Microsoft 2003 Code

[FreddieIT]

Hello, first off let me thank you for taking the time to read my question. I just wanted to see if anyone has any informative websites or possibly know of any good books on how to write and understand code in VBA? I know a little, but I want to be able to write modules and code better and I am looking for a starting point. Any help is great appreciated.

Thank you

[Stewart Ross]

Hi FreddieIT. Although not a beginners book, I recommend the VBA Developer's Handbook by Ken Getz and Mike Gilbert, published by Sybex, which I use as a reference source myself.

It covers a wide range of topics and comes with databases and code for each chapter.

Another excellent book which is more focused on development of Access applications start-to-finish is Building Access Applications by John L Viescas, published by Microsoft. In this book the VBA is used to expand the functionality inherent in the Access user interface.

There are many others, I am sure, but these two alone could take many months of study, enhancing your knowledge of VBA and how to apply it in real-life situations.

Welcome to Bytes!

-Stewart

[FreddieIT]

Thank you very much Stewart, I will search these books and give them a try, a question I do have is how is the readability?

[Stewart Ross]

Both books are very well-written and are not just rewrites of technical manuals or help-file quotes. The VBA Handbook covers more territory than Viescas's book, but this in turn makes it a more difficult read unless you have already got some VBA experience - as I said, it's not a beginners book - so it would be worthwhile seeking out a copy of John Viescas's book first.

Both books display very good attention to code construction and formatting. Code segments in both books are mirrored in working examples provided on CD, and all are fully commented and well-presented.

-Stewart

[FreddieIT]

Thank you very much Stewart! I have purchased both books and I am going to read up on them and utilize their capabilities.

Thanks again!

[DataAnalyzer]

I would echo the value of the VBA Developer's Handbook.

I've also learned a ton (and used a bunch) of code from FMS' Total Visual SourceBook. It's a code library with the VBA code, documentation, and examples. It's a commercial product so it's costs some bucks but it's saved me a bunch of time. The areas it covers is here: http://www.fmsinc.com/MicrosoftAcces...ode/index.html

Would actually recommend their developer suite which includes some other products to help with Access development.