Power BI can be set up to automatically refresh reports, grids, pivots and charts when a file is dropped into a folder.

Summing Excel cells by color: an "easy" way and a "hard" way.

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.

Discover three types of dynamic drop-down lists in Excel, and how to create them.

VB Script and VBA are two different things - do you know which is which? What will happen now that VB Script is deprecated?

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

Three ways to see your Top 3 <<things>> in Excel using conditional formatting, the RANK function, and Pivot Table filters.

Here are 3 good reasons to use named ranges in Excel.

Create a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.

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

Using VBA code to check for #N/A in an Excel cell. The CVErr function allows you to check for several of the "#" errors in Excel.

Create an audible alarm in Excel that beeps when a timer expires.

When to use a subforms in a Microsoft Access database

A while back, I wrote about creating a timer in Excel. In that post, I went into detail about my failed attempts to create one, and how I...

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

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

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