Microsoft Access VBA Macro Programming

54 Microsoft Access 2010 VBA Macro Programming Character Description Null String No formatting. 0 Digit placeholder. Displays a ...

You can use a number of characters to create user-defined date and time formats, as listed in Table 5-5. The following is an exa ...

A number of characters can be used to create a user-defined format Date formats, like number formats, can use sections. One sect ...

Date Datereturns the current date in short format as defined in the Windows Control Panel: MsgBox Date Time TheTimefunction retu ...

The following will add two weeks and return 15-Jan-03 (depending on your date format): MsgBox DateAdd ("ww",2,"1-Jan-03") The fo ...

Intervalis the time period based on the following table, and date is the date you want to inspect. Time Period Interval Year yyy ...

DateValue This function converts a date into a value. For example, the following will return the value 37686, which is the date ...

Month Monthreturns an integer between 1 and 12, based on the date expression: Month (dateexpression) An example of adateexpressi ...

Weekday TheWeekdayfunction returns an integer between 1 (Sunday) and 7 (Saturday) that represents the day of the week for a date ...

All the applications in the Microsoft Office Suite support OLE automation in that you can load in a reference to a particular ob ...

The other command to use before you send keys isAppActivate. If the application is already loaded, you do not need to use theShe ...

Chapter 5: Strings, Functions, and Message Boxes 65 Key Code BACKSPACE {BACKSPACE}, {BS}, or {BKSP} BREAK {BREAK} CAPS LOCK {CAP ...

To specify that any combination ofSHIFT,CTRL, andALTshould be held down while several other keys are pressed, enclose the code f ...

to thetypeparameter, you get a nice list box showing all your options. Four icons can be used, depending on circumstances, as sh ...

Following is an example of the message box with Yes and No buttons and a defined caption: MsgBox "Test message", vbYesNo, "My me ...

This example will show a two-button message box (Yes and No). If Yes is clicked, the following message box will show 6 (vbYes). ...

This page intentionally left blank ...

Chapter 6 Operators Chapter 6 Operators O perators perform mathematical functions, comparison functions, or logical operations b ...

This gives the answer 5.3333. MsgBox 10 + 6 / 3 This gives the answer 12. In the first example, the parentheses force10 + 6to be ...

A Type Mismatch error occurs if one operand is numeric and the other is a string, as shown here: MsgBox 1 + " Richard" Note this ...