Microsoft Access VBA Macro Programming

^ Operator The^operator raises a number to the power of an exponent. MsgBox 2 ^ 3 The answer is 8 (2 to the power of 3). The ope ...

Concatenation Operator The concatenation operator (&) concatenates two operands together. MsgBox "Richard " & "Shepherd" ...

Each column of this table shows a binary bit based on an eight-bit number. The bit values are shown in bold across the top. The ...

The following returns False because there is no True value: MsgBox False Or False It works using binary arithmetic, on the basis ...

Xor Operator Xoris very similar toOr, except that True and True make False. Only True and False make True, but there must be one ...

The following will return the value 84: MsgBox 145 Xor 197 This operator is often used in simple encryption routines. You use a ...

You can also use wildcard characters. A?denotes a single character and a*denotes a string of characters. It is exactly the same ...

Chapter 7 Debugging Chapter 7 Debugging I n any code you write, bugs may exist that can cause a program failure, cause the progr ...

now,” and then rerun the procedure, and up comes another one! This can be very frustrating, but the best answer to fixing it is ...

in scope (meaning it is used within the procedure you are running), and it will give you the value of it instantly. You can also ...

You can restart your code by clicking the Run symbol on the toolbar (the triangle symbol pointing to the right) or pressingF5; i ...

You can insert a breakpoint where you want to start checking the code and then single-step the procedure to see what each statem ...

The earliest active procedure call is shown at the top of the list, and any subsequent procedure calls are added to the top, as ...

You can set the Debug window, as shown in Figure 7-3, by using Debug | Add Watch from the menu. Enter the variable or expression ...

Events That Can Cause Problems When Debugging Certain events in windows can pose problems for the debugger by complicating and c ...

Got Focus / Lost Focus A got focus / lost focus event occurs when a user clicks your form or a particular control on the form to ...

You can change the caption properties on aUserFormobject using code. This assumes you have already definedUserForm1and that it i ...

Chapter 8 Errors and the Error Function Chapter 8 Errors and the Error Function R untime errors can creep into code very easily, ...

Try this simple examplewithouta disk in drive D. Place the code into a code module and then run it by pressingF5: Sub Test_Error ...

If Err.Number = 71 Then MsgBox "The D drive is not ready" Else MsgBox "An error occurred" End If End Sub You saw from the first ...