Writing Your Own Functions and Procedures
You do not need to be an Access VBA expert to write a user-defined function. The information you learned about operators and expressions in Chapter 9, "Understanding Operators and Expressions in Access," as well as the introduction to Access VBA statements presented in this chapter, allow you to create UDFs that supplement Access VBA's repertoire of standard functions.
After you master user-defined functions, you can try your hand at writing procedures to be executed as the result of an event. Access VBA procedures offer flexibility in manipulating database and control objects but require more knowledge of programming techniques than is needed to create UDFs. This section describes how you write a simple ...
Get Special Edition Using Access 97, Second Edition 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.
