Chapter 10. Using Procedures to Customize Your Database

In the last chapter, you not only learned about macros and modules, but about how to send messages to users. This chapter will take you deeper into programming by teaching you how to use various flow control statements that are part of VBA.

You have already been introduced to the power of functions. This chapter gives you a chance to get your feet wet with some hands-on examples using functions. The examples near the end of the chapter use many Access intrinsic functions. Specifically, you learn

  • how to use Access’s built-in string functions

  • the differences between function procedures and sub procedures

  • what is scope and how to use it

  • how to create procedures

  • how to use programming loops

  • how ...

Get Access 2002 Programming by Example 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.