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
Webmaster
<blah, blah, blah, blah,
blah, blah>
...should be...
<blah, blah, blah, blah, blah, blah>
Searching Records

(Multiple examples)
Feedback
This site uses cookies to collect data on usage. By continuing to browse this site you consent to this policy. Find out more here.
Reports
 
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
DVD
Jobs (aka: Work Orders, Projects)
Complaints
Training with Attendance
Products (Shoes and Clothing)
 
 
Tasks
 
 
Publications
 
 
Clubs (or Associations)
 
 
Purchase Orders with Inventory
 
 
Hotel Bookings
 
 
Real Estate
 
 
Recipes
 
 
Grocery List Maker
 
 
Recipes with Grocery List Maker
 
 
Inspections
 
 
Parking Lot
 
 
Appointments (i.e. Salon)
 
Damage Investigations
 
Call Center
Design
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
VBA
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
    fncLockUnlockControls()
    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
    ValidateData()
    ClearClipboard()
    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
 
SQL to VBA
  Cancel Save in a Bound Form
  Automatically send eMail Notifications
  fFindBookmark()
  Looping Records to Send eMail
  fxlFindReplace()
Queries
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
General
Command Line Switches
Customize the Quick Access Toolbar
Customize Toolbox Controls
Access Specifications
Database Folder Set-Up
Controls
Move Selection Up/Down in a List Box
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
Forms
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
Forms
Queries
VBA
Design
Data Models
Reports
Controls
General