Access 2003 VBA Programmer's Reference
Its power and short learning curve have made Access Microsoft's leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more. In th...
Uloženo v:
| Hlavní autoři: | , , , |
|---|---|
| Médium: | E-kniha |
| Jazyk: | angličtina |
| Vydáno: |
Hoboken
John Wiley & Sons, Incorporated
2004
Wrox Wiley-Blackwell Wiley |
| Vydání: | 1 |
| Témata: | |
| ISBN: | 0764559036, 9780764559037 |
| On-line přístup: | Získat plný text |
| Tagy: |
Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
|
Obsah:
- The Custom Startup Wizard -- The Package Wizard -- Summary -- Chapter 4: VBA Basics -- VBA Objects -- Objects -- Methods -- Events -- Variables and VBA Syntax -- Variables -- Other VBA Structures -- Comments -- Line Continuation -- Constants -- Enums -- Summary -- Chapter 5: Using the VBA Editor -- Anatomy of the VBA Editor -- Your Access Database and VBA Project-Better Together -- Using the Object Browser -- Testing and Debugging VBA Code -- Summary -- Chapter 6: Using DAO to Access Data -- Direct Access Objects -- Why Use DAO? -- Referring to DAO Objects -- Default Collection Items -- The DBEngine Object -- The Workspaces Collection -- The Errors Collection -- The Databases Collection -- The Connections Collection -- DAO Object Properties -- DAO Property Types -- Creating Schema Objects with DAO -- Managing Jet Security with DAO -- Creating Security Objects -- Managing Users and Groups -- Managing Passwords -- Managing Permissions -- Data Access with DAO -- Working with QueryDefs -- Working with Recordsets -- Filtering and Ordering Recordsets -- Navigating Recordsets -- Bookmarks and Recordset Clones -- Finding Records -- Working with Recordsets -- Summary -- Chapter 7: Using ADO to Access Data -- Ambiguous References -- Referring to ADO Objects -- Default Collection Items -- Connecting to a Data Source -- Specifying a Cursor Location -- Rolling Your Own Connection String -- Creating and Using a Data Link -- Data Access with ADO -- The ADO Object Model -- Executing Action Queries -- Creating ADO Recordsets -- Creating a Standard Recordset -- Creating a Recordset from a Command Object -- Opening a Shaped Recordset -- Verifying the Options That a Recordset Supports -- Referring to Recordset Columns -- Filtering and Ordering Recordsets -- Navigating Recordsets -- Finding Records -- Editing Data with Recordsets -- Persistent Recordsets
- An Advanced Example-Creating a Graph in Access and Inserting It into PowerPoint
- Intro -- About the Authors -- Acknowledgments -- Foreword -- Introduction -- Chapter 1: Introduction to Microsoft Access -- Why Use Microsoft Access? -- Is Access the Only Database I'll Ever Need? -- Microsoft Access -- MSDE -- SQL Server -- Automating Microsoft Access Without VBA Code -- The Database Wizard -- Creating a Switchboard for Your Database -- Begin at the Beginning -- Create a Switchboard through the Switchboard Manager -- Add and Con.gure Controls Using Wizards -- Building Automation into Your Project -- Using Expression Builder -- Using the Macro Builder -- Using the Code Builder -- Summary -- Chapter 2: Access, VBA, and Macros -- VBA within Access -- Writing Code within Modules -- VBA versus Macros in Access -- Macros in Access 2003 -- Advantages to Using VBA over Macros -- Summary -- Chapter 3: New Features in Access 2003 -- Easy Upgrading -- Database Structure and Management -- Find Object Dependencies -- Form/Report Error Checking -- Propagate Field Properties -- Customize SQL Font -- Get Context-Sensitive SQL Help -- Backup Database/Project -- Sorting Option on Lookup Wizard -- Copy and Paste Linked Table as Local Table -- Notable Mention -- New Wizards and Builders and Managers -- A Wizard for Every Occasion -- Available Builders -- Managers -- Changes to Jet -- Service Pack 8 -- Security and Related Features -- What Is Macro Security? And Why Are We Talking about Macros? -- Digital Signatures -- Expression Sandbox -- End-User Enhancements -- Pivot Charts -- Windows XP Theming -- Templates -- Smart Tags -- AutoCorrect Options Buttons -- Better Accessibility -- XML and Access -- Relating XML to HTML -- The Advantages of XML -- Using Access 2003 with SharePoint Services -- Export Information to a SharePoint Server -- Import Information From a SharePoint Server -- Access Developer Extensions -- The Property Scanner
- Creating Schema Recordsets -- Using ADO Events -- Testing the State Property -- Creating Schema Objects with ADOX -- The ADOX Object Model -- Working with Queries (Views) -- Creating Tables and Columns -- Creating Indexes -- Creating Relations -- Managing Jet Security with ADO -- Creating Groups and Users -- Managing Permissions -- Summary -- Chapter 8: Executing VBA -- When Events Fire -- Common Form Events -- Common Control Events -- Common Report Events -- Asynchronous Execution -- VBA Procedures -- Function or Sub? -- Public or Private? -- Coupling and Cohesion -- Error Handling -- Class Modules -- Using Variables -- Using Appropriate Data Types and Sizes -- Using Global Variables -- Evaluating Expressions in VBA -- If .. Then -- Checking for Nulls -- Nulls and Empty Strings -- Select Case -- Using Recordsets -- Opening Recordsets -- Looping Through Recordsets -- Adding Records -- Finding Records -- Updating Records -- Using Multiple Recordsets -- Cleaning Up -- Using VBA in Forms and Reports -- All About "Me" -- Referring to Controls -- Referring to Subforms and Subreports -- Sizing Reports -- Closing Forms -- Debugging VBA -- Responding to Errors -- Investigating Variables -- When Hovering Isn't Enough-Using the Immediate Window -- Setting Breakpoints -- Setting Watch Values -- Stopping Runaway Code -- Stepping Through Your Code -- Common VBA Techniques -- Date Handling -- Handling Rounding Issues -- String Concatenation Techniques -- Summary -- Chapter 9: VBA Error Handling -- Why Use Error Handling? -- Two Kinds of Errors: Unexpected and Expected -- Handling Unexpected Errors -- Absorbing Expected Errors -- Basic Error Handling -- Basic Error Handling with a Twist -- Example of the Extra Resume -- Cleaning Up After an Error -- More on Absorbing an Expected Error: Example -- Error Handling with Logging -- Error Handling That Sends E-mail
- Instancing -- Summary -- Chapter 13: Extending VBA with APIs -- Introducing the Win32 API -- Why Do You Need the API? -- Introducing DLLs -- Static Linking -- Dynamic Linking -- Linking Libraries in Access 2003 -- Referencing a Library -- Declaring APIs -- Understanding C Parameters -- Signed and Unsigned Integers -- 8-Bit Numeric Parameters -- 16-Bit Numeric Parameters -- 32-Bit Numeric Parameters -- Currency Parameters -- Floating-Point Parameters -- Boolean Parameters -- Handle Parameters -- Object Parameters -- String Parameters -- Variant Parameters -- Pointers to Numeric Values -- Pointers to C Structures -- Pointers to Arrays -- Pointers to Functions -- The Any Datatype -- Err.LastDLLError -- Distributing Applications That Reference Type Libraries and Custom DLLs -- Summary -- Chapter 14: SQL and VBA -- Working with SQL Strings in VBA -- Building SQL Strings with Quotes -- Using Single Quotes Instead of Double Quotes -- Concatenating Long SQL Strings -- Using SQL When Opening Forms and Reports -- Using SQL to Enhance Forms -- Sorting on Columns -- Selections on Index Forms -- Cascading Combo Boxes -- Using SQL for Report Selection Criteria -- Altering the SQL Inside Queries -- The ReplaceOrderByClause and ReplaceWhereClause Functions -- Summary -- Chapter 15: Working with Of.ce Applications -- Sharing Information Is a Two-Way Street -- Access and Outlook-Sharing Data with Others -- Working with Outlook's Security Features -- Creating Other Types of Outlook Items from Access -- Sending Information from Access to Excel -- Provide Management with Flexible Data Access -- Exchanging Information with Microsoft Word -- The Easy Way-Use Access VBA to Start Your Merge -- The Hard Way-Using VBA to Set Up Your Merge Document -- Non-Mail Merge Operations-Sending Access Data to Word
- Summary -- Chapter 10: Using VBA to Enhance Forms -- Concept Review -- Properties -- Event Properties -- Associating Code to an Event Property -- You Talking to Me? -- Event Property and Procedure Examples -- Form_Open(): Passing the OpenArgs Parameter -- OnTimer(): Performing an Action on an Interval -- OnCurrent(): Opening Existing Records as "Read-Only" -- BeforeUpdate(): Performing Data Validation -- AfterUpdate(): Synchronizing Two Combo Boxes -- OnChange(): Late Bind a Subform on a Tab Control -- NotInList(): Adding a Value to a Combo Box at Runtime -- On Close(): Save a Setting to the Registry -- Creating Forms and Controls with VBA -- Managing Multiple Form Instances -- When Not to Use VBA -- Syncronized Subforms -- Displaying Data in a Treeview Control -- Summary -- Chapter 11: Enhancing Reports with VBA -- Event Properties -- Associating Code to an Event Property -- You Talking to Me? -- Event Property and Procedure Examples -- Report_Open(): Execute a Query Before Report Displays -- Report_NoData(): What to do When There Is No Data to Display -- Section_Format(): Dynamically Display Page Numbers -- Section_Print(): Conditional Formatting of a Text Box -- Compute a Running Balance -- Running Sum Property -- The Report Design -- VBA Code Behind Report -- When Not to Use VBA -- Summary -- Chapter 12: Creating Classes in VBA -- A Touch of Class -- Why Use Classes? -- Creating a Class Module -- Adding a Class Module to the Project -- A Brief Word on Naming the Class -- Instantiating Class Objects -- Creating Class Methods -- Creating Property Procedures -- Naming Objects -- What Does the Object Do? -- Verbs, Nouns, and Adjectives -- Using Class Events -- Handling Errors in Classes -- Forms as Objects -- Variable Scope and Lifetime -- The Me Property -- Creating and Using Collection Classes -- The Three Pillars -- Inheriting Interfaces