Access Cookbook. Solutions to Common User Interface & Programming Problems. 2nd Edition (ebook)(audiobook)(audiobook)

Spis treści

• Access Cookbook, 2nd Edition
  • SPECIAL OFFER: Upgrade this ebook with OReilly
  • A Note Regarding Supplemental Files
  • Preface
    • What This Book Is About
      • Promotes Creative Use of the Product
      • Uses the Tools at Hand
      • Follows a Problem-Solution Format
    • Who This Book Is For
    • What You Need to Use This Book
    • How This Book Is Organized
    • What We Left Out
      • How Do I Set Control Properties?
      • How Do I Create a New Module?
      • How Do I Import an Object?
      • How Do I Create an Event Macro?
      • How Do I Create an Event Procedure?
      • How Do I Place Code in a Form or Reports Module?
      • How Do I Know What to Do with Code Examples?
      • How Do I Use Data Access Objects (DAO) in New Databases?
    • Conventions Used in This Book
    • Comments and Questions
    • Acknowledgments
  • 1. Queries
    • 1.1. Specify Query Criteria at Runtime
      • 1.1.1. Problem
      • 1.1.2. Solution
      • 1.1.3. Discussion
    • 1.2. Using a Form-Based Parameter Query
      • 1.2.1. Problem
      • 1.2.2. Solution
      • 1.2.3. Discussion
    • 1.3. Limit the Items in One Combo Box Based on the Selected Item in Another
      • 1.3.1. Problem
      • 1.3.2. Solution
      • 1.3.3. Discussion
      • 1.3.4. See Also
    • 1.4. Make Formatted Date Columns Sort Correctly in a Crosstab Query
      • 1.4.1. Problem
      • 1.4.2. Solution
      • 1.4.3. Discussion
    • 1.5. Group Mailing Labels by Address
      • 1.5.1. Problem
      • 1.5.2. Solution
      • 1.5.3. Discussion
      • 1.5.4. See Also
    • 1.6. Use a Field in One Table to Update a Field in Another Table
      • 1.6.1. Problem
      • 1.6.2. Solution
      • 1.6.3. Discussion
    • 1.7. Use a VBA Variable to Filter a Query
      • 1.7.1. Problem
      • 1.7.2. Solution
      • 1.7.3. Discussion
      • 1.7.4. See Also
    • 1.8. Use a Query to Retrieve a Random Set of Rows
      • 1.8.1. Problem
      • 1.8.2. Solution
      • 1.8.3. Discussion
    • 1.9. Create a Query That Will Show Aging of Receivables
      • 1.9.1. Problem
      • 1.9.2. Solution
      • 1.9.3. Discussion
      • 1.9.4. See Also
    • 1.10. Create a Join That's Based on a Comparison Other than Equality
      • 1.10.1. Problem
      • 1.10.2. Solution
      • 1.10.3. Discussion
    • 1.11. Create a Query to Combine Data from Two Tables with Similar Structures
      • 1.11.1. Problem
      • 1.11.2. Solution
      • 1.11.3. Discussion
    • 1.12. Create a Combo Box That Allows a User to Select N/A
      • 1.12.1. Problem
      • 1.12.2. Solution
      • 1.12.3. Discussion
      • 1.12.4. See Also
    • 1.13. Use a Query to Show the Relationship Between Employees and Supervisors
      • 1.13.1. Problem
      • 1.13.2. Solution
      • 1.13.3. Discussion
    • 1.14. Create a Query That Uses Case-Sensitive Criteria
      • 1.14.1. Problem
      • 1.14.2. Solution
      • 1.14.3. Discussion
    • 1.15. Use a Query to Create a New Table Complete with Indexes
      • 1.15.1. Problem
      • 1.15.2. Solution
      • 1.15.3. Discussion
    • 1.16. Save My Queries in a Table for Better Programmatic Access and Security
      • 1.16.1. Problem
      • 1.16.2. Solution
      • 1.16.3. Discussion
    • 1.17. Create a Recordset Based on a Parameter Query from VBA Code
      • 1.17.1. Problem
      • 1.17.2. Solution
      • 1.17.3. Discussion
  • 2. Forms
    • 2.1. Make Custom Templates for Forms and Reports
      • 2.1.1. Problem
      • 2.1.2. Solution
      • 2.1.3. Discussion
      • 2.1.4. See Also
    • 2.2. Highlight the Current Field in Data-Entry Forms
      • 2.2.1. Problem
      • 2.2.2. Solution
      • 2.2.3. Discussion
      • 2.2.4. See Also
    • 2.3. Restrict the User to a Single Row on a Form
      • 2.3.1. Problem
      • 2.3.2. Solution
      • 2.3.3. Discussion
      • 2.3.4. See Also
    • 2.4. Use an Option Group to Collect and Display Textual Information
      • 2.4.1. Problem
      • 2.4.2. Solution
      • 2.4.3. Discussion
    • 2.5. Display Multiple Pages of Information on One Form
      • 2.5.1. Problem
      • 2.5.2. Solution
      • 2.5.3. Discussion
    • 2.6. Provide Record Navigation Buttons on a Form
      • 2.6.1. Problem
      • 2.6.2. Solution
      • 2.6.3. Discussion
      • 2.6.4. See Also
    • 2.7. Size a Form's Controls to Match the Form's Size
      • 2.7.1. Problem
      • 2.7.2. Solution
      • 2.7.3. Discussion
    • 2.8. Make a Simple "Searching" List Box
      • 2.8.1. Problem
      • 2.8.2. Solution
      • 2.8.3. Discussion
    • 2.9. Create a Replacement for Access's InputBox
      • 2.9.1. Problem
      • 2.9.2. Solution
      • 2.9.3. Discussion
        • 2.9.3.1. Using optional parameters
        • 2.9.3.2. Creating pop-up forms
        • 2.9.3.3. Initializing pop-up forms
        • 2.9.3.4. Programmatically accessing online help
        • 2.9.3.5. Miscellaneous comments
      • 2.9.4. See Also
    • 2.10. Store the Sizes and Locations of Forms
      • 2.10.1. Problem
      • 2.10.2. Solution
      • 2.10.3. Discussion
      • 2.10.4. See Also
    • 2.11. Open Multiple Instances of a Form
      • 2.11.1. Problem
      • 2.11.2. Solution
      • 2.11.3. Discussion
  • 3. Reports
    • 3.1. Create a Report with Line Numbers
      • 3.1.1. Problem
      • 3.1.2. Solution
      • 3.1.3. Discussion
    • 3.2. Print the Value of a Parameter on a Report
      • 3.2.1. Problem
      • 3.2.2. Solution
      • 3.2.3. Discussion
    • 3.3. Create a Report with Multiple Columns
      • 3.3.1. Problem
      • 3.3.2. Solution
      • 3.3.3. Discussion
      • 3.3.4. See Also
    • 3.4. Print a Message on a Report if Certain Conditions Are Met
      • 3.4.1. Problem
      • 3.4.2. Solution
      • 3.4.3. Discussion
    • 3.5. Create a Page-Range Indicator on Each Page
      • 3.5.1. Problem
      • 3.5.2. Solution
      • 3.5.3. Discussion
    • 3.6. Create a Simple Bar Graph on a Report
      • 3.6.1. Problem
      • 3.6.2. Solution
      • 3.6.3. Discussion
    • 3.7. Create a Page Total
      • 3.7.1. Problem
      • 3.7.2. Solution
      • 3.7.3. Discussion
    • 3.8. Avoid Unwanted Blank Rows on Mailing Labels
      • 3.8.1. Problem
      • 3.8.2. Solution
      • 3.8.3. Discussion
    • 3.9. Suppress Printing a Report if There Are No Records to Print
      • 3.9.1. Problem
      • 3.9.2. Solution
      • 3.9.3. Discussion
      • 3.9.4. See Also
    • 3.10. Print Different Headers or Footers on Odd and Even Pages
      • 3.10.1. Problem
      • 3.10.2. Solution
      • 3.10.3. Discussion
    • 3.11. Make a Vertical Line the Same Height as a CanGrow/CanShrink Control
      • 3.11.1. Problem
      • 3.11.2. Solution
      • 3.11.3. Discussion
    • 3.12. Alternate Gray Bars on My Reports
      • 3.12.1. Problem
      • 3.12.2. Solution
      • 3.12.3. Discussion
    • 3.13. Print Only Records Matching a Form's Filter
      • 3.13.1. Problem
      • 3.13.2. Solution
      • 3.13.3. Discussion
    • 3.14. Keep a Report from Breaking at an Inappropriate Place
      • 3.14.1. Problem
      • 3.14.2. Solution
      • 3.14.3. Discussion
    • 3.15. Customize a Report's Grouping and Sorting at Runtime
      • 3.15.1. Problem
      • 3.15.2. Solution
      • 3.15.3. Discussion
  • 4. Applications
    • 4.1. Convert Queries into Embedded SQL Statements
      • 4.1.1. Problem
      • 4.1.2. Solution
      • 4.1.3. Discussion
      • 4.1.4. See Also
    • 4.2. Build an Object Inventory
      • 4.2.1. Problem
      • 4.2.2. Solution
      • 4.2.3. Discussion
        • 4.2.3.1. Documenting all the containers
        • 4.2.3.2. Creating the inventory table
        • 4.2.3.3. Documenting each container
        • 4.2.3.4. Avoiding errors
        • 4.2.3.5. Comments
      • 4.2.4. See Also
    • 4.3. Verify That Objects Use Consistent Settings
      • 4.3.1. Problem
      • 4.3.2. Solution
      • 4.3.3. Discussion
        • 4.3.3.1. Creating the temporary tables and query
        • 4.3.3.2. Getting ready to document items
        • 4.3.3.3. Visiting all the objects
        • 4.3.3.4. Recording property information
        • 4.3.3.5. Comments
      • 4.3.4. See Also
    • 4.4. Hide Access Screen Activity
      • 4.4.1. Problem
      • 4.4.2. Solution
      • 4.4.3. Discussion
        • 4.4.3.1. Hiding reports in design view
      • 4.4.4. See Also
    • 4.5. Find out What Language Version of Access Is Installed
      • 4.5.1. Problem
      • 4.5.2. Solution
      • 4.5.3. Discussion
    • 4.6. Internationalize Text in Your Applications
      • 4.6.1. Problem
      • 4.6.2. Solution
      • 4.6.3. Discussion
    • 4.7. Change and Reset the Access Caption Bar
      • 4.7.1. Problem
      • 4.7.2. Solution
      • 4.7.3. Discussion
    • 4.8. Use the Windows File Open/Save Common Dialogs
      • 4.8.1. Problem
      • 4.8.2. Solution
      • 4.8.3. Discussion
      • 4.8.4. See Also
    • 4.9. Clean Test Data out of a Database When You're Ready to Ship It
      • 4.9.1. Problem
      • 4.9.2. Solution
      • 4.9.3. Discussion
      • 4.9.4. See Also
    • 4.10. Secure Your Access Database
      • 4.10.1. Problem
      • 4.10.2. Solution
      • 4.10.3. Discussion
  • 5. Printers
    • 5.1. Retrieve a List of All the Installed Output Devices
      • 5.1.1. Problem
      • 5.1.2. Solution
      • 5.1.3. Discussion
        • 5.1.3.1. Adding items to a list box
      • 5.1.4. See Also
    • 5.2. Set and Retrieve the Name of the Default Output Device
      • 5.2.1. Problem
      • 5.2.2. Solution
      • 5.2.3. Discussion
    • 5.3. Programmatically Change Margin and Column Settings for Reports
      • 5.3.1. Problem
      • 5.3.2. Solution
      • 5.3.3. Discussion
    • 5.4. Programmatically Change Printer Options
      • 5.4.1. Problem
      • 5.4.2. Solution
      • 5.4.3. Discussion
    • 5.5. Programmatically Control the Paper Source
      • 5.5.1. Problem
      • 5.5.2. Solution
      • 5.5.3. Discussion
    • 5.6. Retrieve Information About a Report or Form's Selected Printer
      • 5.6.1. Problem
      • 5.6.2. Solution
    • 5.7. Choose an Output Device at Runtime
      • 5.7.1. Problem
      • 5.7.2. Solution
      • 5.7.3. Discussion
    • 5.8. Find Which Reports Are Not Set to Print to the Default Printer
      • 5.8.1. Problem
      • 5.8.2. Solution
      • 5.8.3. Discussion
  • 6. Data
    • 6.1. Save with Each Record the Name of the Last Person Who Edited It and the Date and Time
      • 6.1.1. Problem
      • 6.1.2. Solution
      • 6.1.3. Discussion
      • 6.1.4. See Also
    • 6.2. Determine if You're on a New Record in a Form
      • 6.2.1. Problem
      • 6.2.2. Solution
      • 6.2.3. Discussion
    • 6.3. Find All Records with Names That Sound Alike
      • 6.3.1. Problem
      • 6.3.2. Solution
      • 6.3.3. Discussion
    • 6.4. Find the Median Value for a Field
      • 6.4.1. Problem
      • 6.4.2. Solution
      • 6.4.3. Discussion
    • 6.5. Quickly Find a Record in a Linked Table
      • 6.5.1. Problem
      • 6.5.2. Solution
      • 6.5.3. Discussion
    • 6.6. Get a Complete List of Field Properties from a Table or Query
      • 6.6.1. Problem
      • 6.6.2. Solution
      • 6.6.3. Discussion
      • 6.6.4. See Also
    • 6.7. Create and Use Flexible AutoNumber Fields
      • 6.7.1. Problem
      • 6.7.2. Solution
      • 6.7.3. Discussion
    • 6.8. Back Up Selected Objects to Another Database
      • 6.8.1. Problem
      • 6.8.2. Solution
      • 6.8.3. Discussion
        • 6.8.3.1. The MultiSelect property
        • 6.8.3.2. Filling the lboObjects list box
        • 6.8.3.3. The backup process
        • 6.8.3.4. Comments
  • 7. VBA
    • 7.1. Build Up String References with Embedded Quotes
      • 7.1.1. Problem
      • 7.1.2. Solution
      • 7.1.3. Discussion
    • 7.2. Create a Global Procedure Stack
      • 7.2.1. Problem
      • 7.2.2. Solution
      • 7.2.3. Discussion
    • 7.3. Create an Execution Time Profiler
      • 7.3.1. Problem
      • 7.3.2. Solution
      • 7.3.3. Steps
      • 7.3.4. Discussion
    • 7.4. Multitask Your VBA Code
      • 7.4.1. Problem
      • 7.4.2. Solution
      • 7.4.3. Discussion
    • 7.5. Programmatically Add Items to a List or Combo Box
      • 7.5.1. Problem
      • 7.5.2. Solution
        • 7.5.2.1. Filling a list box by calling the AddItem method
        • 7.5.2.2. Filling a list box by modifying the RowSource property
        • 7.5.2.3. Filling a list box by creating a list-filling callback function
      • 7.5.3. Discussion
        • 7.5.3.1. Calling the AddItem method
        • 7.5.3.2. Modifying the RowSource property
        • 7.5.3.3. Creating a list-filling callback function
    • 7.6. Pass a Variable Number of Parameters to a Procedure
      • 7.6.1. Problem
      • 7.6.2. Solution
      • 7.6.3. Discussion
    • 7.7. Sort an Array in VBA
      • 7.7.1. Problem
      • 7.7.2. Solution
      • 7.7.3. Discussion
      • 7.7.4. See Also
    • 7.8. Fill a List Box with a List of Files
      • 7.8.1. Problem
      • 7.8.2. Solution
      • 7.8.3. Discussion
    • 7.9. Handle Object Properties, in General
      • 7.9.1. Problem
      • 7.9.2. Solution
      • 7.9.3. Discussion
    • 7.10. Detect Whether an Object Exists
      • 7.10.1. Problem
      • 7.10.2. Solution
      • 7.10.3. Discussion
      • 7.10.4. See Also
  • 8. Optimization
    • 8.1. Accelerate the Load Time of Forms
      • 8.1.1. Problem
      • 8.1.2. Solution
      • 8.1.3. Discussion
    • 8.2. Make Slow Forms Run Faster
      • 8.2.1. Problem
      • 8.2.2. Solution
        • 8.2.2.1. Graphic and memo controls
        • 8.2.2.2. Combo and list box controls
      • 8.2.3. Discussion
    • 8.3. Make Combo Boxes Load Faster
      • 8.3.1. Problem
      • 8.3.2. Solution
      • 8.3.3. Discussion
    • 8.4. Use Jet Engine Optimizations to Speed Up Queries
      • 8.4.1. Problem
      • 8.4.2. Solution
      • 8.4.3. Discussion
    • 8.5. Accelerate VBA Code
      • 8.5.1. Problem
      • 8.5.2. Solution
      • 8.5.3. Discussion
    • 8.6. Test the Comparative Benefits of Various Optimization Techniques
      • 8.6.1. Problem
      • 8.6.2. Solution
      • 8.6.3. Discussion
    • 8.7. Accelerate Multiuser Applications
      • 8.7.1. Problem
      • 8.7.2. Solution
      • 8.7.3. Discussion
      • 8.7.4. See Also
    • 8.8. Accelerate Client/Server Applications
      • 8.8.1. Problem
      • 8.8.2. Solution
      • 8.8.3. Discussion
  • 9. User Interface
    • 9.1. Create Context-Sensitive Keyboard Shortcuts
      • 9.1.1. Problem
      • 9.1.2. Solution
      • 9.1.3. Discussion
    • 9.2. Create a Form with No Menu or Toolbar
      • 9.2.1. Problem
      • 9.2.2. Solution
      • 9.2.3. Discussion
    • 9.3. Create a Geographical Map Interface
      • 9.3.1. Problem
      • 9.3.2. Solution
      • 9.3.3. Discussion
    • 9.4. Mark a Record on a Form and Return to It Later
      • 9.4.1. Problem
      • 9.4.2. Solution
      • 9.4.3. Discussion
    • 9.5. Carry Data Forward from Record to Record
      • 9.5.1. Problem
      • 9.5.2. Solution
      • 9.5.3. Discussion
    • 9.6. Create a Combo Box That Accepts New Entries
      • 9.6.1. Problem
      • 9.6.2. Solution
      • 9.6.3. Discussion
      • 9.6.4. See Also
    • 9.7. Create Animated Buttons
      • 9.7.1. Problem
      • 9.7.2. Solution
        • 9.7.2.1. Two-state buttons
        • 9.7.2.2. Continuously animated buttons
      • 9.7.3. Discussion
    • 9.8. Create an Expanding Dialog
      • 9.8.1. Problem
      • 9.8.2. Technique
      • 9.8.3. Discussion
    • 9.9. Use an ActiveX Control
      • 9.9.1. Problem
      • 9.9.2. Solution
        • 9.9.2.1. Add a bound Calendar control to your form
        • 9.9.2.2. Create a generic unbound pop-up calendar form
      • 9.9.3. Discussion
    • 9.10. Create a Generic, Reusable Status Meter
      • 9.10.1. Problem
      • 9.10.2. Solution
        • 9.10.2.1. Create a generic status meter
        • 9.10.2.2. Use the generic status meter in your application
      • 9.10.3. Discussion
  • 10. Multiuser Applications
    • 10.1. Properly Secure Your Database
      • 10.1.1. Problem
      • 10.1.2. Solution
        • 10.1.2.1. Make a security plan
        • 10.1.2.2. Secure your database
        • 10.1.2.3. Work with the secured database
      • 10.1.3. Discussion
    • 10.2. Maintain Multiple Synchronized Copies of the Same Database
      • 10.2.1. Problem
      • 10.2.2. Solution
        • 10.2.2.1. Replicating a database
        • 10.2.2.2. Synchronizing replicas
        • 10.2.2.3. Resolving conflicts
      • 10.2.3. Discussion
    • 10.3. Create a Transaction Log
      • 10.3.1. Problem
      • 10.3.2. Solution
      • 10.3.3. Discussion
      • 10.3.4. See Also
    • 10.4. Send Messages to Other Users Without Using Email
      • 10.4.1. Problem
      • 10.4.2. Solution
      • 10.4.3. Discussion
      • 10.4.4. See Also
    • 10.5. Programmatically Track Users and Groups
      • 10.5.1. Problem
      • 10.5.2. Solution
      • 10.5.3. Discussion
    • 10.6. Adjust an Application Based on Who's Logged In
      • 10.6.1. Problem
      • 10.6.2. Solution
      • 10.6.3. Discussion
    • 10.7. List All Users with Blank Passwords
      • 10.7.1. Problem
      • 10.7.2. Solution
      • 10.7.3. Discussion
    • 10.8. Track Which Users Have a Shared Database Open
      • 10.8.1. Problem
      • 10.8.2. Solution
      • 10.8.3. Discussion
    • 10.9. Determine if a Record Is Locked and by Whom
      • 10.9.1. Problem
      • 10.9.2. Solution
      • 10.9.3. Discussion
    • 10.10. Set a Maximum Locking Interval for a Record
      • 10.10.1. Problem
      • 10.10.2. Solution
      • 10.10.3. Discussion
  • 11. Windows APIs
    • 11.1. Remove a Form's System Menu and Maximize/Minimize Buttons
      • 11.1.1. Problem
      • 11.1.2. Solution
      • 11.1.3. Discussion
    • 11.2. Flash a Window's Titlebar or Icon
      • 11.2.1. Problem
      • 11.2.2. Solution
      • 11.2.3. Discussion
    • 11.3. Classify Keypresses in a Language-Independent Manner
      • 11.3.1. Problem
      • 11.3.2. Solution
      • 11.3.3. Discussion
    • 11.4. Restrict Mouse Movement to a Specific Region
      • 11.4.1. Problem
      • 11.4.2. Solution
      • 11.4.3. Discussion
    • 11.5. Run Another Program and Pause Until It's Done
      • 11.5.1. Problem
      • 11.5.2. Solution
      • 11.5.3. Discussion
    • 11.6. Exit Windows Under Program Control
      • 11.6.1. Problem
      • 11.6.2. Solution
      • 11.6.3. Discussion
    • 11.7. Run the Application Associated with a Data File
      • 11.7.1. Problem
      • 11.7.2. Solution
      • 11.7.3. Discussion
    • 11.8. Check to See if an Application Is Already Running
      • 11.8.1. Problem
      • 11.8.2. Solution
      • 11.8.3. Discussion
    • 11.9. Retrieve a List of All Top-Level Windows
      • 11.9.1. Problem
      • 11.9.2. Solution
      • 11.9.3. Discussion
    • 11.10. Close a Running Windows Application
      • 11.10.1. Problem
      • 11.10.2. Solution
      • 11.10.3. Discussion
    • 11.11. Set File Date and Time Stamps
      • 11.11.1. Problem
      • 11.11.2. Solution
      • 11.11.3. Discussion
    • 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. Problem
      • 14.5.2. Solution
      • 14.5.3. Discussion
    • 14.6. Pass Parameters to Stored Procedures from an ADP
      • 14.6.1. Problem
      • 14.6.2. Solution
      • 14.6.3. Discussion
    • 14.7. Use Controls as Parameters for the Row Source of Combo and List Boxes in an ADP
      • 14.7.1. Problem
      • 14.7.2. Solution
      • 14.7.3. Discussion
    • 14.8. Reference Data from More than One SQL Server Database in an ADP
      • 14.8.1. Problem
      • 14.8.2. Solution
      • 14.8.3. Discussion
    • 14.9. Use Views to Update Data in an ADP When Users Don't Have Permissions on Tables
      • 14.9.1. Problem
      • 14.9.2. Solution
      • 14.9.3. Discussion
  • 15. Office Web and SharePoint
    • 15.1. Work with SharePoint Data from Access
      • 15.1.1. Problem
      • 15.1.2. Solution
      • 15.1.3. Discussion
    • 15.2. Create a SharePoint Data View Web Part Based on Access Data
      • 15.2.1. Problem
      • 15.2.2. Solution
      • 15.2.3. Discussion
      • 15.2.4. See Also
    • 15.3. Conditionally Format a Data View Web Part
      • 15.3.1. Problem
      • 15.3.2. Solution
      • 15.3.3. Discussion
      • 15.3.4. See Also
    • 15.4. Create a Master/Detail Page using Data View Web Parts
      • 15.4.1. Problem
      • 15.4.2. Solution
      • 15.4.3. Discussion
      • 15.4.4. See Also
    • 15.5. Post Web Form Data to an Access Database
      • 15.5.1. Problem
      • 15.5.2. Solution
      • 15.5.3. Discussion
      • 15.5.4. See Also
    • 15.6. Create a Web Frontend to an Access Table Using FrontPage
      • 15.6.1. Problem
      • 15.6.2. Solution
      • 15.6.3. Discussion
        • 15.6.3.1. Alternatives to FrontPage
        • 15.6.3.2. When Access won't do the job
      • 15.6.4. See Also
  • 16. Smart Tags
    • 16.1. Use the Built-in Smart Tags
      • 16.1.1. Problem
      • 16.1.2. Solution
      • 16.1.3. Discussion
      • 16.1.4. See Also
    • 16.2. Display Multiple Smart Tags on Multiple Forms
      • 16.2.1. Problem
      • 16.2.2. Solution
      • 16.2.3. Discussion
    • 16.3. Display Smart Tags when Application Starts
      • 16.3.1. Problem
      • 16.3.2. Solution
      • 16.3.3. Discussion
    • 16.4. Execute a Smart Tag Action Without Displaying the Smart Tag
      • 16.4.1. Problem
      • 16.4.2. Solution
      • 16.4.3. Discussion
    • 16.5. Create a Smart Tag on a Table in an Access Project
      • 16.5.1. Problem
      • 16.5.2. Solution
      • 16.5.3. Discussion
      • 16.5.4. See Also
    • 16.6. Create a Custom Smart Tag to Get a Weather Report
      • 16.6.1. Problem
      • 16.6.2. Solution
      • 16.6.3. Discussion
    • 16.7. Create a Custom Smart Tag DLL
      • 16.7.1. Problem
      • 16.7.2. Solution
        • 16.7.2.1. Setting up the DLL project
        • 16.7.2.2. Compiling and registering the DLL project
      • 16.7.3. Discussion
        • 16.7.3.1. Working with the Access object model
      • 16.7.4. See Also
  • 17. .NET
    • 17.1. Call a .NET Component from Access
      • 17.1.1. Problem
      • 17.1.2. Solution
      • 17.1.3. Discussion
        • 17.1.3.1. An alternate solution
        • 17.1.3.2. Not all .NET components are callable
      • 17.1.4. See Also
    • 17.2. Call a .NET Component Containing a Parameterized Constructor
      • 17.2.1. Problem
      • 17.2.2. Solution
      • 17.2.3. Discussion
    • 17.3. Retrieve Access Data from an ASP.NET Application
      • 17.3.1. Problem
      • 17.3.2. Solution
      • 17.3.3. Discussion
      • 17.3.4. See Also
    • 17.4. Call a Web Service from Access
      • 17.4.1. Problem
      • 17.4.2. Solution
      • 17.4.3. Discussion
        • 17.4.3.1. Calling web services from earlier versions of Access
        • 17.4.3.2. Locating the toolkits
      • 17.4.4. See Also
    • 17.5. Work with a Web Service that Returns a DataSet
      • 17.5.1. Problem
      • 17.5.2. Solution
      • 17.5.3. Discussion
        • 17.5.3.1. Processing the returned XML
      • 17.5.4. See Also
    • 17.6. Print an Access Report from .NET Windows Form Application
      • 17.6.1. Problem
      • 17.6.2. Solution
      • 17.6.3. Discussion
        • 17.6.3.1. Shutting down Access
        • 17.6.3.2. Communicating parameters to Access
        • 17.6.3.3. Interop assemblies
      • 17.6.4. See Also
  • 18. XML
    • XML Overview
      • The XML file
        • Root elements and namespaces
        • Attributes
        • Extensible Stylesheet Language Transformations (XSLT)
        • XML Schema Definition (XSD)
    • 18.1. Import XML Structured as Elements
      • 18.1.1. Problem
      • 18.1.2. Solution
      • 18.1.3. Discussion
      • 18.1.4. See Also
    • 18.2. Import XML into Existing Tables
      • 18.2.1. Problem
      • 18.2.2. Solution
      • 18.2.3. Discussion
    • 18.3. Import XML Using a Schema (XSD)
      • 18.3.1. Problem
      • 18.3.2. Solution
      • 18.3.3. Discussion
      • 18.3.4. See Also
    • 18.4. Export XML
      • 18.4.1. Problem
      • 18.4.2. Solution
        • 18.4.2.1. Exporting all of the data in related tables
        • 18.4.2.2. Exporting the data from a query
      • 18.4.3. Discussion
    • 18.5. Exporting Selected Columns to an HTML Table
      • 18.5.1. Problem
      • 18.5.2. Solution
      • 18.5.3. Discussion
      • 18.5.4. See Also
    • 18.6. Export Unrelated Tables
      • 18.6.1. Problem
      • 18.6.2. Solution
      • 18.6.3. Discussion
    • 18.7. Export Using a Where Clause
      • 18.7.1. Problem
      • 18.7.2. Solution
      • 18.7.3. Discussion
    • 18.8. Export a Report
      • 18.8.1. Problem
      • 18.8.2. Solution
        • 18.8.2.1. Exporting to HTML
        • 18.8.2.2. Exporting to ASP
      • 18.8.3. Discussion
        • 18.8.3.1. Dissecting the HTML
        • 18.8.3.2. Dissecting the ASP
      • 18.8.4. See Also
  • Index
  • About the Authors
  • Colophon
  • SPECIAL OFFER: Upgrade this ebook with OReilly

pokaż cały spis treści

ukryj recenzje