Access VBA
Follow these tutorials to learn more about using VBA in Excel:
- How To Create a Parameterized Jet Stored Procedure with DDL
- How to Use the CreateControl() and CreateReportControl() Functions
- How to Use the TabStrip ActiveX Control
- How to Create a Collection of Collections
- How to Exclude Zero Values When You Calculate Averages
- How to Implement CanGrow Functionality on a Data Access Page
- How to Use the Attributes Property for TableDef Objects
- How to Simulate Control Arrays in Visual Basic for Applications
- How to Use Code to Deselect Records in a Form or Subform
- How to Call Excel Functions from Within Microsoft Access
- How to Use the OpenDatabase Method to Open Password-Protected Databases
- How to Use the Circle Method on a Report
- How to Use the DeleteControl and DeleteReportControl Statements, and the CreateGroupLevel() Function
- How to Force Access to Display Dates with Four-Digit Years
- How to Reference Classes That Exist in Multiple Libraries
- Reference Nested Fields
- How to Determine the User Name in a Data Access Page in an Access Project
- How to Sink Form and Report Events to Custom Class Modules
- How to Use a Macro to Record the Date When a Record Is Modified
- How to Convert API Calls from 16-bit to 32-bit