MS Access: 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 2007 | Access 2003/XP/2000/97
• TUTORIAL: Debugging VBA Code (Understanding VBA's Debugging Environment) in Access 2007 | Access 2003/XP/2000/97

Navigation Pane (Access 2010 and 2007)

• 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