Which VBA should I learn? [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 11 years ago.

I have to write a database in Access 2010 a开发者_如何转开发nd i need to use VBA also (I have never used it). A thought that the times came to learn a little about VBA and VB. I would like to read through a VB tutorial also just to know a little bit about that too. But i found a lot of VB for example 6.0, 2005, 2008, 2010. My question is: If I want to learn VBA in Access 2010 which VBA version should I study (link would be good), and which version of VB?

---

VBA and VB are not the same, particularly VB in the context of the .NET framework. If you want to be able to program within Access, then you need VBA, not VB. Get a book which covers Access VBA - if you don't like Banjoe's suggestion, there are plenty with fewer pages, and tons of material accessible via Google.

---

I've always found the WROX books to be fairly comprehensive and full of useful, real-world examples. For example: Access-2007-Programmers-Reference

In the beginning try to stick with bound forms/reports as much as possible. You can do a lot without VBA and once you start custom coding things it tends to snowball.

If you're new to database design make sure you read up on how to properly normalize your data. Designing your database properly will save you tons of time in the long run. See: here for one example.

---

I would suggest you are asking the wrong question. Access is a point-and-click development tool, not a programming language. So, what you need to learn is how to use Access to create applications. That means creating user interface objects interactively and then extending them with code.

However, one thing to keep in in mind is that A2010 has new powerful macros with branching and logic and error handling. These are quite robust because all the features of the new Access Web Databases (usable with Sharepoint using Access Services, and runnable in a web browser) are built on top of these macros.

So, I would suggest that you invest time in learning how to create web objects in addition to learning how to sprinkle in some VBA code to extend the behavior of your Access UI objects (and the VBA code won't run in a Web database, BTW).