16. Automating Tasks with Visual Basic
Macros are plenty of fun, but they can only do so much. If you can't find a readymade macro action that does the job you want, you can't use a macro. No such limit applies in the world of Visual Basic code, where you can do just about anything (if you spend enough late-night hours at the computer keyboard).
Here are some examples of tasks you can accomplish with code, but not with macros:
The goal of this chapter (and the next) isn't to make you a full-time code jockey. If that's your ambition , you can continue on to read entire books about programming Access. Instead, this chapter aims to teach you just enough to get the lowhanging fruit of Access programming. In other words, you'll pick up enough VB smarts to use the popular and practical code tricks discussed in the next chapter. You'll also build a great foundation for future exploration.
Note: The version of Visual Basic that Access and other Office applications use is called VBA , which stands for Visual Basic for Applications