9780735665033

0735665036

9780735664906

0735664900

9780735661639

0735661634

9780735659872

0735659877

Access 2010 VBA programming inside out

O'Reilly Safari. OCLC KB.

Inside out

Copyright; Dedication; Contents at a Glance; Table of Contents; Introduction; Features and Conventions Used in This Book; About the Companion Content; Acknowledgments; Support and Feedback; How to Access Your Online Edition Hosted by Safari; How to Download the Online Edition to Your Computer; Part 1. VBA Environment and Language; Chapter 1. Using the VBA Editor and Debugging Code; Debugging Code on a Form; Entering the VBA Editor; The Application and VBA Code Windows; Creating Modules and Procedures; Creating a Module; Creating a Procedure; Executing a Subroutine; Executing a Function.

Viewing and Searching CodeSplit Window; Searching Code; Debugging Code in a Module; Debug Commands; Breakpointing Code; Set Next Command; Breakpoint Step and Run Commands; Displaying Variables in the Locals Window; Tracing Procedures with the Call Stack; Watching Variables and Expressions; Adding Conditional Watch Expressions; Working with the Immediate Window; Changing Code On-the-Fly; Using the Object Browser and Help System; Configuring the Help System; Working with the Object Browser; Summary; Chapter 2. Understanding the VBA Language Structure; VBA Language Settings; Comments.

Setting Option ExplicitSelecting Option Compare; Compiling Code; Conditional Compilation; References; Working with Constants and Variables; Improving Code Quality with Constants; The Enum Keyword; Variables and Database Field Types; Handling NULL Values, IsNull and Nz; Using Static Variables; Using Global Variables; Variable Scope and Lifetime; Working with Arrays; Type Structures; Functions and Procedures; Managing Code with Subroutines; Defining ByRef and ByValue Parameters; Private and Public Procedures; Optional and Named Parameters; The ParamArray Qualifier.

Organizing Code in Modules and Class ModulesControl Statements and Program Flow; IF ... Then ... Else ... Statements; IIF Statements; Choose Statements; Select Case Statements; TypeOf Statements; For and For Each Loops; Do While and Do Until Loops; Exit Statements; The With Statement; GoTo and GoSub; Line Continuation; Splitting SQL Over Multiple Lines; Summary; Chapter 3. Understanding the VBA Language Features; Using Built-In Functions; Date and Time Functions; String Functions; Domain Functions; Constructing Where Clauses; SQL and Embedded Quotes; Using VBA Functions in Queries; The Eval Function.

Shell and SendkeysThe DoEvents Command; Objects and Collections; Object Variables; Is Nothing, IsEmpty, IsObject; Creating Maintainable Code; Naming Access Document Objects; Naming Database Fields; Naming Unbound Controls; Naming Variables in Code; Indenting Code; Other Variable Naming Conventions; VBA and Macros; Access Basic; Converting Macros to VBA; Error Handling; On Error Resume Next; Err Object; On Error GoTo; Developing a General Purpose Error Handler; OpenArgs and Dialog Forms; Err. Raise; Summary; Part 2. Access Object Model and Data Access Objects (DAO).