A collection of useful VBA modules that I have collected over the years:

• Browse for folder
• User Column Setup (for datasheet forms and queries) -preserve the user-specific layout of datasheets (forms and queries) between front-end updates
• Switch between Access instances
• Conditional formatting (datasheet alternate rows)
• CurrentRow
• GetOpenFile
• GetSaveFile
• Join From Array
• LDAP Authentication
• Printer Selection
• Process Folders (recursive iteration)
• String Functions
• User Name
• Valid Credit Card Number
• Work with dates
• Archive files (zip)
• Utility Functions
• Alter ODBC back-end table (pass-through query)