Tips and Techniques for Using and Validating Microsoft Access Combo Boxes

Jump:

Search:

Microsoft Access Developer Center

Strategic Overview

Microsoft Access within an Organization's Database Strategy

How many simultaneous Microsoft Access users?

Blaming Microsoft Access instead of the Developer

Microsoft Access vs. Excel

Best Practices

Taking Over Legacy MS Access Databases

100+ Performance Tips

Winner of Every Best Access Add-in Award

Split Database Architecture for Multiuser

Favorite Features Added After MS Access 2003

Table Design

Designing Primary Keys

Field Type Consistency

Table Normalization Tips

Taking Time into Account

Temporary Data

Transposing Data

Set AutoNumber Starting Number Other than 1

Avoid Unnecessary or Duplicate Indexes

Query Design

Form Design

Form Tips and Mistakes

Form Navigation Caption

Using a RecordsetClone

Synchronize Two Subforms

Late Bind Tab Subforms

Subform Reference to Control Rather than Field

Tab Page Reference

Shortcut Keys

Combo Box Top Tips

Properties and Validation

Select First Item

Cascading Combo Boxes

Zip, City, State AutoFill

Report Design

Suppressing Page Headers and Footers on the First Page of Your Report

Add the NoData Event

Annual Monthly Crosstab Columns

Design Environment

Adding Buttons to the Quick Access Toolbar

Collapsing the Office Ribbon for more space

VBA Programming

Using Nz() to Handle Nulls

Avoiding Exits in the Body of a Procedure

Debugging Keys

Setting Module Options

Math Rounding Issues

Source Code Library

Royalty Free VBA Modules

VBA Error Handling

Error Handling and Debugging Techniques

Error Number and Description Reference

Basic Error Handling

Pinpointing the Error Line

Performance Tips

Deployment

Disable Design Changes

Broken References

Simulating Runtime

Missing Package & Deployment Wizard

System Admin

Disaster Recovery Plan

Compact Database

Compact on Close

Database Corruption

Decompile Database

Bad DLL Calling Convention

Converting ACCDB to MDB

Cloud and Azure

Cloud Implications

MS Access and SQL Azure

Deploying MS Access Linked to SQL Azure

Visual Studio LightSwitch

LightSwitch Introduction

Comparison Matrix

Additional Resources

Microsoft Access Help

MS Access Developer Programming

More Microsoft Access Tips

Technical Papers

Microsoft Access Tools

Connect with Us

This page has moved to: Tips and Techniques for Using and Validating Microsoft Access Combo Boxes

Resources for Microsoft Access Forms, Combo Boxes and Tabs

Contact Us l Web questions: Webmaster l Copyright © FMS, Inc., Vienna, Virginia
Celebrating our 26th Year of Software Excellence