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.

Linking to data in SQL Server from a Microsoft Access database

Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.

Creating links to Microsoft Access data in your Excel worksheet.

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

Tips for making your Excel data import smoothly into Access

Just about all companies rely on electronic data these days, but not all companies can quickly and easily access their data. Here are a...

If you’ve ever written VBA code in Excel, Access, or any of the other products in the Microsoft Office suite, you may already be familiar...

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...