Beginning Access 2003 VBA
What is this book about? Written by an Access programmer with more than 10 years of VBA experience, this is the perfect guide for Access users who are ready to take their databases to the next level, or for programmers who are new to Access or VBA. Veteran Access developer Denise Gosnell shows read...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Ind. :
Wiley Technology Pub
2004.
|
| Colección: | Programmer to programmer.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009644288306719 |
Tabla de Contenidos:
- Introduction; Chapter 1: Introduction to Access 2003 VBA; What Is Access 2003 VBA?; What's New in Access 2003 VBA?; Access 2003 VBA Programming 101; Requirements Gathering Phase; Design Phase; Development Phase; Testing Phase; Implementation Phase; Summary; Exercises; Chapter 2: The Basics of Writing and Testing VBA Code; Creating Modules; Standard Modules versus Class Modules; Creating and Calling Procedures; Sub versus Function Procedure; Upgrading Macros to Procedures; Using Variables and Constants to Store Values; Types of Variables; Declaring and Using Variables; Constants
- Scope and Lifetime of Variables and ConstantsNaming Conventions; Controlling Program Flow; Decision Making; Loops; Documenting Your Code; Error Debugging; Types of Errors; Debugging Your Code; Error Handling; Default Error Messages; Handling Errors with an On Error Statement; The Err Object; Using the Errors Collection; Creating a Generic Error Handler; Summary; Exercises; Chapter 3: Programming Applications Using Objects; Elements of an Object; What Is a Property?; What Is a Method?; What Is an Event?; Viewing Objects Using the Object Browser; Ways to Refer to Objects
- Using Access Collections and ObjectsThe Forms Collection and Form Object; The Reports Collection and Report Object; The CurrentProject Object; The DoCmd Object; The Screen Object; The Printers Collection and Printer Object; Other Objects; Summary; Exercises; Chapter 4: Creating Your Own Objects; Using Class Modules to Create Your Own Objects; Class Diagrams; Creating Properties; Creating Methods; Creating Events; Using the Class; Advanced Techniques; Create Custom Properties for Existing Objects; Using Existing Tag Property; Using Public Variables
- Using Property Let, Property Get, and Property Set RoutinesCreate Custom Methods for Existing Objects; Using Public Sub Procedures and Functions; Summary; Exercises; Chapter 5: Interacting with Data Using ADO and SQL; Introduction to Data Access; Using ADODB to Work with Data; The ADO Object Model; The Connection Object; The Command Object; The Recordset Object; Introduction to SQL; Retrieving Data Using SQL Select Statements; Inserting Data Using SQL Insert Statements; Updating Data Using SQL Statements; Deleting Data Using SQL Statements; Using ADOX to Manipulate Data Objects
- Creating a Table with ADOXManaging Security with ADOX; Summary; Exercises; Chapter 6: Building Interactive Forms; Form Navigation and Flow; Working with Controls; Combo Boxes versus List Boxes; Tab Controls and Subforms; Building User Interaction; The MsgBox Function; Validating User Input; Adding Polish to Your Forms; Summary; Exercises; Chapter 7: Importing, Linking, and Exporting Using External Data Sources; Linking, Importing, and Exporting Overview; Access and Other Databases; Transferring Complete SQL Server Database; Spreadsheets; Text Files; XML Files; E-mails and Outlook
- Other Ways to Export Data
