top of page
Search


Set Up Automated Report Refresh by Dropping a File in a Folder
Power BI can be set up to automatically refresh reports, grids, pivots and charts when a file is dropped into a folder.

Kimberlee Martin
Aug 23, 20243 min read
17
0


Sum Excel by Color - Which is the Easy Way?
Summing Excel cells by color: an "easy" way and a "hard" way.

Kimberlee Martin
Mar 12, 20243 min read
29
0


Dealing with the "Invalid Use of Nulls" Error
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.

Kimberlee Martin
Nov 21, 20233 min read
74
0


The Power of Dynamic Drop Down Lists in Excel: Streamlining Data Entry and Analysis
Discover three types of dynamic drop-down lists in Excel, and how to create them.

Kimberlee Martin
Nov 13, 20233 min read
24
0


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

Kimberlee Martin
Nov 2, 20233 min read
40
0


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

Kimberlee Martin
Oct 24, 20234 min read
24
0


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

Kimberlee Martin
Oct 20, 20233 min read
28
0


Three Reasons to use Named Ranges in Excel
Here are 3 good reasons to use named ranges in Excel.

Kimberlee Martin
Oct 17, 20234 min read
21
0


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

Kimberlee Martin
Sep 28, 20236 min read
62
0


One Table or Two? Or Three? Four??
Not sure if you need one table or two in Microsoft Access? Here's a guide.

Kimberlee Martin
Sep 21, 20234 min read
10
0


Detecting #N/A with VBA
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.

Kimberlee Martin
Sep 19, 20233 min read
110
0


BEEP! An Audible Alarm in Excel
Create an audible alarm in Excel that beeps when a timer expires.

Kimberlee Martin
Sep 14, 20233 min read
14
0


Do I need a subform on my Access form?
When to use a subforms in a Microsoft Access database

Kimberlee Martin
Sep 5, 20234 min read
16
0


Scheduling Excel Macros with a Timer
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...

Kimberlee Martin
Aug 8, 20234 min read
30
0


Port Access Data to SQL Server
Porting Microsoft Access tables to SQL Server

Kimberlee Martin
May 5, 20233 min read
25
0


Connection Properties
Use properties of Excel connections to gain access to real-time data points in your database.

Kimberlee Martin
Mar 29, 20235 min read
35
0


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

Kimberlee Martin
Mar 13, 20237 min read
19
0


VBA Overflow Error
The Overflow error occurs in Visual Basic when you exceed the limits of a variable's data type.

Kimberlee Martin
Mar 10, 20233 min read
111
0


Connecting Data Sources in Excel
Using VLOOKUP data from Access and SQL Server databases

Kimberlee Martin
Mar 8, 20234 min read
20
0


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

Kimberlee Martin
Feb 20, 20234 min read
20
0
CATEGORY
ARCHIVE
bottom of page