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 indicated.)
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
= Data Model available for download
Last modified on   November 8, 2019
© 2011-2019 Regina Whipp
Site designed and maintained by Regina Whipp
Privacy Statement
Webmaster
fAmortization()
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
    Ranking Reports Using Shapes
    Print Constant Number of Lines (or Add a Constant Number of Lines)
 
Custom Page Header
  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
 
 
Incidents
 
Tour Agency
 
Training (with Cirriculum)
 
Calibration
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
    Database Design Tips
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
   
Add a Filter to Specific Columns
   
Make Columns AutoFit to the Values Inserted
   
After Exporting to a Template Rename to Excel Workbook
   
Copy/Paste Cell Values, such as, Formulas
   
Make sure Column maintains its Date/Time Format even after Export
   
Insert a Worksheet from One Workbook into Another Workbook
   
Set the Vertical Axis
   
Add Image (Logo) to the Worksheet
    Log Field Changes
    Log Record Deletions
    Check for Duplicate Values
    fValidateData()
    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()
    fMouseOverCurrent()
 
fHighlightRequiredControls()
    Check if Table Exists
    fAmortization()
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
    Add Image and Text to Toggle Buttons
 
Option Groups
 
List Box Simulated
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
    Drill Down (for Continuous Forms)
Forms
Queries
VBA
Design
Data Models
Reports
Controls
General