The Invalid Use of Nulls error message is common in VBA code when using Microsoft Access. Find out how to write code to deal with it.

Is Microsoft Access right for you? Here are several reasons why I often recommend Access to my clients.

Not sure if you need one table or two in Microsoft Access? Here's a guide.

When to use a subforms in a Microsoft Access database

Porting Microsoft Access tables to SQL Server

Dealing with the "database is in an inconsistent state" error message, and other symptoms of Microsoft Access corruption.

In recent blogs, I've been discussing the various ways you can connect data between Microsoft products. So far, I've covered Access,...

Linking to data in SQL Server from a Microsoft Access database

Create a Microsoft Access table that is linked to an Excel file.

I’ve been covering the use of Microsoft Access tools to clean your Excel data for the past few weeks. Today is the final entry in that...

Use MS Access to find duplicates in your Excel data

Use MS Access to clean numeric fields that contain text.

Use MS Access to clean phone numbers in your Excel data.

Excel data can be messy. Use MS Access features to clean it up.

Use an append query to add Excel data to an Access table

Microsoft Access allows you to quickly create forms for viewing and editing your data. One issue you may have run into with forms is that...

Excel or Access? Microsoft has lots of great tools, and in most cases, it’s pretty clear which you need to use. If you need to write a...