Microsoft Access 2010 Bible

Part II: Programming Microsoft Access

416

FIGURE 10.24

Chapter10.accdb includes frmCommandLine to demonstrate using command-line arguments in your
applications.

Summary

This chapter reviewed some of the important topics as you work with Access VBA. I showed you

the fundamental concepts of creating VBA modules and procedures and touched on the important

topic of event-driven programming in Microsoft Access.

You also read that Access provides a large number of options and settings that influence how you

work with your modules and procedures. The good news is that you have a lot of options control-

ling the appearance and behavior of the Access code editor. There is no bad news about writing

code in Microsoft Access!

The With...End, With, and For Each constructs make it easy and efficient to traverse the

members of object collections. Named arguments give you a lot more flexibility in passing parame-

ters to functions and subroutines.

You continue your exploration of the VBA programming language in the next several chapters. In

Chapters 11 through 15 you learn virtually every fundamental skill necessary to succeed as a VBA

programmer. One important aspect of VBA programming is that it’s a skill with no barriers — your

abilities as an Access VBA programmer are completely transferable to any of the other Microsoft

Office products like Word and Excel.