Access Cookbook - Ken Getz [375]
11.12. Retrieve Information About Available Drives
11.12.1. Problem
11.12.2. Solution
11.12.3. Discussion
11.13. Collect and Display Information on the System and the Access Installation
11.13.1. Problem
11.13.2. Solution
11.13.3. Discussion
11.14. Create and Cancel Network Connections Programmatically
11.14.1. Problem
11.14.2. Solution
11.14.3. Discussion
11.14.3.1. Retrieving information
11.14.3.2. Adding and canceling connections using common dialogs
11.14.3.3. Adding and canceling connections with no user intervention
12. Automation
12.1. Play an Embedded Sound File from Within an Application
12.1.1. Problem
12.1.2. Solution
12.1.3. Discussion
12.1.4. See Also
12.2. Print an Access Report from Excel
12.2.1. Problem
12.2.2. Solution
12.2.3. Discussion
12.3. Use Excel's Functions from Within Access
12.3.1. Problem
12.3.2. Solution
12.3.3. Discussion
12.3.3.1. Setting up communication with Excel
12.3.3.2. Calling simple Excel functions
12.3.3.3. Calling Excel functions using ranges
12.3.3.4. Calling Excel functions using arrays
12.3.3.5. Closing Excel
12.3.4. Comments
12.3.5. See Also
12.4. Perform a Mail Merge from Access to Word
12.4.1. Problem
12.4.2. Solution
12.4.3. Discussion
12.4.3.1. Starting the connection with Word for Windows
12.4.3.2. Performing the mail merge
12.4.3.3. Finishing the mail merge
12.5. Add an Item to the Startup Group
12.5.1. Problem
12.5.2. Solution
12.5.2.1. Using the sample forms
12.5.2.2. Using DDE with the Windows shell
12.5.3. Discussion
12.5.3.1. Retrieving information from the Windows shell
12.5.3.2. Executing tasks
12.5.3.3. Using the wrapper procedures
12.5.4. Comments
12.6. Send Access Data to Excel and Create an Excel Chart
12.6.1. Problem
12.6.2. Solution
12.6.3. Discussion
12.7. Create a PowerPoint Presentation from Access Data
12.7.1. Problem
12.7.2. Solution
12.7.3. Discussion
12.7.3.1. Starting and stopping PowerPoint
12.7.3.2. Creating the presentation
12.7.3.3. Creating each slide
12.7.3.4. Creating the text
12.7.4. Comments
12.8. Add a Contact and Send Email Through Outlook
12.8.1. Problem
12.8.2. Solution
12.8.3. Discussion
12.8.4. See Also
13. Data Access Pages
13.1. Replace Navigation Button Images with Your Own Images
13.1.1. Problem
13.1.2. Solution
13.1.3. Discussion
13.2. Use Labels or Other Controls for Record Navigation
13.2.1. Problem
13.2.2. Solution
13.3. Change the Text Displayed with a Navigation Control
13.3.1. Problem
13.3.2. Solution
13.4. Create a DAP that Allows You to Update Data
13.4.1. Problem
13.4.2. Solution
13.5. Create One File to Store Connection Information for All DAPs in an Application
13.5.1. Problem
13.5.2. Solution
13.6. Programmatically Change the Connection String for All Pages in a Database
13.6.1. Problem
13.6.2. Solution
13.6.3. Discussion
13.7. Change the Default Settings for New DAPs
13.7.1. Problem
13.7.2. Solution
13.7.3. Discussion
13.8. Use Parameters Set in One DAP to Open Another
13.8.1. Problem
13.8.2. Solution
13.8.3. Discussion
14. SQL Server
14.1. Dynamically Link SQL Server Tables at Runtime
14.1.1. Problem
14.1.2. Solution
14.1.3. Discussion
14.2. Dynamically Connect to SQL Server from an ADP
14.2.1. Problem
14.2.2. Solution
14.2.3. Discussion
14.3. Share an ADP from a Shared Network Folder
14.3.1. Problem
14.3.2. Solution
14.3.3. Discussion
14.4. Fill the Drop-Down Lists When Using ServerFilterByForm in an ADP
14.4.1. Problem
14.4.2. Solution
14.4.3. Discussion
14.5. Pass Parameters to Stored Procedures from Pass-Through Queries in an MDB
14.5.1.