O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

ADDING MORE POWER WITH VBA

To get even more power from queries, use them from VBA where you can use control-of-flow statements such as If..Endif and Select Case..End Select to build SQL statements and pass parameters to queries. You can give your users more versatile user interfaces for selecting and viewing their data.

Building Faster Queries in VBA

With VBA, you no longer need a parameter query for the criteria to be specified by users. Consider a report that requires two or three optional parameters. If the parameters involve multiple tables, the query might be joining in tables that are needed only some of the time. To make the query run faster, build only the portion of the select statement that's required.

Suppose that users can choose ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required