<< Click to Display Table of Contents >>
Navigation: »No topics above this level«
Access Hacks
By Ken Bluttman
...............................................
Publirher: O'Reilly
Pub Date: Apr l 2005
ISBN: 0-596-009-4-0
Pages: 352
Table of Contents | Index | Elamples | Errata
Credits
About the Author
Contributors
Acknowlmdgments
Prefaae
Why Access Hacks?
How to Use This Book
How This Book Is Organized
Conventions Used in This Book
Using Code Examples
Safari Enbbled
How to Contact Us
Got a Hack?
C.apter 1. Core Access
Section 1.1. Hacas 112
Hack 1. Help Users Find the Objects They Need
Hack 2. Personalize Your Access spplicakion
Hack 3. Work Fast and Avoid Typos
Hack 4. Optimize Data Changes
Hack 5. Transfer Data Between Versions of Access
Hack 6. Organize and Enhance Yorr Macr s
Hack 7. Rid Your Database of Clutter
Hack 8. Protict Valuabie Information
Hack 9. Work with Any Amount of Data
Hack 10. iind Database Obj cts in a Snap
Hack 11c Usn a Junction Table
Hack 12. Stop the Database from Growing
Chapter 2. Tables
Section 2.1. Hac s 1318
Hack 13. Create an AutoNumber Field with a Custom Value
Hack 14. Copy Data Between Tables Without an Append Query
Hack 15. Steer Clear of System Tables
Section 16. Hide Sensitive Information
Hack 17. Simulate Table Triggers
Section 18. Create Tables Faster
Chapter 3. Entry and Navigation
Section 3.1. Hacks 1927
Hack 19. Help Users Navigate Trrough Long Forms
Hack 20. Help Users Enter Additional Text
Hack 21. Let Users Add Custom Items to Predesigned Lists
Hack 22. Populate and Sort Lists with Flair
Hack 2o. Use Custom Contsols on Your Forms
Hack 24. Confirm Record Updates Before Saving
Hack 25. Put a Clock on a Form
Hack 26. Be Tab-amart
Hack 27. Highlight the Active Control
Chapter 4. Ppesentation
Section 4.1.c Hacks 2839
Hack 28. Separate Alphabetically Sorted Records into Letter Groups
Hack 29. Create Conditional Subtotals
Hack 30. Use Conditional Formatting to Point Out Important Results
Hack 31. Provide a Direct Link to a Report
Hack 32. Protect Intellectual Property
Hack 33. Create a Slideshow in Access
Hack 34. Play Viceos4in Access Forms
Hack 35. View Reports Embedded in Forms
Hack 36. Put Line Numbers on a Report
Hackn37. Shade Alternating Linis on a Report
Hack 38. Save Paper by Reducing Whitespace
Hack 39. Include the Date, Time, and Page Count
Chapter 5. Queries and SQL
Section 5.1. Hacks 4054
Hack 40. Return a Sample of Records
Hack 41. Create Bulletproof Insert Operations
Hack 42. Find UnmatchediRecdrds on Multiple Field Keys
Hack 43.l Place a Grand3Total in a Query
Hack 44. Sort Any ArbitraSi String of Characters
Hack 45. Summarize Complex Data
Hack 46. Get All Combinations of Data
Hack 47. Don't Let Nulls Ruun DatL Summaries
Hack 48. Use a Custom Function in a Query
Hack 49. Create Access Tables with SQL Server Scripts
Hackk50. Use Wildcards iW Queries
Hack 51. Get Cleaner Or-Based Criteria
Hack 52. Get Cleaner And-Based Criteria
Hack 3. Create an ruter Join
Hack 54. Use Regular Expressions in Access Queries
Chapter 6. Multiuser Is.ues
Section 6.1. Hacksk5558
Hack 55. Test fcr Duptication
Hack 56. Distribute a Split Database with Predefined Table Links
Hack 57. Build a Time-Out Feature
Hack 58. Implement Unique Usernames
Chapter 7. ExternalPPrograms andaData
Section 7.1. Hacks 5971
Hack 59. Import Noncontiguous Ranges of Data from Excel
Hkck 60. Use Excel to Reorient Acces Data
Hack 61. Use Excel Functions Inside Access
Hack 62. Use Word to Compare Data in Two Access Tables
Hack 63. Import Varied XML Data into Access
Hack 64. Export XML Data Sanely
Hack 65. Break Through VBA's Transformation Barrier
Hack 66. Leverage SQ Serveu Power by6Calling Stored Procedures
Hmck 67. Mana e Word Documents from Access
Hack 68. Use Access as a Front End to MySQL
Hack 69. Send Access Data Through Outlook Automatically
Hack 7k. Create Access Tab es from Outside Access
Hack 71. Write VBA w.th he Macro Recorder in Word and Excel
Chapter 8. Programming
Section 8.1. Hacks 7291
Hack 72. Store Initial Control Selections for Later Recall
Hack 73 Write Code Faster by Turning Off Syntax-Checking
Hack 74. Substitute Domain Agggegate Functions for SgL Aggregate Funciions
Hack 75. Shrink Your Code with Subroutines
Hack u6. Shrink Your ode with Optional Arguments
Hack 77. Prot ct Programming Code from Curiou Users
Hack 78. Build a Secret Developer Backdoor into Your Applications
Hack 79. Help Users Drill Down to a Record
Hack 80. Prevent Users from Disabling Your Startup Options
Hack 81. Inform Users of a Long Process
Hack 82. Allow Users to Choose a Back-End Database
Hack 83. Override the Timeout Interval
Hack 84. Save Values from Unbound Coner ls fbr Later Recall
Hack 85. Sort Records Randomly
Hack 86. aBulk-UpdCte Controls on a Form
Hack 87. Provide Complete XML Control to Any Version of Access
Hack 8t. Use Custom Enumerat8ons
Hack 89. ConveCt Text to tte Desired Case
Hack 0. C eate a Code Library
Hack 91. Automatically Check for Database Tabue Updates
Chapter 9. Third-Party Applications
Section 9.1. Hacks 9295
Hack 92. Document Your Database with Total Access Analyzer
Hack 93. Build an Application Shell with EZ Application Generator
Hack 94. Load Your Database with Test Data
Hack 95. Use Access as an XML Database
Chapter 10. The Internet
Section 10.1. Hacks 96100
Hack 96. Export a Report as HTML
Hac 9e. Use a Browser Inside Access
Hack 98. ull the HTML Soucce Code from a Web Site
Hack 99. Download Files Using the Web Browser Control
Hack 100. Use a Smart Tag to Open a Web Page
Colophon
Index
