Chapter 8. Writing Your Own Visual Basic for Applications Code
So far, you have examined code, but you haven’t written any code of your own. This chapter gives you a chance to write your own code. You start with simple procedures and progress to procedures that are a bit more complex and powerful. You also learn how to test your procedures. After you understand what combining function power with query power can do for you, don’t be surprised if you suddenly acquire the motivation to start writing creative procedures of your own.
In this chapter, you learn
how to use Access built-in string functions
how to use the immediate window to test functions
how to create your own functions
how to use arrays with functions
how to combine functions with queries ...
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.
