Microsoft Access VBA Macro Programming

almost like a spreadsheet. A spreadsheet has many cells that can hold information, and an array can be set up to have many cells ...

the declarations section of the code module. If you look at a module within the VB Editor window, you will see a heading called ...

procedure is executing. Local variables declared withStaticremain in existence for the lifetime of the application. You may well ...

Global Variables Globalvariables are declared in the declarations part of a module with theGlobalstatement, but they can be acce ...

Data Types A variable can be given a data type that determines the type of data it can store. This can have an effect on the eff ...

You can use theIsNumericfunction to test if the value of a variant is a number—it returns true or false (nonzero or zero). Sub T ...

NOTE Null is not 0. This is an easy but incorrect assumption to make when you’re starting to learn VBA. The safest way to check ...

String Types If your variable will always contain text, you can declare it to be of typeString: Dim temp as String You can then ...

always a fixed length to each element, there is a risk of data loss if a user manages to input a longer string than you original ...

Arrays follow the same rules as ordinary variables. They can be local, module, or global and can be any data type, including Var ...

Dynamic Arrays Sometimes you do not know how large an array needs to be. A good example is if you are recursively storing pathna ...

Years as Integer End Type This creates a new type calledEmployee, which holds information for Name, Salary, and Years of Service ...

Reserved Words You probably noticed that there are a number of keywords within VBA that make up the language—for example,For,Nex ...

Chapter 3 Modules, Functions, and Subroutines Chapter 3 Modules, Functions, and Subroutines M odules are containers where you wr ...

 Call your code from another VBA procedure. Code can form subroutines or functions that can then be used within other macros wr ...

Afunctionis exactly like a subroutine except that it returns a value. Functions start with Function(instead ofSub) and end withE ...

TheCallcommand calls your subroutine and passes any required parameters to it. It then executes the code in the subroutine and r ...

The name of the function isMultiply, and this is used as a variable to return the answer. This is the only way to return the ans ...

Return to the initial Hello World example in Chapter 1. Turn the “Hello World” statement into a comment by putting a single quot ...

Argument Data Types When you specify arguments for a procedure, they always default to Variant, which is the default variable ty ...