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.
top of page
Search
Kimberlee Martin
- Nov 13
- 3 min
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.
60
Kimberlee Martin
- Nov 2
- 3 min
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?
50
Kimberlee Martin
- Oct 24
- 4 min
Why Choose Microsoft Access?
Is Microsoft Access right for you? Here are several reasons why I often recommend Access to my clients.
70
Kimberlee Martin
- Oct 21
- 3 min
Your Best Three
Three ways to see your Top 3 <<things>> in Excel using conditional formatting, the RANK function, and Pivot Table filters.
110
Kimberlee Martin
- Oct 17
- 4 min
Three Reasons to use Named Ranges in Excel
Here are 3 good reasons to use named ranges in Excel.
90
Kimberlee Martin
- Sep 28
- 6 min
Excel Stopwatch
Create a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.
100
Kimberlee Martin
- Sep 21
- 4 min
One Table or Two? Or Three? Four??
Not sure if you need one table or two in Microsoft Access? Here's a guide.
10
Kimberlee Martin
- Sep 19
- 3 min
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.
40
Kimberlee Martin
- Sep 14
- 3 min
BEEP! An Audible Alarm in Excel
Create an audible alarm in Excel that beeps when a timer expires.
80
Kimberlee Martin
- Sep 5
- 4 min
Do I need a subform on my Access form?
When to use a subforms in a Microsoft Access database
70
Kimberlee Martin
- Aug 8
- 4 min
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...
190
Kimberlee Martin
- May 5
- 3 min
Port Access Data to SQL Server
Porting Microsoft Access tables to SQL Server
80
Kimberlee Martin
- Mar 29
- 5 min
Connection Properties
Use properties of Excel connections to gain access to real-time data points in your database.
200
Kimberlee Martin
- Mar 13
- 7 min
Access Database Corruption
Dealing with the "database is in an inconsistent state" error message, and other symptoms of Microsoft Access corruption.
130
Kimberlee Martin
- Mar 10
- 3 min
VBA Overflow Error
The Overflow error occurs in Visual Basic when you exceed the limits of a variable's data type.
460
Kimberlee Martin
- Mar 8
- 4 min
Connecting Data Sources in Excel
Using VLOOKUP data from Access and SQL Server databases
140
Kimberlee Martin
- Feb 20
- 4 min
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,...
120
Kimberlee Martin
- Jan 27
- 3 min
VBA: Data Type Conversion
VBA's automatic type conversion feature sometimes causes it to concatenate instead of add.
140
Kimberlee Martin
- Jan 20
- 4 min
Connections: Bringing SQL Server data into Excel
Add a link to SQL server data to your Excel worksheet.
160
CATEGORY
ARCHIVE
bottom of page