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.
top of page
Search
Kimberlee Martin
Mar 123 min read
Sum Excel by Color - Which is the Easy Way?
Summing Excel cells by color: an "easy" way and a "hard" way.
23 views0 comments
Kimberlee Martin
Nov 21, 20233 min read
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.
30 views0 comments
Kimberlee Martin
Nov 13, 20233 min read
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.
21 views0 comments
Kimberlee Martin
Nov 2, 20233 min read
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?
28 views0 comments
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
Oct 21, 20233 min read
Your Best Three
Three ways to see your Top 3 <<things>> in Excel using conditional formatting, the RANK function, and Pivot Table filters.
25 views0 comments
Kimberlee Martin
Oct 17, 20234 min read
Three Reasons to use Named Ranges in Excel
Here are 3 good reasons to use named ranges in Excel.
18 views0 comments
Kimberlee Martin
Sep 28, 20236 min read
Excel Stopwatch
Create a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.
36 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 19, 20233 min read
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.
37 views0 comments
Kimberlee Martin
Sep 14, 20233 min read
BEEP! An Audible Alarm in Excel
Create an audible alarm in Excel that beeps when a timer expires.
13 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
Aug 8, 20234 min read
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...
28 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
Feb 20, 20234 min read
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,...
17 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 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
CATEGORY
ARCHIVE
bottom of page