Uh oh!  Coffee running low, please...
Want to know what I am doing here?  Click me...
Tips found in this section are a collection of information that was developed in-house, read from books and found in forums and newsgroups. We only ask that you acknowledge the original author when using their code by leaving (or including) the tag line indicating the source of the code. Thank you!  (Tip! Always test first on a copy of your database!)
= Click to download file (An unzipping program and Micosoft Access is required) 
= New or updated  (All sample downloads in Access 2007 or higher unless bolded.)
There is no free support for the tips offered on these pages; use at your own risk. (Tip! Always test first on a copy of your database!)  You may eMail for broken links or corrections, however, (please) no personal eMails for private assistance or support. You will be charged if you send unsolicited eMail requesting support.

For free support or assistance please visit one of the many Forums, a few of which are listed below:
The difficult I do immediately, the impossible takes a little bit longer
= 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 below, it's to indicate that the line below is a continuation and that the code should be written as a single line.  So this..
= Data Model
Last modified on  September 10, 2018
© 2011-2018 Regina Whipp
Site designed and maintained by Regina Whipp
Privacy Statement
<blah, blah, blah, blah,
blah, blah>
...should be...
<blah, blah, blah, blah, blah, blah>
Option Groups

(Multiple examples)
This site uses cookies to collect data on usage. By continuing to browse this site you consent to this policy. Find out more here.
Print Full or Partial Sheet of Same Labels
Print One or More Labels for One or More Clients (Records)
Multiple copies of 1(one) Report using a Cartesian Query
  Keep Main Report/Subreport Records Together
  Add your Report Name to Page Footer
  Don't open Report if No Data
Multicolumn Report with Images
Add *Continued...* to a Multicolumn Report
  Filtering Reports
  Data Models
Templates (for project managment)
Restaurant Reservations
Property (or Rental) Management
Jobs (aka: Work Orders, Projects)
Training with Attendance
Products (Shoes and Clothing)
Clubs (or Associations)
Purchase Orders with Inventory
Hotel Bookings
Real Estate
Grocery List Maker
Recipes with Grocery List Maker
Parking Lot
Appointments (i.e. Salon)
Damage Investigations
Call Center
My Naming Conventions
Where are the Options?
Options for Current Database
Object Designers
Trusted Locations
Repair (or Remove) MISSING or Broken References
Export Specifications
Import Specifications
    Navigation Pane Options
    Setting up a Model Database
    Default Buttons and Legend
    Set Subdatasheet to [None] (for Access 2003 and higher)
    My Database Standards
    So you're ready to Upsize
    Circular Reference (well, kind of)
    Creating a Settings table
    Not_In_List Events
Help (Show Help and/or Tips in your Database)
    Handling Attachments
Creating a Multi-Value field using Alphabet
Copy Fields Down from above Record
Loop thru Recordset and OutPutTo seperate .RTF or .PDF
Modified Spell Check
Code Snippets
Create a Custom ID
Add a custom Record Count
Limit the amount of Records that can be entered in a Continuous Form
Change Control Source of Combo Box based on previous Combo Box
Sort Records using Labels
Traffic Light changes colors based on conditions
    Loop while renumbering 2(two) Columns
    Create a Table with Dynamic Field Names
    Snippets for Exporting to Excel
Selecting an Excel Worksheet from Access
    Log Field Changes
    Log Record Deletions
    Check for Duplicate Values
    Send eMail to Multiple Recipients (using DoCmd.SendObject)
    Update Database Frontends
    Confirm Record Count after Excel Import
    Excel Manipulation from Access
    Exporting clickable Hyperlinks
    Another (Blog) post Sequential Numbering
    Combining Fields
    Count Characters
    Cancel Save in a Bound Form
  Automatically send eMail Notifications
  Looping Records to Send eMail
Query Joins
Using Parameters in a Crosstab Query
Action Query Errors
OrderBy OR Order By
Memo field is truncated when exported to Excel
Append and/or Update Data to Table Created Dynamically
To Few Parameters Expected n
Command Line Switches
Customize the Quick Access Toolbar
Customize Toolbox Controls
Access Specifications
Database Folder Set-Up
Move Selection Up/Down in a List Box
  Add Image and Text to Toggle Buttons
Option Groups
Access World Forum My favorite since the NNTP's went away!
Microsoft© Answers Forum
Microsoft© Access for Developers
Google Groups ~ MS Access
Utter Access
Yahoo! Groups ~ MS Access Professionals
Eileen's Lounge
Simple Bar Chart using Shapes
    Switch Windows (for Access 2007 and above)
Let your Client customize the form labels
Linking Subforms to an Unbound Control(s) on Main (Parent) Form
Customize your Main Menu or Switchboard
Auto-Add new child records when adding new record on Main Form
Simulate a Drop Down box (not a Combo Box) as seen on Web Pages
Implement a Log-On form to control what the User sees
    Make Controls resize with a form
    Sort using Labels
    Custom Navigation Buttons
    Custom Record Count
    Assign *Permissions* based on Users Levels
    New User Form
    Add Logo to Forms and/or Reports
    Conditional Row Shading on a Continuous Form
Highlight Current Record
    Navigate a Continuous Form like Excel
    Filtering with Forms
Splash Screen with Progress Bar
    Appointment Collision Check
    Add *Favorites* to a Continuous Form
    Custom Record Selectors
  Searching Records
  Combo or Text Box
  Combo Box with a Text Box
  Command Button with Combo and Text Boxes
  Search Form
Data Models