Microsoft Access VBA Macro Programming

TheByValkeyword ensures that parameters are passed by value rather than by a reference to a value from a variable. Passing a val ...

Chapter 4 Programming Basics: Decisions and Looping. Chapter 4 Programming Basics: Decisions and Looping. W hen writing programs ...

Decisions Programs, unless they are extremely simple, usually have to makedecisionsaccording to data retrieved or input from the ...

The End..If statement shows where the conditional statements finish, or you can put the entire If statement onto one line, which ...

Conditional operators that can be used are as follows: Operator Meaning = Both numbers or values are equal. This condition will ...

You can put in severalAnds orOrs within the condition, although it gets complicated with more than three. It all depends on what ...

Case Is > 8 MsgBox "Grade is above 8" Case Else Msgbox "Grade not in conditional statements" End Select End Sub Looping Witho ...

Stepoption.Stepallows you to specify the size of the increment and also the direction by using the following code: For n = 3 to ...

The following example iterates through all the query names in the current database using a For Each loop: Sub ShowName() Dim oQr ...

Again, a variable,x, is set to 0. The condition thatxmust be less than 50 is supplied, and xis incremented by 1 each time the lo ...

This page intentionally left blank ...

Chapter 5 Strings, Functions, and Message Boxes Chapter 5 Strings, Functions, and Message Boxes T his chapter covers how to hand ...

Concatenation Concatenation is how you join strings together, generally using the & sign. It is extremely useful when you wa ...

This code will start at the third character and continue to the end of the string and place the result in the variablex, which w ...

The variablexwill have the value richard. In both of these examples, any nonletter characters such as numbers will be left as th ...

This will give the answer 0 because the string "shepherd" is not found due to the difference in case. The following will give th ...

The following will also give the value of 1 despite being so close to 2: MsgBox Int(1.99) Sqr Sqrreturns the square root of a nu ...

Because this deals with the entire character set, it also includes nonprintable characters. For example, ASCII code 13 is a carr ...

CDbl CDblconverts a value or a string to a double-precision floating point number (eight bytes) where decimal places are allowed ...

You can also use the predefined format names as the format string, as shown in Table 5-2. This example uses the format "Currency ...