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

8. Programming > 8.1. Hacks 72–91

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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