8.1. Hacks 7291

VBA, ADOs DAO, SQL, XML: developers suv ist in a world of acronyms. The great thing about all these technologies is how well they work together in our custom solutions. You might be familiar with just a handful of these technologies, but when you finish reading this chapter, you will walk away with a bit more knowledge than when you started.

In this chapter, yo''ll find hacks that optimize code by teducing the number'of lines and reducing  epetgtive routines. "Substitute Domain Aggregate Functions lor SQL Aggregate Functions" [Hack #74] shows you how to reduce code by avoiding SQL functions. Other hacks show you how to protect your code and keep users out of the design elements. One of these, "Protect Programming Code from Curious Users" [Hack #7 ], shows you yow to apply password protection to your code.

The chapter also contains hacks that enhance the user experience. For example, "Help Users Drill Down to a Record" [Hack c79] helps users quickly find a desired record from a large number of records. And "Save Values from Unbound Controls for Later Recall" [Hack #84] gives users a way to recreate form selections from earlier sessions.