O'Reilly logo

Microsoft® Access VBA Programming for the Absolute Beginner by Michael Vine

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

CHAPTER 7CODE REUSE AND DATA STRUCTURES

In this chapter I show you how to increase your programming productivity by building your own procedures for reuse throughout an Access program. I also show you how to build collections of related information using data structures such as arrays and user-defined types.

CODE REUSE

Remember that Visual Basic and VBA are event-driven programming languages. This means VBA programmers could easily duplicate work when writing code in two or more event procedures. For example, consider a bookstore program that contains three separate graphical interfaces (forms or windows) a user could use to search for a book by entering a book title and clicking a command button. As a VBA programmer, you could easily write the ...

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