Code to “fix” a 2007 .accdb file that has been opened with 2010 or 2013 and one or more forms or reports edited. Editing a form or report in 2010 or 2013 potentially adds new controls that are not supported in 2007. Import the enclosed form into a backup of your “broken” database and follow the instructions to first export objects. Then use the same form in a new blank 2007 database to import the “fixed” object descriptions.
Installation instruction file for the sample files for SQL Queries for Mere Mortals, 3rd ed.
Sample files for SQL Queries for Mere Mortals, 3rd ed.
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
- Contacts 2007 database
The Contacts database from Microsoft Office Access 2007 Inside Out
- Building Microsoft Access Applications sample files
Sample desktop files for this venerable book published more than 14 years ago – but still full of good stuff!
Confused about SQL in Microsoft Access? Download this Appendix from Microsoft Office Access 2003 Inside Out to get all the details.
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.
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, click the link above.
- Sample files for Microsoft Office Access 2003 Inside Out in Access 2000 format:
Golf Tournament sample database from Running Microsoft Access 2000 (133K)
Form that emulates the Database window (Access 2000 format – 25K)
Calendar sample database Access 97 format (92K)
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)
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.
Entertain sample database from Running Microsoft Access 97 (558K)
College sample database from Running Microsoft Access 97 (499K)
Wedding sample database from Running Microsoft Access 97 (64K)