Access Topics: Modules
A module is a collection of user-defined functions, subroutines, and global variables written in VBA code. These objects can then be used/called from anywhere in your Access database.
Tutorials:
TUTORIAL: VBA Basics (Understanding the VBA environment) in Access 2003/XP/2000/97
TUTORIAL: Debugging VBA Code (Understanding VBA's Debugging Environment) in Access 2003/XP/2000/97
Navigation Pane:
Display modules in the Navigation Pane in Access 2007
Display all objects (tables, queries, forms, reports, modules) in the Navigation Pane in Access 2007
Display tables and related objects in the Navigation Pane in Access 2007
Errors:
Database variable "not defined" error in Access 2003/XP/2000/97
How to fix a "Compile error.in query expression" Error in Access 2003/XP/2000/97
Launch applications:
Launch Microsoft Word from Access 2003/XP/2000/97
Open a Microsoft Word document from Access 2003/XP/2000/97
Launch Microsoft Excel from Access 2003/XP/2000/97
Launch Notepad from Access 2003/XP/2000/97
Launch an application from Access 2003/XP/2000/97
Open a PowerPoint file from a macro in Access 2003/XP/2000/97
Sequential numbers:
Create a sequential number that you can control instead of using an AutoNumber field in Access 2003/XP/2000/97
Create a sequential number that you can control using a format such as AGR-0001 in Access 2003/XP/2000/97
Create a sequential number that you can control using a format such as A05-0001 in Access 2003/XP/2000/97
Create a sequential number that you can control using a format such as OD00000001 and generate multiple records at once in Access 2003/XP/2000/97
Create a sequential number you control that is assigned every time a form is opened in Access 2003/XP/2000/97
Oracle:
Link to an Oracle table using VBA code in Access 2003/XP/2000/97
Create a pass-through query to retrieve the nextval from an Oracle sequence with VBA code in Access 2003/XP/2000/97
Call an Oracle stored procedure using VBA code in Access 2003/XP/2000/97
Updates:
Perform an update with VBA code in Access 2003/XP/2000/97
Update a date field with VBA code in Access 2003/XP/2000/97
Reset a text field to NULL with VBA code in Access 2003/XP/2000/97
Renumber invoices with VBA code in Access 2003/XP/2000/97
Converting Macros to VBA:
Convert CancelEvent macro to VBA code in Access 2003/XP/2000/97
Convert Close macro to VBA code in Access 2003/XP/2000/97
Convert GoToControl macro to VBA code in Access 2003/XP/2000/97
Convert GoToRecord macro to VBA code in Access 2003/XP/2000/97
Convert OpenForm macro to VBA code in Access 2003/XP/2000/97
Convert OutputTo macro to VBA code in Access 2003/XP/2000/97
Convert Quit macro to VBA code in Access 2003/XP/2000/97
Convert RunCommand macro to VBA code in Access 2003/XP/2000/97
Hide/Unhide Close button on Access program:
Hide Close button on Access program in Access 2003/XP/2000/97
Unhide Close button on Access program in Access 2003/XP/2000/97
Tab Controls:
Establish tab order between objects in tab control pages in Access 2003/XP/2000/97
Set focus on first text box on first tab page and go to next record in Access 2003/XP/2000/97
Miscellaneous:
Quit Access using VBA code in Access 2003/XP/2000/97
Add new record using VBA code in Access 2003/XP/2000/97
Delete a record using VBA code in Access 2003/XP/2000/97
Find next incremental value for an AutoNumber field in Access 2003/XP/2000/97
Retrieve the user name from Windows while in an Access database in Access 2003/XP/2000/97
Access a value from a table using VBA code in Access 2003/XP/2000/97
Determine number of records affected by an Execute command in Access 2003/XP/2000/97
Change the tab order on a form with VBA code in Access 2003/XP/2000/97
Filter report results using the OpenReport VBA command in Access 2003/XP/2000/97
Create new database file and transfer tables using VBA in Access 2003/XP/2000/97
Calculate the number of workdays between two dates in Access 2003/XP/2000/97
Set up a report to print on legal size paper using VBA code in Access 2003/XP/2000/97
Test a string for an alphanumeric value in Access 2003/XP/2000/97