Last updated 14 November 2000
| Sample Chapters: | |
 |
Download Chapter 4 (Searching and Sorting) from VBA Developer's Handbook in PDF (Adobe Acrobat) format. |
|
|
Download Chapter 5 (Access SQL) from Access 2000 Developer's Handbook, Volume I (Desktop Edition) in PDF (Adobe Acrobat) format. |
Download Chapter 3 (Working with Dates and Times) from VB Language Developer's Handbook in PDF (Adobe Acrobat) format. |
|
Download Chapter 6 (Creating Dynamic Data Structures) from VBA Developer's Handbook. The chapter appears, with few modifications, in Visual Basic Language Developer's Handbook, as well.
|
|
Recommended Downloads: |
|
|
|
Form scaling/resizing tool from Access 2000 Developer's Handbook, Desktop Edition (Volume I). Scale your forms so that they maintain the same "look" at any resolution, and resize controls as users resize forms. In addition, you can dock or float controls without resizing them. We've provided MDE (no source, just
executable) versions of the code for both Access 2000 and Access 97, for
your use in any application that you write. Please read the included PDF
documentation file carefully, for information you'll need to know in
order to make use of this utility. If you want the source code (and lots
of other good stuff), you'll need to refer to the book from which the
code is extracted. If you download this utility, and you haven't already
registered on this site, please do
so now by sending email. |
Trigeminal Software provides a number of useful Access utilities, including the TSI Form/Report to Data Access Page Wizard that you'll find included in Access 2000 Developer's Handbook: Enterprise Edition (Volume II). Drop by this site for a number of useful downloads, and lots of useful information.  |
|
| Add-ons: | |
| Download an HTML index for Access 2000 Developer's Handbook, Volume I, to be placed in the folder with the expanded example files. Provided by Access explorer extraordinaire, Dev Ashish. Dev also maintains www.mvps.org/access, the best Access FAQ site that we know of. | |
| Download an HTML index for Access 2000 Developer's
Handbook, Volume II, to be placed in the folder with the expanded example files. Again
provided by Access explorer extraordinaire, Dev Ashish. |
|
 |
Superior Software for Windows (SSW)
has created a suite of useful add-ins for Access. Drop by their site for
more information and to
download their utilities. They also maintain a site containing links
to other useful Access sites.
Drop by
for more information. |
|
Updates to Access 2000 Developer's Handbook, Volume I:
|
|
| Added 1/27/2000 | Chapter 7: Replacement for the TaggedValues class: Although the error in this class was small (it didn't handle tag/value pairs that ended with ";"), we also found some code that wasn't being used, and decided it was best to just supply the entire class for download. In addition, this class is used in several other chapters in the book--please download TaggedValues.cls, and copy it into any project you have that uses this class. |
|
Modified 3/13/2000 |
Chapter 9: Select Starting Label doesn't print correctly: Download update to report and class module that allows you to select the starting label on the first page for label printing. In the original code, the labels previewed fine, but didn't print correctly. This download won't help you unless you also have the original Ch09.MDB, from the book's CD, and will not work at all in any version of Access besides Access 2000. To use this update, download Ch09Update.ZIP, and unzip into a convenient location (it includes one file, CH09Update.MDB). Open CH09.MDB in Access 2000, and delete or rename rptSkipLabels and the SkipLabels class module. Then, import replacements for these two objects from CH09Update.MDB. (This update also includes the fix for Access not shutting down when you've selected Cancel on the popup form.) |
Added 12/20/99 |
Chapter 14: Replacement for basError: The adhHandleError procedure calls a helper function (DiskSpace) that fails on large hard drives. This replacement for basError in the CH14.MDB file (replace the existing basError with this one) fixes this problem. To use this update, download basError.bas, delete the original basError from Ch14.MDB, and replace with this new version. |
Added 8/15/2000 |
Chapter 16: Replacement for basRegistry: This module had a few errors, the most obvious was that the adhSetRegistryValueFromPath procedure didn't work for strings. Download the new basRegistry.bas, delete the original basRegistry from Ch16.mdb, and replace with this new version. |
| Added 3/28/2001 | Chapter 18: SQL Scratchpad revised as a VBA add-in, written in VB6: This add-in was described in the book, but never made it onto the CD. Download SQLSrcVB.ZIP here. |
|
Miscellanea:
|
|
Added 1/24/00 |
MsgBox builder add-in for Access 97: Ken originally wrote this for Access 95, and had updated it for Access 97 a while back, but it got lost on his hard drive. It will take a while to get this updated for Access 2000, because of the difference in Add-in architectures for code add-ins. Use the Access Add-In manager to add this tool, then right-click in the code editor to insert MsgBox statements as necessary. |
| Added 11/14/00 | QBF Builder for Access 97 and Access 2000. The Access runtime doesn't include the query-by-form feature provided in the retail version. This tool creates QBF forms for you, based on existing forms in your application. Although it's not nearly as full-featured as the built-in QBF, it's a good alternative for the runtime, and when you want to have complete control over what's going on. Read the included text file for information on using the tool. |
|
Old Chapters: These chapters originally appeared in Access 95 Developer's Handbook, but were removed from the 97 and subsequent versions, either to save space, or because the technologies became obsolete. In each case, the ZIP files contain the chapter in Word 97 format, and the chapter database in Access 95 format:
|
|
| Download "Queries and the Jet Engine", an introductory look at creating queries. | |
| Download "Providing an Elegant Interface", a look at various techniques for making your application's user interface as elegant and useful as possible. | |
| Download "Using DDE", an introduction to using DDE to communicate between Windows applications. We recommend doing anything in your power to avoid using DDE, but if you must, you must. | |
|
Access 97 Developer's Handbook Updates:
|
|
| Download a replacement for the Ch21.XLS spreadsheet from Chapter 21 of the Access 97 Developer's Handbook. | |
| Download a replacement for SQLScrat.mda (the SQL Scratchpad add-in) from Chapter 5 of the Access 97 Developer's Handbook. | |
| Download a replacement for Ch10.MDB (Access 97 Developer's Handbook) containing the full set of forms (missing from the book's CD). | |
| Download a text file containing the steps to fix the Windows NT file open dialog problem from the "Developing Multiuser Applications" chapters of the Access 95 and Access 97 Developer's Handbook. | |
| Download GLR32.DLL (Access 95 and 97 Developer's Handbook -- missing from the book's CD) | |
Articles by Developer's Handbook authors available online: |
|
| 200102 | The
New ASP 3.0 Server Methods |
| 200012 | Providing
Accessibility: Programming Windows Accessibility Features |
| 200011 | MSXML:
XML In Action (Getting Started with XML) (Code Only -- the article
is available in print, in Access-VB-SQL
Advisor, November 2000) |
| 200009 | Who
Wrote This? Digging Up File Version Information |
| 200006 | Screen
Resolution Resolved: Scaling VBA Forms to Match Screen Resolution |
| 200004 | Course
of Events: Part II |
| 200003 | Course
of Events: Part I |
| 200002 | WithEvents
Revisited: Creating a SpinButtons Class |
| 200001 | Implementing
Sorts: The Quicksort Algorithm |
| 199911 | Getting
WithEvents and Implementing a Nifty Incremental Search |
| 199910 | Office
2K Collections: Creating and Protecting Custom Collections |
| 199909 | A More
Powerful SQL: The Jet 4.0 SQL ANSI-92 Extensions |
| 199908 | Access
Form Control, Part II |
| 199907 | Access
Form Control, Part I |
| 199906 | External
Components, Part III (Global and Instancing Issues) |
| 199905 | External
Components, Part II (Debugging, Binary Compatibility, Events...) |
| 199904 | External
Components, Part I (Component Development with VB) |
| 199902 | INI
Files Exposed, Part II |
| 199901 | INI
Files Exposed, Part I |
| 199901 | Code Optimisation |
| 199812 | Creating
a ScreenInfo Class for VB6 or VBA6 |
| 199811 | Playing
with Tag: When New Properties Aren't Allowed |
| 199808 | Deconstructing
QueryDef, Part III (An Object Model for Jet QueryDefs) |
| 199807 | Deconstructing
QueryDef, Part II (An Object Model for Jet QueryDefs) |
| 199806 | Deconstructing
QueryDef, Part I (An Object Model for Jet QueryDefs) |
| 199805 | Call
Me Back: Using Callbacks with the Windows API |
| 199802 | Retrieving
Screen and Window Information |
| 199801 | Advanced Class Modules |
| 199711 | Keyboard Class:
From Windows API Chaos to VBA Class Module Calm |
| 199710 | Office 97 Shared
Components |
| 199708 | Simplify and Accelerate
Your Development Process |
| 199706 | Access Answers:
Closing All Open Forms and Handling Misleading Report Errors |
| 199701 | Replacing API Calls that
Manipulate Menus |
| 199701 | Writing Code
for International Use |