0. Library Databases (4:47)
Build Shared VBA Libraries, Reusable Forms and Reports, Connect Them to Multiple Access Databases
Shared library databases in Microsoft Access
1. Library Database 1 (20:00)
Create a Shared Microsoft Access VBA Library for Multiple Databases
Creating a shared VBA library database
Moving common functions into a library
Adding an Access library reference
Naming the VBA project for references
Using library functions in other databases
Adding shared functions to an existing library
Library code changes do not save from references
Function precedence in local and library modules
Fixing broken library file references
Library file locking and update considerations
Using shared modules across databases
2. Library Database 2 (27:27)
Share Forms Across Microsoft Access Databases Using VBA, Linked Tables, and Dynamic Record Sources
Public vs. private library procedures
Using private helper procedures in library modules
Calling public library functions from other databases
Opening library forms with public wrapper procedures
Creating a reusable Notice form
Displaying and auto-closing library notice forms
Sharing forms across multiple Access databases
Using library forms with calling database tables
Setting a form RecordSource with SQL IN clauses
Passing CurrentProject.FullName to library procedures
Using shared backend tables with library forms
Linking library databases to shared tables
Distributing protected library forms with ACCDE
3. Library Database 3 (22:43)
Pass Parameters, Use OpenArgs, Share Reports, and Work with Library Forms Across Databases
Using library forms with local tables
Passing record IDs to library routines
Optional parameters for form filtering
Building dynamic SQL WHERE clauses
Passing values with OpenArgs
Filtering forms in the Form_Load event
Reading library form control values
Setting library form control values
Opening shared reports from a library
Avoiding duplicate form and report names
4. What's Next (4:29)
Build Shared VBA Libraries, Reusable Forms and Reports, & Connect Them to Multiple Access Databases
Course closing remarks summarizing library databases and previewing upcoming topics.
