Business solutions Automating Microsoft

5. Choosing the Right VBA Function

IN THIS CHAPTER

Introducing VBA’s Built-in Functions

Converting Data Types with VBA Functions

Working with Date Functions

Using Mathematical and Financial Functions

Using String Functions

Using the Format Function

Using the Is Functions for Flawless Processing

Interacting Functions

Introducing VBA’s Built-in Functions

VBA is considered a high-level language, which means it can take a while to master. On the other hand, the combination of Access and VBA is flexible enough that you can start using VBA to automate your Access applications right out of the box, with just a little reading and preparation.

There are a number of functions that perform dozens and dozens of tasks and calculations for you. While ...