<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«


"In this website you will find 100s of the best Microsoft Access articles all for free. " Garry Robinson - Microsoft Access MVP 2006-2017

On a Phone:  SWIPE RIGHT  to see a Menu of all articles in this website



Topics Follow and there are a lot


Office365 and PowerApps

Excel Online - File types and other basics

Online Data Doesn't have to be Dumb

Adding Data Filters

Excel Online - a list of references
Using Excel Sub-Totals for Reporting

Power Apps - First Try

Controlled Emails Using PowerApps




Try out Garry's new website




Project Management & Data Modelling

Data Modeling for the Access Newcomer, Part 1

Data Modeling for the Access Newcomer, Part 2

An Access Project, Part 1: Requirements

An Access Project: Data Modeling

An Access Project: Creating a Great Report

Editorial: Working in the Real World

The ABCs of Requirements Management for Access

The Trouble with Normal
Learn to Use "Relationship" and "Normal" in the Same Sentence!

Parts 2-5 Normalization and Management Advice

Explore Your Data With SubdataSheets

Survey Database with Option Boxes



What's in a Table?

Managing Lookup Tables
Managing State Transitions

Everything About AutoNumbers

Switching Primary Indexes

Field Index Gotchas
Do More for Less

Decomposing a Badly Designed Table
I've Got Plenty of Nothing

200302 Combining Tables


List Boxes and Combo Boxes

Tricks With Combo Boxes

Drilling with Combo Boxes

Creating Paired Listbox Controls, Part 1
Creating Paired Listbox Controls, Part 2

Use Classes to Enhance List and Combo Boxes

Your Listbox-Filling Options

Get More From Your List Boxes

Access Answers: Let me check my list…

Intelligent Combo Boxes


Managing controls, check & text boxes, buttons etc

Drag and Drop in Access

Dynamic Checklists

Working with groups of controls

We Get Letters

Managing Margins Of Text Box and Label Controls

Alternative Buttons

From Zoom Box to Custom Dialog

Validate input such as ZIP codes and postal codes

How can I change the size of the checkbox on my form

Find controls where the Procedures have gone missing

Ordering Controls, Fixing Bugs, and Speeding Up Remote Databases
Choosing Options
Exportiing all tables to text



Access Answers: All in the Family

Computing the Median (Again)

Auto-Generated Update SQL

Making the Grade

Simplifying Queries

Simplifying Complex SQL

Access Subquery Techniques

Combining Tables using Union Queries

Tame the Crosstab Missing Column Beast

Subquery Notes

You Can Do That with Datasheets?

SQL Without Joins

Doing Two Things at Once

Case Study: Researching Data

Querying a Customer Survey

Query Queries

Give Me a Call

Putting Subqueries to Use

Consolidating Your Data With Queries

SubQueries to the Rescue

Query-Based Applications

Manage your Update Tables with Query Lists

Exploiting the Query Manager

Flexible normalization and denormalization: Case 2

Simplifying Complex SQL

Navigating Through Recursion, Part 1

Record Locking and Updating Efficiencies

Locking Code

Demystifying JOINs

How To Create A Crosstab Query

Supporting Custom Sort Orders

Watch Out ~ Query Behaviour of Control Break keys

Numerical Sequence

Distinctive SQL
All Things Not Being Equal
The Return of Working SQL


Front page of a Smart Access MagazineAd: Buy our Smart Access PDFs and Downloads


For searches, click on the Menu Button then use the Search button or Index Key button at the top of the page


Forms and Menus

Flexible Normalization and Denormalization of Data

Explorer Forms with a Single Keystroke

Closing All Open Forms

Tip: Closing All Forms

Breadcrumbs, or How I Learned to Love the Switchboard

Dynamic Menus

Conditional Formats on Access Forms

Listing Conditional Formats

Applying Multiple Formats
Eventful Formatting for Access Forms

Positioning a Record on a Form

Using Invisible Forms to Track Users

Expanding and Contracting Forms

Setting Up Right Click Menus for Access 2007

Track Changes Made To A Database

Sub Forms

Control Your Subforms

Let Your Users Sort it Out

Zoom, Zoom, Zoom

Accessing Subforms

Using List Regions with Many-to-Many Relationships
Undo in Sub Forms

You Can Do That with Datasheets?

The Sub-SubForm Youve Always Wanted

From Zoom Box to Custom Dialog

Invisible Forms: Park Your Global Values Here

Out of Sync Cascading Combo Boxes and Subforms

Popup Notification

MS Access Time Control



Making Your Access Reports Dynamic

Things about Reports that you probably dont know

Reports: Multiple Columns and Subreports

Creating a Great Report

Saving Reports is a Snap

Printing Pesky ZIP Codes and Set the Start Page Number

How to Pad Access Reports With Blank Rows

Getting in Line

Dynamic Grouping In Reports

Dot Leaders and Table Of Contents Reports

Outputting Flexible Data

User Interface Standards-Reports


Combo Boxes and List Boxes

Let me check my list…
Tricks With Combo Boxes
Drilling with Combo Boxes
Creating Paired Listbox Controls, Part 1   and Part 2
Use Classes to Enhance List and Combo Boxes
Your Listbox-Filling Options
Get More From Your List Boxes
Tip: The IN Crowd
Lookup Tables – Improve data quality in your database

Access Controls

Working with groups of controls

Make Buttons Look Modern

Dynamic Checklists

Managing Margins Of Text Box and Label Controls

Alternative Buttons

From Zoom Box to Custom Dialog

Validate input such as ZIP codes and postal codes

Giving Your Access Form Controls Web-style Behaviors


MS Word & MS Excel

Excel Automation

Build Word 2003 Docs with XML

Four Ways to Merge to Word

What Access Developers Need to Know About Word

Outputting Flexible Data

Excellent Analysis

Creating Spreadsheets Without Excel

Extending Access Reports with Word and HTML
Use Excel to Analyze and Graph Access Data

Creating Histograms Using Access

Does This File Register with You

Getting Data From Access Into Excel

Building an Access Database From A Spreadsheet

Microsoft Word Automation - Bookmarks




Manipulating Outlook Data from Access
Consolidating Outlook Contact Data
The Jet 4.0 Exchange/Outlook IISAM
Send Data Without Attachments

Outlook Synchronizing and Internet Maps

Outlook Linked Tables and a Flutter On The Stock Market



AutoExec Macros

Closing a database at a certain time



Access Database Performance
Is The Query Compiled?

Focus on Popular Objects to Speed up an Access 2007 Database

Access Answers

Access Efficiency

Working SQL: Efficient SQL

Cleaning Up An Access Database

Optimize your Access/Jet applications



Everything About Using Parameters from Code

DAO verses ADO - DAO isn't Done Yet

Properties Without Fear

The PrivDBEngine Object

Embedded quotes in SQL statements

Is SQL Better than DAO for Creating Tables and Indexes

Altering SQL


Other Topics

Building vb123.com with Azure

Drop Box for MS Access

Outlook Linked Tables and a Flutter On The Stock Market

Searching For Text Anywhere In A Database
The Full Keyword List is Here


video  YouTube - Videos




First page of this magazine

All the 400 articles
can be purchased here.



Installation, Setup and Access User Interface

Remote Updates of a Back-End Database

Using the Access 2003 Database Window

Extracting Your Access Configuration

Click Savers
Packaging Access 2003 Solutions


SQL Server etc

Client-Server Utilities

Access Answers: Client/Server Issues

Client/Server Development with Access

Migrating Access (and Outlook Data) to SQL Server

Improving on VBA with Transact-SQL

Using Access to Prototype for SQL Server

Working with or without a DSN
Preparing To Upgrade Access Tables to SQL Server 2005/2008

Using Triggers

Exercising Options


Protection and Security

** Access Protection Measures

Microsoft Access Passwords, Workgroups and ADO
Real-World Access Security

Dual Control

Encrypt Your Data
Restricting Who Can Use Your Database

Manually Changing Startup Options

Secure Microsoft Access Encryption in Access 2007

Access Protection Ideas

Access Version Control

The LDBView Utility


Pivots and Charts

Building Your Own Data Mining Interface

Create Dynamic Chart Applications

PivotTables in Access

Programming Pivot Tables for Access Forms

Analyze Your Data in Space

Creating Histograms Using Access

Graph to GIFs and Powerpoint

Easy as Pie

Creating Charts/Graphs in an Access 2007 Database

Setting Up A Scatter ( XY ) Graph In Microsoft Access
Use Access 2007 to Get Started in Data Mining

Exploring Your Data Visually


Managing Quality, Bugs and Errors
Playing Tag with Validation

Access Answers: But it Worked Yesterday!

Logging Access Startup Details and Version Control

Soundex: "Close" Only Counts in Horseshoes

Handling Misleading Report Errors

Making History

Error Trapping with a Code Builder

No More Write-only Code

List Boxes, Access Bugs, and More

Cleaning Up An Access Database


Imports, Exports and XML

Exporting and Recovering Programming Objects

Access 2003 and XML

Put XML to Use in Access 2000+

Taking Outlook and XML to Task

Access to XML

Using FTP from Access Applications

Save Yourself Some Work

Data export made easy

Web Services for the Access Developer

Matching Data for Analysis


User Interface and Documentation

Access User Interface Design

Six Rules for Effective User Interface Design
Handling Visual Complexity

Navigation Through Recursion

The Form’s the Thing

Access Application Development Documentation

Everything Doesn't Happen at Once: Loosely Coupled Events

Implementing Proactive User Assistance
Getting More Out of Access 2003 Help

Improving Data Entry Feedback with Sound
Cuing Banners

Access Answers: Talk to Me

Access Interfaces: Handling Price Ranges



Access Answers about a variety of issues

Forms, Sorting Reports, and Dating Errors

Want Machine Information?

MP3 - Sounds Good to Me

SQL Discrepancies, List Boxes, and Dating

Say UNC, API Calls, {CAPSLOCK}, and Time

Bar Code Basics

These Are a Few of My Favorite Things

How to Convert Case and Calculate Total Time
Peter Comes to Bat

An Average Column: I Mean, What Mode is Your Median

Top Values, Hierarchical Lists, Equivalent Strings

Loosely Coupled Events COM+

Managing Cursors, Quotes, Subforms, and Missing Data


Windows Controls and Message Boxes
Making Your Applications Talk
I've Just Got to Get a Message to You

Treeview: Building Explorer-style Forms

Taming the Treeview Control

Displaying Hierarchical Data in a TreeView

File Open Dialog Options

Giving Your Access Form Controls Web-style Behaviors

ActiveX Controls and Forms

An Assortment of Windows API Tricks


Dates and Time

About Time

When DateAdd Doesn't

Date Tricks

Fuzzy Dates

Working All Day
Did Someone Say Holiday
Access Developer Needs a Date

Dates, Data Access, and Presentation



Objects for the Database Developer

Using Dynamic External Event Procedures

Preventing Reference Failures

Two Functions You Don't Use Enough

Embedded quotes in SQL statements

“Just-In-Time” Queries
Handling Print Layout
More Dragging Around

Dealing with File Names

The FileSystemObject

Accessing Spatial Data, Part 1 Part 2 Part 3
Peter Comes to Bat - Handling Quotes, Weekdays
Hide Your Input, and it’s Pretty Common

User Preferences, Toggles, and Rocket Science
Choosing Directories: Harder Than It Sounds
System Tables, Mixing Versions

More Favorites

Access Answers: Shortcuts, Quotes, and What Have I Done?

Microsoft Access Forms—All Class

Shrink-Wrapped or Do-it-yourself Queries

Shuffling Lists of Numbers, Ranking, and Control-Level Validation

Cool Tricks for the Sophisticated Developer

Advanced Data Shaping

Two Debug Tricks
Stop Compile Error Prompt in VBA

Find Record Lookup Wizard

An Alternative to the BrowseTo Command

Read this to feel PtrSafe about Office 64 Bit compatibility



Preview - Active Data Objects

An ADO Tutorial: What is ADO?

An ADO Command Factory for Stored Procedures
Using the ADO Command Object

Using the ADO Objects Effectively

Advanced ADO Data Providers

Comparing DAO and ADO Recordsets

Persistent Recordsets in ADO

Accessing ADO

Advanced Data Shaping

ADO and Subform Performance


Active Data Objects

An ADO Tutorial: What is ADO?

An ADO Command Factory for Stored Procedures

Using the ADO Command Object

Advanced Data Shaping

Objects for the Database Developer




All recent posts are here        


Hunting by year, use these links

2006 2005 2004   2003 2002 2001 2000  
1999 1998 1997 1996  and the newer articles can be found in Toolbox articles

Follow on Twitter @smartaccess



The VB123 Professionals can help you