• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. USING QUERIES TO GET THE MOST... > ADDING MORE POWER WITH VBA

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint