Navigation:  »No topics above this level«

vb123 Knowledge Base

Return to chapter overviewNext page


Front page of a Smart Access Magazine

In this website you will find 100s of the best Access articles by icons of the industry such as Peter Vogel, Doug Steele, Ken Getz etc  all for free.
We also offer a premium offering 'TheCollection' that includes all Smart Access articles and associated samples written from 1996-2006. Read about and purchase The Collection
Garry Robinson - The manager of vb123 and Microsoft Access MVP 2006-2013
Garry's latest program called 123 is now out there. Read and download it here  



Recent posts are here         Follow on Twitter @smartaccess


Access 2013 Web Apps

Tips and Tricks

Demonstration of an Access Web App

How to do an Access Web App Backup


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

Data Modelling with Access and Visio

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



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

Supporting Custom Sort Orders

Watch Out ~ Query Behaviour of Control Break keys


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

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


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



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




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



New Topics

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


Purchase Smart AccessFirst page of this magazine
All the 400 articles
can be purchased here.



video  YouTube - Videos


Access Web Apps Talk Videos inc

1 - Introduction to Access Web Apps
2 - Access Web Apps Demo running on an iPad
3 - Creating your First Access 2013 Web Apps
4 - What did we learn from the 1st App and Security Tip No.1
5 - Access desktop database connecting to the cloud demo
6 - Connecting Access desktop database to the cloud
7 - Building a secure menu and an admin button



All the Editorials have been classified here


The VB123 Professionals can help you
Gold 2006 2005 2004  Silver 2003 2002 2001 2000  Bronze 1999 1998 1997 1996  Toolbox 2009 and the 2012 articles


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

One Huge Leap Toward SQL Server
!An Access Explorer for SQL Server Tables

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

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


Pivots and Charts

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


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



FMS Total Visual Code Tools 2002

FMS Access Speller 2000+

FMS Total Access Analyzer 2000

Book Review: Grover Park George on Access
The Access Developer's Bookshelf


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



The Easy Approach to Code Reuse

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

Keeping up Appearances
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

Track Your System File Versions

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



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


.Net and SharePoint and Tricky Stuff

Visual Basic .NET Development
Access 2003 and Windows SharePoint Services

Access: The .NET Report Writer

Managing Access from .Net

Building an Access Add-In with Dot Net

Select * From SharePoint Where db = ‘Access’

ADO.Net Revolution: Data Adapter

Service-Oriented Access

Web Service Wannabes_2

Accessing the Internet

Service-Oriented Access