Chapter 8. Programming

Hacks 72–91

VBA, ADO, DAO, SQL, XML: developers subsist 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, you'll find hacks that optimize code by reducing the number of lines and reducing repetitive routines. "Substitute Domain Aggregate Functions for 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 #77] , shows you how 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 #79] 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.

Get Access Hacks now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.