O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required