Access 2003 VBA Programmer's Reference.
Title:
Access 2003 VBA Programmer's Reference.
Author:
Cardoza, Patricia.
ISBN:
9780764571664
Personal Author:
Edition:
1st ed.
Physical Description:
1 online resource (892 pages)
Contents:
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.
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.
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.
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.
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.
An Advanced Example-Creating a Graph in Access and Inserting It into PowerPoint.
Abstract:
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 this book, a crack team of programmers including two Microsoft MVPs shows you how to take control of Access 2003 or 2002 using VBA. You'll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and more. An entire chapter is devoted to the changes in Access 2003, including new wizards and GUI features that previously required VBA code as well as new VBA features. You'll receive a thorough education in system security, macro security, and the Access Developer Extensions (ADE). You will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects. Finally, you will learn more about the relationship between Access and SQL Server®, and how to use VBA in Access to control and enhance other Office applications. What you will learn from this book How to take advantage of the built-in Access object library, using Access commands and executing them from any Access toolbar What you need to know to design your own classes, implement common APIs in your code, and use SQL to access data How to configure custom menus for your Access database applications Ways to transfer information between Access and Excel, Word, Outlook®, and other Office programs How to show or hide entire sections of reports based on data entered on a form, or hide form fields based on database login information Object models you can use when writing VBA code in Access, and a list of common API functions to use in your code Who this book is for This book is a comprehensive resource for
Access users and VBA developers who want to increase the power of Access using VBA. In addition to experience with VBA, you should have read at least one tutorial covering VBA for Access. Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Genre:
Electronic Access:
Click to View