Tools and Utilities
	Publications
	Forums & Newsgroups
	White Papers & KB Articles
	Other Resources

Tools and Utilities

FMS, Inc. World-class Access add-ins and utilities

 

Black Moshannon Systems Speed Ferret search-and-replace utility

 

	Code-VB Help Generator Neat tool to give you a jump start on building HTML help files for your Access Application.
	SnagIt The best screen-capture and editing software.

Top

Publications

Smart Access Articles and sample files for the intermediate / advanced user

 

Data Based Advisor The successor to Access / VBA / SQL Advisor - some good articles on Access for sale

Top

Forums & Newsgroups

	Support Groups on Yahoo: MS Access Professionals Access Dev MS Access
	Microsoft Newsgroups Check out the Access and SQL Server newsgroups organized by topics.  Answers by MVP designates (including me!) and other experts.  Find Access under Desktop Applications and SQL Server under Servers.
	Utter Access forum Microsoft® Access, Excel, Word, Outlook®, Visual Basic®, SQL Server®, Office online help discussion forums.

CompuServe MSDevApps forum Expert advice from Team Access.  You don't have to be a member of CompuServe to post questions and browse answers as a "guest."

Top

White Papers & KB Articles

Math calculation A detailed white paper on math calculation problems in Access.

 

Is your database hopelessly corrupted? Get help here (Access 97 version with links to 2000 and XP): http://support.microsoft.com?kbid=279334

 

Common functions not working?  (Format, Date, etc.) Get help here: http://support.microsoft.com?kbid=194374

 

DLLs not registering during a Runtime install? Get help here: http://support.microsoft.com?kbid=174217

 

Confused about Access Security? Get help here: http://support.microsoft.com?kbid=254372

Top

Other Resources

	Access Team Blog All the latest news from the Microsoft Office Access development team
	The Access Junkie Great tips from Jeff Conrad - the "Access Junkie"

FMS Home Page Lots of other goodies besides the white papers and utilities listed above.

 

	For Mere Mortals Check out other books in the Mere Mortals series here.
	MCW Technologies You'll find the authors of the Sybex "Developers Handbook" series here!

 

The Access Web Chock full of goodies contributed by Access MVPs.  You'll find a ton of hot tips gleaned from the newsgroups here.

 

ACG Soft Tips, Freeware, and cool Access add-ins here.

 

	MVP Web Sites Links to the web sites of other Microsoft MVPs.
	Steven Leban's Home Page Cool code from another Access MVP.
	Allen Browne's Access tips Good info for beginners and advanced developers.
	Tips from Tony Toews Another great resource from an Access MVP.

Top

 

Downloads

	Corrected code for the NotInList event procedure for the cmbUserID combo box on frmSignon in the Housing sample database for both Microsoft Office Access 2003 Inside Out and Microsoft Office Access 2007 Inside Out: HousingCmbUserIDNotInList.txt
	Confused about SQL in Microsoft Access?  Download this Appendix from Microsoft Office Access 2003 Inside Out to get all the details.

UnderstandingSQL.doc
 

	Longing for the wonderful help files that were available with Access 97?  Download the file below, unzip it into a folder, and set a link on your desktop to acMain80.hlp. ACC97hlp.zip
	Additional info for SQL Queries for Mere Mortals: We added specific instructions for working with SQL Server to the second printing of the book.  To download the new Appendix D, go to: AppendixDDoc.zip
	Sample files for Microsoft Office Access 2003 Inside Out In Access 2000 format: Contacts2000.zip Housing2000.zip WeddingList2000.zip
	Golf Tournament sample database from Running Microsoft Access 2000 (133K): GolfTournament.zip
	Form that emulates the Database window (Access 2000 format - 25K): DBContainer2000.zip

 

Calendar sample database Access 97 format (92K): Calendar.zip

            This database demonstrates how to construct a common 
            Calendar form that you can call from anywhere in your application.

          NOTE: All Access 97 databases can be converted 
            to Access 2000 format.

Books sample database from Running Microsoft Access 97 (1,014K): Books.zip

Entertain sample database from Running Microsoft Access 2000 (738K)

This is an updated version that shows how to build a "booking" calendar to make it easy to see what dates are booked or available for a given group or club.  See frmClubCalendar and frmGroupCalendar.

EntertainWCalendars.zip

	Entertain sample database from Running Microsoft Access 97 (558K): Entertain.zip
	College sample database from Running Microsoft Access 97 (499K): College.zip

 

Wedding sample database from Running Microsoft Access 97 (64K): Wedding.zip

Top