vb123 Knowledge Base

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
 
 


 

 

Recent posts are here

 

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

 

Tables

What's in a Table?

Managing Lookup Tables
Managing State Transitions

Everything About AutoNumbers
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
 

Queries

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

 

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
Eventful Formatting for Access Forms

Positioning a Record on a Form

Using Invisible Forms to Track Users

Expanding and Contracting Forms
 

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

 

Reporting

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

Single Sourcing Your Help

Does This File Register with You

Getting Data From Access Into Excel

 

Outlook

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 in the Access 2007 Contacts Template

Outlook Linked Tables and a Flutter On The Stock Market

 

Macros

AutoExec Macros

 

Performance

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

 

 

DAO

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

Setting Up Right Click Menus for Access 2007

Creating Charts/Graphs in an Access 2007 Database

Searching For Text Anywhere In A Database
 

 

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

 

 
 
Editorials

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

 

Access Data Projects

Access 2002 Data Projects for Developers

Using Stored Procedures in ADPs

Moving ADP's Between Machines

Starting the Interface with Access Data Projects
Creating SQL Server Tables with Access Projects

Starting the Interface with Access Data Projects

Starting the Interface with Access Data Projects (part 2)

Making Changes in Access Data Projects

 

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

 

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
 

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

 

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
Single Sourcing Your Help

 

Reviews

FMS Total Visual Code Tools 2002

FMS Access Speller 2000+

FMS Total Access Analyzer 2000

Product Review: Access 2003 Conversion Toolkit

Access 2002/XP for Developers

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

Access Replication

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

 

VBA

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

 

 

 

ADO
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

 

.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