Chapter 1: General Annoyances

• Chas Dillon's Find/Replace function
• Fisher Find and Replace
• JETCOMP
• MDBSearch
• Microsoft Data Access Components (MDAC)
• Microsoft PowerToys for Windows XP
• MouseHook
• ReplaceWiz
• Speed Ferret
• TSI SysRel Copy Utility
• V-Tools
• WindowsExposer
• WinGlance
• ZilverLine

Chapter 2: Performance, Versions, Security, and Deployment

• Access Autopilot
• AccVer
• Auto FE Updater
• DBPix
• DSN-less code
• DSNStripper
• Ezy Access Launcher
• Michael Kaplan's Compactor utility
• Michael Kaplan's Password Recovery tool
• Michael Kaplan's SOON utilities
• Michael Kaplan’s Un-Replicator utility
• Total Visual Agent
• Upsizing PRO

VB code:

• Avoiding Manual DSN Setup for ODBC.txt
• Merge Two Frontends.txt
• Why Is My Database So Slow--Limit recordsets.txt
• Why Is My Database So Slow--Load records on demand.txt

Chapter 3: Data, Tables, and Database Design

• 4TOPS Excel Import Assistant
• SaveRelationshipView
• Total Access Analyzer
• TSI SysRel Copy Utility

VB code:

• Automating Import/Export.txt
• Complex Validation Rules.txt
• Default Values Don’t Apply to Existing Records.txt
• Exporting Data on the Fly.txt
• Hidden Apostrophes in Exported Data.txt

HTML code:

• Putting Data on the Web.txt

Chapter 4: Queries

• Emacs
• TextPad
• UltraEdit-32

VB code:

• Divide and Conquer with Subqueries.txt
• Finding Rows That Don't Exist.txt
• Jump to SQL View.txt
• Parameter Queries That Accept Lists.txt
• Working with Calendar Dates.txt

Chapter 5: Forms

• Form Resizer 
• ShrinkerStretcher

VB code:

• Carry Data Forward to the Next Record.txt
• Handling Items Not in a Combo Box1.txt
• Handling Items Not in a Combo Box2.txt
• Handling Items Not in a Combo Box3.txt
• One Form Many Resolutions.txt
• Option Groups Don’t Allow Text Values.txt
• Simplify Data Entry.txt
• Speed Up Slow Combo Boxes1.txt
• Speed Up Slow Combo Boxes2.txt
• Synchronizing Two Forms.txt
• Use Arrow Keys in Combo Boxes.txt

Chapter 6:

• CutePDF Writer
• Label Saver
• PDF4U
• ReportUtilities

VB code:

• Chart is Blank.txt
• Crosstab Headings.txt
• Error 2501.txt
• Filter with Parameters--custom where.txt
• More Than One Label for Each Record.txt
• Partial Sheet of Labels.txt
• Using the Default Printer.txt

Chapter 7:

• DatePicker
• Express ClickYes
• Outlook Redemption
• Total Access Statistics

VB code:

• Better Error Handling1.txt
• Better Error Handling2.txt
• File Choosers1.txt
• File Choosers2.txt
• Send Email from Access.txt
• Use Excel Functions1.txt
• Use Excel Functions2.txt
• Working Days Not Working.txt

Appendix:

• Microsoft Data Access Components (MDAC)

Return to the Fixing Access Annoyances catalog page.