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
Oct 24, 20234 min read
Why Choose Microsoft Access?
Is Microsoft Access right for you? Here are several reasons why I often recommend Access to my clients.
21 views0 comments
Kimberlee Martin
Sep 21, 20234 min read
One Table or Two? Or Three? Four??
Not sure if you need one table or two in Microsoft Access? Here's a guide.
10 views0 comments
Kimberlee Martin
Sep 5, 20234 min read
Do I need a subform on my Access form?
When to use a subforms in a Microsoft Access database
15 views0 comments
Kimberlee Martin
May 5, 20233 min read
Port Access Data to SQL Server
Porting Microsoft Access tables to SQL Server
19 views0 comments
Kimberlee Martin
Mar 13, 20237 min read
Access Database Corruption
Dealing with the "database is in an inconsistent state" error message, and other symptoms of Microsoft Access corruption.
18 views0 comments
Kimberlee Martin
Jan 17, 20236 min read
Connections: Bringing SQL Server data into Access
Linking to data in SQL Server from a Microsoft Access database
22 views0 comments
Kimberlee Martin
Jan 11, 20234 min read
VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
15 views0 comments
Kimberlee Martin
Jan 9, 20234 min read
Connections: Bringing Access Data into Excel
Creating links to Microsoft Access data in your Excel worksheet.
27 views0 comments
Kimberlee Martin
Jan 5, 20236 min read
Connections: Bringing Excel Data into Access
Create a Microsoft Access table that is linked to an Excel file.
20 views0 comments
Kimberlee Martin
Dec 22, 20223 min read
Using Access to Clean Excel Data, Part 5
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...
19 views0 comments
Kimberlee Martin
Dec 12, 20226 min read
Using Access to Clean Excel Data, Part 4
Use MS Access to find duplicates in your Excel data
14 views0 comments
Kimberlee Martin
Dec 1, 20225 min read
Using Access to Clean Excel Data, Part 3
Use MS Access to clean numeric fields that contain text.
13 views0 comments
Kimberlee Martin
Nov 21, 20226 min read
Using Access to Clean Excel Data, Part 2
Use MS Access to clean phone numbers in your Excel data.
21 views0 comments
Kimberlee Martin
Nov 14, 20225 min read
Using Access to Clean Excel Data, Part 1
Excel data can be messy. Use MS Access features to clean it up.
30 views0 comments
Kimberlee Martin
Nov 4, 20227 min read
Appending Excel Data to an Access Table
Use an append query to add Excel data to an Access table
26 views0 comments
Kimberlee Martin
Oct 25, 20226 min read
Connections: Importing Excel Data into Access
Tips for making your Excel data import smoothly into Access
25 views0 comments
Kimberlee Martin
Aug 28, 20173 min read
Data Accessibility
Just about all companies rely on electronic data these days, but not all companies can quickly and easily access their data. Here are a...
26 views0 comments
Kimberlee Martin
Apr 18, 20173 min read
Option Explicit
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...
23 views0 comments
Kimberlee Martin
Jan 20, 20174 min read
Protecting Data on an Access Form
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...
51 views0 comments
CATEGORY
ARCHIVE
bottom of page