| |
| |
| Introduction | |
| |
| |
| |
| Understanding the MS Access Environment | |
| |
| |
| |
| Introduction to VBA for Applications | |
| |
| |
| History of Microsoft Access | |
| |
| |
| Developing in Access | |
| |
| |
| The Future of Microsoft Access | |
| |
| |
| Summary | |
| |
| |
| |
| Designing an Access Application | |
| |
| |
| Steps in the Development Process | |
| |
| |
| Definition and Analysis of Requirements | |
| |
| |
| Evaluation of Requirements | |
| |
| |
| Development of the Design | |
| |
| |
| Implementation and Testing | |
| |
| |
| Documentation | |
| |
| |
| Maintenance | |
| |
| |
| Summary | |
| |
| |
| |
| Access Development Without VBA | |
| |
| |
| System Architecture | |
| |
| |
| Understanding a Database Application | |
| |
| |
| Working Without VBA | |
| |
| |
| Events | |
| |
| |
| Naming Conventions | |
| |
| |
| Predefined Templates | |
| |
| |
| Switchboard Manager | |
| |
| |
| Summary | |
| |
| |
| |
| Customizing the Access Environment | |
| |
| |
| Interacting with Access | |
| |
| |
| Customizing Shortcut Menus | |
| |
| |
| Creating Menus | |
| |
| |
| Attaching Code to a Custom Menu Item | |
| |
| |
| Summary | |
| |
| |
| |
| Understanding the Visual Basic for Applications Environment | |
| |
| |
| |
| Introducing the VBA Programming Environment | |
| |
| |
| Introduction to VBA | |
| |
| |
| The VBA Model | |
| |
| |
| The Concept of Objects | |
| |
| |
| The VBA Editor | |
| |
| |
| Summary | |
| |
| |
| |
| Programming Fundametals Using VBA | |
| |
| |
| Programming Fundamentals | |
| |
| |
| Control Structures | |
| |
| |
| Arrays | |
| |
| |
| Summary | |
| |
| |
| |
| Understanding the Visual Basic Editor | |
| |
| |
| Opening the VBA Editor | |
| |
| |
| Highlights of the Menu System | |
| |
| |
| The Debug, Edit, and UserForm Toolbars | |
| |
| |
| The Project Explorer | |
| |
| |
| Managing Modules | |
| |
| |
| Properties Window | |
| |
| |
| The Object Browser | |
| |
| |
| References | |
| |
| |
| Using VBA Editor Options | |
| |
| |
| Getting Help | |
| |
| |
| Starting a New Procedure in the VBA Editor | |
| |
| |
| Summary | |
| |
| |
| |
| VBA Language Components | |
| |
| |
| Objects in VBA | |
| |
| |
| Intrinsic Constants | |
| |
| |
| Basic VBA Programs Using Forms | |
| |
| |
| Connecting with Microsoft Access | |
| |
| |
| SQL (Structured Query Language) | |
| |
| |
| SQL and VBA | |
| |
| |
| Output | |
| |
| |
| Summary | |
| |
| |
| |
| Sub Procedures | |
| |
| |
| Declaring a Procedure | |
| |
| |
| Functions | |
| |
| |
| Parameters | |
| |
| |
| Design and Scope | |
| |
| |
| Global and Static Variables | |
| |
| |
| Using Procedures to Change a Database Structure | |
| |
| |
| Summary | |
| |
| |
| |
| Debugging VBA Code | |
| |
| |
| Basics of Error Handling | |
| |
| |
| The Err Object | |
| |
| |
| The Errors Collection | |
| |
| |
| Tools for Debugging Code | |
| |
| |
| Summary | |
| |
| |
| |
| Function Procedures | |
| |
| |
| Subs vs. Functions | |
| |
| |
| Built-in Functions | |
| |
| |
| Date and Time Functions | |
| |
| |
| Payment Function | |
| |
| |
| Summary | |
| |
| |
| |
| Interacting with VBA | |
| |
| |
| |
| Forms | |
| |
| |
| Forms and Data | |
| |
| |
| Assigning Recordsets Dynamically | |
| |
| |
| Appending and Editing Data | |
| |
| |
| Controlling Controls in Forms | |
| |
| |
| Summary | |
| |
| |
| |
| Reports | |
| |
| |
| Anatomy of a Report | |
| |
| |
| Report Wizard | |
| |
| |
| Specialized Reports | |
| |
| |
| Calling the Report from VBA | |
| |
| |
| Creating a Report Programmatically | |
| |
| |
| Summary | |
| |
| |
| |
| Menus and Toolbars | |
| |
| |
| Understanding Command Bars | |
| |
| |
| Creating a Toolbar | |
| |
| |
| Menus | |
| |
| |
| Submenus | |
| |
| |
| Summary | |
| |
| |
| |
| Changing the Access Environment | |
| |
| |
| The Startup Properties | |
| |
| |
| Changing Options | |
| |
| |
| Summary | |
| |
| |
| |
| Advanced Access Programming Techniques | |
| |
| |
| |
| Database Security | |
| |
| |
| Access and Security | |
| |
| |
| User-Level Security | |
| |
| |
| Security and Access 2003 | |
| |
| |
| Summary | |
| |
| |
| |
| Access and the Microsoft Office Environment | |
| |
| |
| Shared Objects | |
| |
| |
| Connecting with Other Microsoft Office Products | |
| |
| |
| Summary | |
| |
| |
| |
| Access and the Web | |
| |
| |
| The Mechanics of the Web | |
| |
| |
| Data Access Pages | |
| |
| |
| XML (Extended Markup Language) | |
| |
| |
| Summary | |
| |
| |
| |
| Upgrading | |
| |
| |
| Microsoft Access vs. SQL Server | |
| |
| |
| Access Data Projects | |
| |
| |
| Working with an ADP File | |
| |
| |
| Summary | |
| |
| |
| |
| Application Development | |
| |
| |
| |
| Multiuser Applications | |
| |
| |
| Sharing the Database | |
| |
| |
| Handling Resource Contention and Conflicts | |
| |
| |
| Improving Application Performance | |
| |
| |
| Summary | |
| |
| |
| |
| Beyond Microsoft Access | |
| |
| |
| VBA and Microsoft Office | |
| |
| |
| Visual Basic | |
| |
| |
| VBScript | |
| |
| |
| Transition to Microsoft .NET | |
| |
| |
| Summary | |
| |
| |
| |
| The DoCmd Object | |
| |
| |
| AddMenu | |
| |
| |
| ApplyFilter | |
| |
| |
| Beep | |
| |
| |
| CancelEvent | |
| |
| |
| Close | |
| |
| |
| CopyDatabaseFile | |
| |
| |
| CopyObject | |
| |
| |
| DeleteObject | |
| |
| |
| DoMenultem | |
| |
| |
| Echo | |
| |
| |
| FindNext | |
| |
| |
| FindRecord | |
| |
| |
| GoToControl | |
| |
| |
| GoToPage | |
| |
| |
| GoToRecord | |
| |
| |
| Hourglass | |
| |
| |
| Maximize | |
| |
| |
| Minimize | |
| |
| |
| MoveSize | |
| |
| |
| OpenDataAccessPage | |
| |
| |
| OpenDiagram | |
| |
| |
| OpenForm | |
| |
| |
| OpenFunction | |
| |
| |
| OpenModule | |
| |
| |
| OpenQuery | |
| |
| |
| OpenReport | |
| |
| |
| OpenStoredProcedure | |
| |
| |
| OpenTable | |
| |
| |
| OpenView | |
| |
| |
| OutputTo | |
| |
| |
| PrintOut | |
| |
| |
| Quit | |
| |
| |
| Rename | |
| |
| |
| RepaintObject | |
| |
| |
| Requery | |
| |
| |
| Restore | |
| |
| |
| RunCommand | |
| |
| |
| RunMacro | |
| |
| |
| RunSQL | |
| |
| |
| Save | |
| |
| |
| SelectObject | |
| |
| |
| SendObject | |
| |
| |
| SetMenultem | |
| |
| |
| SetWarnings | |
| |
| |
| ShowAllRecords | |
| |
| |
| ShowToolbar | |
| |
| |
| TransferDatabase | |
| |
| |
| Transferspreadsheet | |
| |
| |
| TransferSQLDatabase | |
| |
| |
| TransferText | |
| |
| |
| Index | |