Tips found in this section are a collection of information that was developed in-house, read from books and found in newsgroups. We only ask that you acknowledge the original author when using their code by including the tag line indicating the source of the code, where noted. Thank you!

= Click to download file (An unzipping program is required) 
= This means the file and/or has been updated or is new
The difficult I do immediately, the impossible takes a little bit longer.
Customize the Quick Access Toolbar   (Access 2007 and higher)
How to use Windows System Colors   (Access 2003 and earlier)
Where are the Options?   (Access 2007 and higher)
Options for Current Database   (Access 2007 and higher)
Trusted Location   (Access 2007 and higher)
Export Specifications   (Access 2007 and higher)
Import Specifications   (Access 2007 and higher)
Forms

Queries

VBA

Design

Reports

General

Make Controls resize with a form  (Access 2007 and higher)
My favorite since the NNTP's went away!
(All samples in Access 2003 unless otherwise specfied.)
Switch Windows  (Access 2007 and higher)
Navigation Pane Options  (Access 2007 and higher)

"Little else matters than to write good code."

Karl Lehenbauer

= Sometimes code lines can be very long!  Where as, I have to break a line of code to have it fit better on a page.  So when you see the symbol, to the left, it is to indicate that the line below is a continuation and that the code should be written as a single line.  So this..

If you found this site helpful then...
= Data Model
Data Models

Last modified on  July 26, 2014

© 2011-2014 Regina Whipp

Site designed and maintained by Regina Whipp
...for old (and new) tips.
or
= Click to provide us feedback  (available on all Tips pages)

<blah, blah, blah, blah,
blah, blah>

...should be...
<blah, blah, blah, blah, blah, blah>
Is there a Data Model you would like to see here?  Click the ballon...
Object Designers (Access 2007 and higher)
Jobs  (aka: Work Orders, Projects)

Send eMail to Multiple Recipients (using DoCmd.SendObject)

Set Subdatasheet to [None] (Access 2003 and higher)

Complaints  (Access 2007 and higher)

Training with Attendance  (Access 2007 and higher)

Products (Shoes and Clothing)  (Access 2007 and higher)

New Data Model!

Tasks  (Access 2007 and higher)

Multicolumn Report with Images  (Access 2007 and higher)
Publications  (Access 2007 and higher)
Clubs (or Associations)  (Access 2007 and higher)
Purchase Orders with Inventory  (Access 2007 and higher)
Hotel Bookings  (Access 2007 and higher)
Recipes  (Access 2007 and higher)
Recipes with Grocery List Maker  (Access 2007 and higher)
Grocery List Maker  (Access 2007 and higher)
Real Estate  (Access 2007 and higher)
Inspections  (Access 2007 and higher)
Inspections  (Access 2007 and higher)
aaaaaaaaaaaaiii