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...
Saved in:
| Main Authors: | , , , |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Hoboken
John Wiley & Sons, Incorporated
2004
Wrox Wiley-Blackwell Wiley |
| Edition: | 1 |
| Subjects: | |
| ISBN: | 0764559036, 9780764559037 |
| Online Access: | Get full text |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| 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. |
|---|---|
| AbstractList | This text covers all features of VBA programming for Access database applications. It includes real-world examples to demonstrate each programming topic, including using the Access Object Model, VBA execution and error handling, creating database objects with VBA, writing secure VBA code and more. 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. Covers all features of VBA programming for Access database applicationsBegins with an overview of VBA and highlights what's new in Microsoft Access 2003, the most popular database system in the worldReal-world code examples demonstrate each programming topic, including using the Access Object Model, VBA execution and error handling, creating database objects with VBA, writing secure VBA code, and much moreShows how Access 2003 provides enhanced XML support, making it easier for programmers to publish data to the Web and exchange it with other organizations |
| Author | Seach, Graham Hennig, Teresa Stein, Armen Cardoza, Patricia |
| Author_xml | – sequence: 1 fullname: Cardoza, Patricia – sequence: 2 fullname: Hennig, Teresa – sequence: 3 fullname: Seach, Graham – sequence: 4 fullname: Stein, Armen |
| BookMark | eNpFkNtKAzEQhiMeqK19h72QiheFSbLJJJdtqQcoKCK9Ddl1onW3u7rZVh_fnrBzM8zw8c3wd9lZVVd0wrqAOlXItU5PD4OyIPUF6yCgAIGyw_oxfsK2rE65vGSDUZ5TjIkAkMl8PEqem_q98cslNTcxeaFADVU5XbHz4MtI_UPvsfnd9HXyMJw93T9ORrOhV6isGRKCtxDSFDK0Jn-TWnAuPCqw1pucG2M5bdZk0QsOCtMgslyD1yYohSB7bLAXx2JRlrEOrcvquogi_UWXFXH7ujQgNuDtHvSxoJ_4UZdtdOuSdrSzaI5pbNjrg9QH3yz2RrcW_9g2Jzze_mrq7xXF1u1sOVVt40s3HU-4kQaN_AM6L2UQ |
| ContentType | eBook |
| DBID | OHILO OODEK |
| DEWEY | 005.7565 |
| DatabaseName | O'Reilly Online Learning: Corporate Edition O'Reilly Online Learning: Academic/Public Library Edition |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Computer Science |
| DocumentTitleAlternate | Microsoft Visual Basic for applications. Microsoft Access. |
| EISBN | 0764571664 9780764571664 0764559036 9780764559037 |
| Edition | 1 |
| ExternalDocumentID | bks00003802 9780764571664 9780764559037 EBC183878 |
| Genre | Electronic books |
| GroupedDBID | 089 1R2 20A 38. 5VX A4I A4J AABBV AALIM ABARN ABIAV ABQPQ ACLGV ACNAM ADVEM AERYV AFOJC AHWGJ AJFER AKHYG ALMA_UNASSIGNED_HOLDINGS AMYDA AZZ BBABE BPBUR CZZ GEOUK HF4 JJU MYL NK1 NK2 NY6 OHILO OODEK PQQKQ |
| ID | FETCH-LOGICAL-a57598-e70a90f440b798cd362112a75099a8c18891ecd3e97a210574f2bc60a68f55703 |
| ISBN | 0764559036 9780764559037 |
| IngestDate | Wed Mar 26 01:41:01 EDT 2025 Mon Sep 22 03:34:13 EDT 2025 Fri Dec 05 17:58:40 EST 2025 Wed Dec 10 11:07:14 EST 2025 |
| IsPeerReviewed | false |
| IsScholarly | false |
| LCCallNum | QA76.9.D3 A28935 2004b |
| LCCallNum_Ident | QA76.9.D3A28935 2004 |
| Language | English |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-a57598-e70a90f440b798cd362112a75099a8c18891ecd3e97a210574f2bc60a68f55703 |
| Notes | Available also in a print ed. Mode of access: Internet via World Wide Web. Title from title screen. |
| OCLC | 70720273 |
| PQID | EBC183878 |
| PageCount | 982 |
| ParticipantIDs | skillsoft_books24x7_bks00003802 askewsholts_vlebooks_9780764571664 safari_books_v2_9780764559037 proquest_ebookcentral_EBC183878 |
| PublicationCentury | 2000 |
| PublicationDate | 2004 2004-04-09T00:00:00 2004-12-31 c2004 |
| PublicationDateYYYYMMDD | 2004-01-01 2004-04-09 2004-12-31 |
| PublicationDate_xml | – year: 2004 text: 2004 |
| PublicationDecade | 2000 |
| PublicationPlace | Hoboken |
| PublicationPlace_xml | – name: Hoboken – name: Hoboken, N.J |
| PublicationYear | 2004 |
| Publisher | John Wiley & Sons, Incorporated Wrox Wiley-Blackwell Wiley |
| Publisher_xml | – name: John Wiley & Sons, Incorporated – name: Wrox – name: Wiley-Blackwell – name: Wiley |
| SSID | ssj0000096413 |
| Score | 1.8005949 |
| Snippet | Its power and short learning curve have made Access Microsoft's leading consumer relational database management system for desktop applications. VBA lets you... Covers all features of VBA programming for Access database applicationsBegins with an overview of VBA and highlights what's new in Microsoft Access 2003, the... This text covers all features of VBA programming for Access database applications. It includes real-world examples to demonstrate each programming topic,... |
| SourceID | skillsoft askewsholts safari proquest |
| SourceType | Aggregation Database Publisher |
| SubjectTerms | Database management Microsoft Access Microsoft Visual Basic for applications |
| SubjectTermsDisplay | Database management. Electronic books. Microsoft Access. Microsoft Visual Basic for applications. |
| TableOfContents | 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 |
| Title | Access 2003 VBA Programmer's Reference |
| URI | https://ebookcentral.proquest.com/lib/[SITE_ID]/detail.action?docID=183878 https://learning.oreilly.com/library/view/~/9780764559037/?ar https://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9780764571664 http://www.books24x7.com/marc.asp?bookid=8119 |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV3dS8MwED90E3QvfuP8LCL6IIUuzZbk0clUEKYPKnsraZvC2OhkmWP413tJu27dkz74UtqkDeV34XJ3yd0P4CoWTV_FvnA9GfquOUfoCj9RLk4dIQVtURmGlmyCdbu81xOveYxMWzoBlqZ8NhOf_ypqbENhm9TZP4i7GBQb8B6FjlcUO15XLOLiMT9vbLkPTY1A__ajfWdyAMzRK0uPwkw6SJ7at9h2GMejb7ko1N-XpRhAUWlwWdO4RcSv5CJ6rEWb6BRltcJXakuX-tehSmjTpxWoPnZe3p-LUJVxc6jhf6hJPUDVi2p5ossWuZYJuvY12NSD_nCocQVZWqXfdqCqTOrGLqypdA-254QVTq6_9uE6g8gxEDkIkbOA6EY7BUAH8PHQebt_cnOiCFcaflHuKuZJ4SWUeiETPIpxVUY7UhprSEgeNTgXDYXNSjBJDLMxTUgYtTzZ4omtQXYIlXSUqiNwCJUq4na3V1FKYkmiRkOaqncxR-MwrsPlEgrBdGg3tXVQgrIOF3NwAtufn7QNOu171KGc8TqcZZgF2edTUozQFJ7PcIQCyuwVQmcsCAe27pfPPXL8mx85ga3FfDmFymT8pc5gI5pO-np8ngv6B7jgHBg |
| linkProvider | ProQuest Ebooks |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.title=Access+2003+VBA+Programmer%27s+Reference&rft.au=Cardoza%2C+Patricia&rft.date=2004-12-31&rft.pub=Wiley-Blackwell&rft.isbn=9780764571664&rft.externalDocID=9780764571664 |
| thumbnail_m | http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fwww.safaribooksonline.com%2Flibrary%2Fcover%2F9780764559037 http://cvtisr.summon.serialssolutions.com/2.0.0/image/custom?url=https%3A%2F%2Fvle.dmmserver.com%2Fmedia%2F640%2F97807645%2F9780764571664.jpg |