Microsoft Access 2010 : VBA programming inside out /
You're beyond the basics, so dive right in and customize, automate, and extend Access--using Visual Basic® for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Disco...
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Sebastopol, Calif. :
Published with the authorization of Microsoft Corp. by O'Reilly Media,
©2011.
|
Colección: | Inside out (Redmond, Wash.)
|
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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).