How Do I ... in 2007 Office System Programs

Discover a gateway to key task-based topics about programming and application development using the 2007 Microsoft Office System. The essential categories for what you can do with Office are listed here, and the links provide pointers to important, procedure-based Help topics.

2007 Office System | Access | Excel | InfoPath | InfoPath Form Services | Outlook | Project | Word

2007 Office System

• Office: How Do I…in the 2007 Office System
• Office: How do I...in the Microsoft Office Object Library
• Office: How to: Add and Manage Menu Bars and Menu Items
• Office: How to: Add and Modify Toolbars
• Office: How to: Configure Microsoft Error Reporting
• Office: How to: Customize the Ribbon UI by using a Managed COM Add-in
• Office: How to: Customize the Ribbon UI by using a Visual Basic COM Add-in
• Office: How to: Customize the Ribbon UI by using an Office Open XML Formats File
• Office: How to: Manipulate Office Open XML Formats Documents

Access 2007

• How Do I... in Access
• How to: Add (All) to a Combo Box or List Box
• How to: Add a Record to a DAO Recordset
• How to: Add a Value to a Bound Combo Box
• How to: Allow Users to Add Items to an Unbound Combo Box
• How to: Apply a Custom Ribbon to a Form or Report
• How to: Apply a Custom Ribbon When Starting Access
• How to: Apply a Filter When Opening a Form or Report
• How to: Assign a Control a Value From a Table
• How to: Bind a Form to an ADO Recordset
• How to: Build SQL Statements That Include Variables and Controls
• How to: Calculate Age
• How to: Calculate and Display Specific Date Values
• How to: Calculate Elapsed Time
• How to: Calculate Fields in Domain Aggregate Functions
• How to: Call Procedures in a Subform or Subreport
• How to: Cancel an Event
• How to: Cancel the Deletion of a Record by Using Custom Criteria
• How to: Change Tables Involved in a One-to-Many Relationship in a DAO Recordset
• How to: Change the Filter or Sort Order of a Form or Report
• How to: Close a Report Automatically If It Does Not Contain Any Records
• How to: Compact and Repair a Database
• How to: Count the Number of Records in a DAO Recordset
• How to: Create a DAO Recordset From a Form
• How to: Create a DAO Recordset From a Query
• How to: Create a DAO Recordset From a Table In the Current Database
• How to: Create a User-Defined Property
• How to: Create Alternating Row Colors on a Report
• How to: Create an ADO Connection String
• How to: Create and Delete Tables and Indexes Using Access SQL
• How to: Create Multiple Instances of a Form
• How to: Define Relationships Between Tables Using Access SQL
• How to: Delete a Record From a DAO Recordset
• How to: Detect the Limits of a DAO Recordset
• How to: Detect User Idle Time or Inactivity
• How to: Detect Whether an Object Is Open
• How to: Determine When a Shelled Process Ends
• How to: Determine Whether The Current Record is a New Record In a Form
• How to: Disable PAGE UP and PAGE DOWN Keys in a Form
• How to: Display a Custom Dialog Box When the User Deletes a Record
• How to: Display and Use the File Dialog Box
• How to: Export a Report to XML
• How to: Export Data, Schema, and Related Tables to XML
• How to: Extract Data from a Record in a DAO Recordset
• How to: Filter a Report Using a Form's Filter
• How to: Find a Record in a Dynaset-Type or Snapshot-Type DAO Recordset
• How to: Find a Record in a Table-Type DAO Recordset
• How to: Find the Current Position in a DAO Recordset
• How to: Find the Number of Working Days Between Two Dates
• How to: Format Dates as U.S. Dates Regardless of Regional Settings
• How to: Group Records in a Result Set Using Access SQL
• How to: Handle Run-Time Errors in VBA
• How to: Hide a Subform if the Main Form Contains No Records
• How to: Hide the Ribbon When Access Starts
• How to: Include Quotation Marks in String Expressions
• How to: Insert, Update, and Delete Records From a Table Using Access SQL
• How to: Make Bulk Changes to a DAO Recordset
• How to: Manipulate Multivalued Fields With DAO
• How to: Mark a Position in a DAO Recordset
• How to: Modify a Query from a DAO Recordset
• How to: Modify a Table's Design Using Access SQL
• How to: Modify an Existing Record in a DAO Recordset
• How to: Move Through a DAO Recordset
• How to: Perform Joins Using Access SQL
• How to: Perform Simple Data Validation Checks When Editing a Record in a Form
• How to: Prevent the Accidental Erasure of Data When Moving Between Controls on a Form
• How to: Programmatically Retrieve Printer Capabilities
• How to: Prompt a User Before Closing a Form
• How to: Prompt a User Before Saving a Record
• How to: Read From and Write To a Field in a DAO Recordset
• How to: Recover Tables Deleted from a Database
• How to: Refer to Tab Control Objects in VBA
• How to: Retrieve a List of Installed Printers
• How to: Retrieve Information from the Clipboard
• How to: Retrieve Records Using Access SQL
• How to: Retrieve the Name of the User Logged On To the Network
• How to: Return a Random Record from a DAO Recordset
• How to: Send Information to the Clipboard
• How to: Set Form, Report, and Control Properties in Code
• How to: Set Properties of ActiveX Data Objects in Visual Basic
• How to: Set Properties of Data Access Objects in Visual Basic
• How to: Sort Data in a DAO Recordset
• How to: Sort Records in Case-Sensitive ( ASCII) Order
• How to: Specify Date and Time in Criteria Expressions
• How to: Suspend Code Execution Until a Pop-up Form is Closed
• How to: Synchronize a DAO Recordset's Record with a Form's Current Record
• How to: Synchronize Two Combo Boxes on a Form
• How to: Track Design Changes to a Table-Type DAO Recordset
• How to: Use Aggregate Functions to Work with Values in Access SQL
• How to: Use Date and Time Criteria from a Control on a Form
• How to: Use Existing Custom Menus and Toolbars
• How to: Use Multiple Fields in Criteria Expressions
• How to: Use Numeric Criteria from a Control on a Form
• How to: Use Numeric Criteria in Expressions
• How to: Use Textual Criteria Expressions
• How to: Use Textual Criteria from a Control on a Form
• How to: Use the Status Bar Progress Meter
• How to: Use Transactions in a DAO Recordset
• How to: Use User Input to Build Filter Criteria
• How to: Work With Attachments In DAO
• How to: Work with Form and Report Printer Settings

Excel 2007

• How Do I... in Excel
• How to: Add Controls to a Document
• How to: Add Controls to a User Form
• How to: Create a Custom Dialog Box
• How to: Create a User Form
• How to: Create a Workbook
• How to: Refer to All the Cells on the Worksheet
• How to: Refer to Cells and Ranges by Using A1 Notation
• How to: Refer to Cells by Using a Range Object
• How to: Refer to Cells by Using Index Numbers
• How to: Refer to Cells by Using Shortcut Notation
• How to: Refer to Cells Relative to Other Cells
• How to: Refer to More Than One Sheet
• How to: Refer to Multiple Ranges
• How to: Refer to Named Ranges
• How to: Refer to Rows and Columns
• How to: Refer to Sheets by Index Number
• How to: Refer to Sheets by Name
• How to: Reference Cells and Ranges

InfoPath 2007

• How Do I...in InfoPath
• How To: Add Basic Workflow with InfoPath Roles and Rules
• How To: Add SharePoint Workflow Support to an InfoPath Form
• How To: Create a COM Add-in to Add Custom Features to InfoPath
• How To: Submit Data as an E-mail Message

InfoPath Form Services

• How Do I...in InfoPath Forms Services
• How to: Create and Use a Data Connection Library
• How to: Create, Test, and Debug Mobile Form Templates
• How to: Deploy Form Templates That Contain Form Code
• How to: Log and Reset InfoPath Forms Services Configuration Settings
• How to: Quiesce a Form Template Selected From a List
• How to: Use Query Parameters to Invoke Browser-Enabled InfoPath Forms
• How to: Verify a Batch of Form Templates
• How to: Verify a Form Template Before Deployment

Outlook 2007

• How Do I ... in Outlook
• How Can I Prevent the VBScript Code from Running?
• How Outlook Forms and Items Work Together
• How to Use the Outlook Object Browser in the Script Editor
• How to Use the Outlook Script Debugger
• How to: Accept User Input and Display the Values of Controls on a Form
• How to: Access a Page in a MultiPage Control
• How to: Access a Tab in a TabStrip Control
• How to: Access the Values of a Multi-valued Property in a Table
• How to: Add a Control to a Form
• How to: Add a Control to a MultiPage Control
• How to: Add a Control to a Page
• How to: Add a Custom Folder to a Group and Display it in Overlay Mode by Default
• How to: Add a Folder to the Favorite Folders Group
• How to: Add a New Navigation Group and Move a Folder into that Group
• How to: Add and Remove Items from a List Box
• How to: Add Items to a List in Design Mode
• How to: Add Items To a List or Combo Box at Run Time
• How to: Add or Remove a Menu Item on a Context Menu
• How to: Add or Remove an Add-in
• How to: Add or Remove Controls on a Form
• How to: Add Scroll Bars to a Page and a Frame
• How to: Add, Cut, and Paste a Control on a Page
• How to: Adjust Spacing for Controls
• How to: Align a Picture on a Control
• How to: Align Controls
• How to: Align Text in a Control
• How to: Align the Caption of an Option Button with the Control
• How to: Allow a Command Button to Take Focus Upon Clicking
• How to: Allow Multiple Lines of Text in a Control
• How to: Allow Multiple Lines, Word Wrapping, and Scrolling in a Text Box
• How to: Allow Multiple Selections in a List Box
• How to: Allow the Null State for a Check Box and a Toggle Button
• How to: Assign a Control Tip, Caption, and Accelerator Key to a Control
• How to: Assign a Control Tip, Caption, and Accelerator Key to a Page or Tab
• How to: Assign a Picture to a Control
• How to: Assign a Picture to a Form
• How to: Automatically Insert Prefix Text into the Subject Field of a Reply Form
• How to: Automatically Size a Text Box with User Input
• How to: Center Controls in a Form
• How to: Change the Accelerator and Caption of a Command Button
• How to: Change the Appearance of a Control
• How to: Change the Column Widths of a Multi-Column List Box
• How to: Change the Default Form for a Folder
• How to: Change the Icons Associated with your Form
• How to: Change the Name of a Control
• How to: Change the Name Property of a Control
• How to: Change the Order of Pages and Tabs
• How to: Change the Style, Size, and Effects of a Font
• How to: Change the Value of a Field
• How to: Control Character Matching in a Combo Box and List Box
• How to: Control the Drop Button Style and When to Show the Drop Button
• How to: Control the Extent of Scrolling in a Scroll Bar
• How to: Control the Focus When the User Cycles through Controls in a Frame or MultiPage Control on a Form
• How to: Control the Selection Behavior and Drag Behavior When Entering a Text Box
• How to: Control the Style and Selection Behavior of a List Box
• How to: Control the Text Box Behavior on Clicking Enter
• How to: Create a Combination Field for a Folder
• How to: Create a Custom Action for a Form Region
• How to: Create a Form Region
• How to: Create a Formula Field for a Folder
• How to: Create a Group of Controls
• How to: Create a Rule to Move Specific E-mails to a Folder
• How to: Create a Set of OptionButton Controls
• How to: Create a Set of OptionButtons by Using the GroupName Property
• How to: Create a Simple Field for a Folder
• How to: Create a Validation Formula and Message
• How to: Create an Outlook Form
• How to: Create Custom Actions for a Form
• How to: Create Separate Read and Compose Pages Using Form Regions in a Custom Form
• How to: Customize a Context Menu to Support Moving Items between Calendars
• How to: Customize an Item Context Menu
• How to: Customize Pages on a Form
• How to: Cut Text from One Text Box and Paste it on Another
• How to: Delete a Picture from a Control
• How to: Delete Data to Reset Solution Storage
• How to: Disable a Standard Reply Form
• How to: Display a Dialog Box for Selecting Entries from the Contacts Folder
• How to: Display Address Entry Details for the Sender of a Message
• How to: Display Specific Modules in the Navigation Pane
• How to: Display the List Portion of a Combo Box
• How to: Display the Name of Each Control on a Form or a Page of a MultiPage Control
• How to: Display the Name of Each Control on a Page
• How to: Display the Number of Pages and Tabs in MultiPage and TabStrip Controls on a Form
• How to: Enable and Lock a Text Box from User Entry
• How to: Enable or Disable a Control on a Page
• How to: Enhance the Border Style, Color, and Special Effects of a Text Box Control
• How to: Enumerate Active Folders in the Calendar View
• How to: Enumerate Folders on All Stores
• How to: Enumerate Search Folders on All Stores
• How to: Enumerate the Contacts Folder and Set Custom Property for only Contact Items
• How to: Enumerate, Show, Hide, and Position Modules in the Navigation Pane
• How to: Export a Calendar using Payload Sharing
• How to: Extend the Use of an Outlook Item by Adding Fields and Pages
• How to: Filter Items that Do Not Have Categories
• How to: Filter the Body of a Mail Item
• How to: Give a Control a 3-D Appearance
• How to: Give a Control a 3-D Appearance
• How to: Group Option Buttons
• How to: Hide or Disable a Menu Item on a Context Menu
• How to: Hide or Show a Control
• How to: Hide or Show a Control
• How to: Hide or Show Form Pages
• How to: Import Saved Items using OpenSharedItem
• How to: Include the Original Body in an Item Resulting from an Action
• How to: List the Groups that My Manager Belongs to
• How to: List the Name and Office Location of Each Manager Belonging to an Exchange Distribution List
• How to: Make a Control Read-only
• How to: Make a Control Transparent
• How to: Make Separate Compose and Read Versions for a Form
• How to: Manage Your Forms in Forms Manager
• How to: Match Entries in a List to Entries Typed by Users
• How to: Modify a Built-in Action for a Form Region
• How to: Move a Control One Unit at a Time
• How to: Move a Text Box in Front of or Behind Another Control
• How to: Move Controls on a Page
• How to: Name a Form Region
• How to: Obtain a Folder Object from a Folder Path
• How to: Open a Form
• How to: Open a Task, Calendar Item, or Note from a Custom Form
• How to: Place an Image and a Caption on a Command Button
• How to: Pre-address a Reply Form to a Public Folder or an E-mail Address
• How to: Prevent a Replacement Form Region from Being Used to Create a New Item or from Being Modified in the Forms Designer
• How to: Prevent the Inspector from Displaying a Form Region When You are Composing a Message
• How to: Prevent the Inspector from Displaying a Form Region When You are Reading a Message
• How to: Prevent the Reading Pane from Displaying a Form Region When You are Previewing a Message
• How to: Programatically Change the Display Format for All Contacts
• How to: Publish a Form
• How to: Reference a Custom Property that Has the Same Name as a Built-in Property of the Control
• How to: Reference the Parent Object of a Control
• How to: Require a Value for a Field or Control
• How to: Resize a Control Horizontally and Vertically with the Form
• How to: Right-Align a Control on a Form
• How to: Save a Form as a File
• How to: Save a Form in a Forms Library
• How to: Save a Form with the Item (One-off Forms)
• How to: Save and Distribute a Form
• How to: Save Auto-Archive Properties of a Folder in Solution Storage
• How to: Search the Inbox for Items with Subject Containing "Office"
• How to: Select and Edit a Control Within a Group
• How to: Select Multiple Controls and the Dominant Control
• How to: Send a Sharing Invitation for a Calendar
• How to: Send a Sharing Invitation for an RSS Feed
• How to: Separate Controls in a Group
• How to: Set a Module as the Currently Selected Module in the Navigation Pane
• How to: Set Entry Matching in a Combo Box
• How to: Set Properties for a Form
• How to: Set Properties for Controls
• How to: Set Tab Order of Controls on a Page
• How to: Set the Background Color of a Form
• How to: Set the Grid Size
• How to: Set the Height and Width of Tabs in a MultiPage and a TabStrip Control
• How to: Set the Input Style for a Combo Box
• How to: Set the Item at the Top of a List and the Item that Has Focus in the List
• How to: Set the Maximum and Minimum Values for a Scroll Bar
• How to: Set the Number of Lines and the Length of Input in a Text Box
• How to: Set the Style of Tabs for a MultiPage and a TabStrip Control
• How to: Set the Tab Order of Controls in a Frame
• How to: Set the Type of Mouse Pointer for a List Box
• How to: Set the Width of the Drop-Down List of a Combo Box
• How to: Share Contact Information Including the Business Card
• How to: Show or Hide Fields when Printing and Saving a Form
• How to: Show or Hide the Grid
• How to: Show or Hide the Navigation Pane
• How to: Show the Shortcut Menu for Controls and Groups of Controls
• How to: Simulate a Two-Dimensional Array with List Boxes
• How to: Size Controls
• How to: Specify a Form Region to be Used Only for the Exact Message Class
• How to: Specify a Layout File for a Form Region
• How to: Specify a Subject Prefix of an Item Resulting from an Action
• How to: Specify Additional Information for a Control
• How to: Specify Control Tip Text for Controls
• How to: Specify Icons to be Displayed for a Form Region
• How to: Specify Locale-Specific User Interface for a Form Region
• How to: Specify Possible Values for a List Box
• How to: Specify Tab Support for a Control
• How to: Specify the Column in a Multi-Column List Box to Display to the User
• How to: Specify the Column in a Multi-Column List Box to Store Data for the Control
• How to: Specify the Location of a Form Region in a Custom Form
• How to: Specify the Message Class and Form for an Item Resulting from an Action
• How to: Specify the Number of Rows in a Combo Box
• How to: Specify the Way Outlook Responds When Executing an Action
• How to: Specify Whether a Form Prompts the User, Opens, or is Sent
• How to: Store Data in a StorageItem for a Solution
• How to: Swap Columns of a Multicolumn List Box
• How to: Test a Form in Run Time
• How to: Turn On or Off Sizing Controls to the Grid
• How to: Undo and Redo an Action in a Text Box or a Combo Box
• How to: Use a Custom Color for the Background or Foreground of a Control
• How to: Use a System Color for a Background or Foreground
• How to: Use an Add-in to Specify Icons for a Form Region
• How to: Use Standard Reply and Forward Headers on a Form
• How to: Use the Controls Collection to Move Controls on a Page
• How to: Use the Table Object to Performantly Enumerate Filtered Items in a Folder

Project 2007

• How to: Calculate Resource Availability in OLAP Cubes
• How to: Create a Project Workspace and Link it to a Project
• How to: Create an Enterprise Custom Field
• How to: Create and Use a Transaction Set for Multiple Undo/Redo Actions
• How to: Log on to Project Server Programmatically
• How to: Use a Filter Parameter with PSI Methods
• How to: Use the OLP to Link an Object to a Task
• How to: Use the QueueSystem Web Service
• How to: Write a Simple Impersonation Application

Word 2007

• How Do I... in Word
• How to: Bind a Content Control to a Node in the Data Store
• How to: Bind Controls to a Specific Row in the Data Store When Inserting a Building Block
• How to: Capture and Respond to Events in the Data Store
• How to: Change a Content Control from One Type to Another
• How to: Change the Editability of a Content Control
• How to: Create a Custom Building Block Gallery
• How to: Filter the Building Block List in a Content Control
• How to: Insert a Content Control into a Building Block