Utilities and Code
|
"Instead of waiting on the line for tech support or searching for the answer on the Internet with its too many resources to find exactly what you need, take control of databases with Fixing Access Annoyances, your partner on database adventures." |
By Phil Mitchell, Evan Callahan
|
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
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:
Chapter 4: Queries
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
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:
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:
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
