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