Free E-Books

The variables you use have a dramatic effect on your applications. You have a
lot options when it comes to establishing and using variables in your Access
programs. Inappropriately using a variable can slow an application??™s execution
or potentially cause data loss.
385
IN THIS CHAPTER
Using variables
Understanding the VBA data
types
Understanding subs and
functions
Creating VBA procedures
Creating functions
Calling procedures and functions
Passing parameters to
procedures and functions
Handling values returned from a
function
Mastering VBA Data Types
and Procedures
This chapter contains everything you need to know about creating and using VBA variables. The
information in this chapter helps you use the most efficient and effective data types in your variables
while avoiding the most common problems related to VBA variables.
In addition to variables, we??™ll take a look at a few more code editor options, working with VBA
procedures, and passing parameters to procedures.


Pages:
828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852