Gary's Database Tools posted on Utter Access

Excel Folder Import and Fieldname Fixer -   Article   Download

This code lets you instantly import all worksheets of all Excel file workbooks contained inside one folder, and then automatically combines everything into one table, then automatically create and populate and combine like fieldnames to suit.

Calendar Popup (Date Picker) with and without Scheduled Events -   Article   Download

This lets you quickly pick a date from a Calendar. It also has a Calendar Events tool that combines the Calendar Popup with a scheduled event calendar table

Whole-Year Date Picker -   Article   Download

This shows you the entire year at once instead of just one month at a time.

Database Search -   Article   Download

This is code lets you instantly filter the records of all or one fields, of all or one tables, of all or one databases, for your search string, all at once simultaneously.

Phonebook Email Distribution List -   Article   Download

I use many different web-based and application-based email programs. Instead of maintaining the address books in any of them, I use this database. It is my only address book, anywhere. I create email distribution lists, save them, reuse them, and copy and paste them into the TO and CC and BCC fields of my various email programs on as as-needed basis.

Table/Query Was/Is Comparison Generator -   Article   Download

This Database Form automatically generates a WAS-IS comparison Table, based on the differences in the data inside two selected Tables.

Table/Query Field/Record Consolidator -   Article   Download

All of the Records, Fieldnames, and data inside the selected Table or Query will be Consolidated into just one Cell (of type Memo, of course) of one Table.

Send email using Lotus Notes -    Article     Download 

This Database sends emails using Lotus Notes, based on the contents of a Table.