aziz rasul
Active member
- Local time
- Today, 23:14
- Joined
- Jun 26, 2000
- Messages
- 1,935
I am finding it difficult to decide which book(s) to purchase that will help me to learn VBA. Any recommendations?
Thanks in advance.
Thanks in advance.
A book on VBA
- Thread starter aziz rasul
- Start date
Talismanic
Registered User.
- Local time
- Today, 23:14
- Joined
- May 25, 2000
- Messages
- 377
The book I am using and like is, "Access 97 Macro & VBA Handbook" by Susann Novalis.
I am learning VBA right now also and I found a little trick that is helping me understand the VBA syntax (it also keeps me working while I am learning).
If you can get what you need done with a macro, do it. Then highlight the macro - go to tools - then macros - and select convert macro to VBA. Once that is done you can look at the newly created module to see, cut, and paste the VBA code right into the event procecedure code builder.
I am learning VBA right now also and I found a little trick that is helping me understand the VBA syntax (it also keeps me working while I am learning).
If you can get what you need done with a macro, do it. Then highlight the macro - go to tools - then macros - and select convert macro to VBA. Once that is done you can look at the newly created module to see, cut, and paste the VBA code right into the event procecedure code builder.
ritchieroo
Registered User.
- Local time
- Today, 23:14
- Joined
- Aug 2, 2002
- Messages
- 80
Paul Lomax's "VB & VBA In a Nutshell" is an excellent book, and is a very informative reference for the general use of VB/VBA. The bulk of the book is a function by function reference, with syntax, examples of use, tips and pitfalls. The first few chapters cover programming structure and best practices. -- I always keep a copy to hand!
But you're probably going to need to know how VBA applies to Access: which means learning the object model, the properties, methods and events associated with each object.
There are basically two object models you need to know about:
Data Access Objects (DAO)
ActiveX Data Objects (ADO)
What you need to learn depends on which version of Access you have, and how you intend to use it. DAO is sufficient if you have A97. You may want to learn ADO if you have A2K or greater. You'll definately want to learn ADO if you intend to use Access on the internet (or other remote server).
Also, ADO learning is portable, you can use the same object model to access SQLServer or Oracle databases for example, so it's worth knowing anyway.
I'm sure that you'll get plenty of suggestions for good Access books from others here. Personally, I've never owned one, I usually use the specific VBA help files that are supplied: and search on the internet when things aren't going right.
But you're probably going to need to know how VBA applies to Access: which means learning the object model, the properties, methods and events associated with each object.
There are basically two object models you need to know about:
Data Access Objects (DAO)
ActiveX Data Objects (ADO)
What you need to learn depends on which version of Access you have, and how you intend to use it. DAO is sufficient if you have A97. You may want to learn ADO if you have A2K or greater. You'll definately want to learn ADO if you intend to use Access on the internet (or other remote server).
Also, ADO learning is portable, you can use the same object model to access SQLServer or Oracle databases for example, so it's worth knowing anyway.
I'm sure that you'll get plenty of suggestions for good Access books from others here. Personally, I've never owned one, I usually use the specific VBA help files that are supplied: and search on the internet when things aren't going right.
