When Not to Use VBA

There are times when you will attempt to solve a problem with VBA, only to find out that VBA is not the answer. The following example is such a case. Over time, you will learn to identify what can be solved with code, with a query or multiple queries, and also via the use of controls on a report.

When developing a report, there are things that you can do that don't require programming. Instead, with a properly placed control, or with the use of a grouping section, the desired functionality can be achieved. In this example, an index letter can be added to the start of each Alphabetical value in the report. This can be helpful for easy recognition of data by the user. Figure 11-11 demonstrates the desired effect.

0 0

Post a comment