Convert Any Angle Into A Cardinal Angle => 0, 90, 180 and 270

While working on the same project in which I came to need:

Convert Any Angle Into A Positive Angle Between 0 and 359
Working on a personal project, I was in need of allowing the user to enter a rotation angle. I wanted to allow the user to make any entry, but the code that performs the rotation only accepts positive angles, so it became necessary to create a simple little function to perform a conversion of the input (so any value) and output a controlled value between 0 and 359 degrees.  

I perfected the function to actually output cardinal angle since my actual need was to produce angles to work with WIA’s rotate filter.

So I was after cardinal value like: 0, 90, 180, 270.
 
Continue reading →

The Best Approach To Reading Files In VBA

Years ago, I develop a simple function to read a ‘text’ file using VBA so I could pass the ‘text’ file’s content to a VBA variable to then be able to work with.  You can consult that article by referring to:

VBA - Read File into Memory
The following VBA function enables you to read files, for instance a text file, into memory (pass the read file’s content to a variable for instance) to further use within your application. Instead of reading each line, one by one, the following approach reads the entire file in one go. So this should be faster than other methods. …

Continue reading →

More recently, having over the years used a variety of different ways to read files, I was curious if one approach was better (from a performance standpoint)?
 
Continue reading →

Convert Any Angle Into A Positive Angle Between 0 and 359

Working on a personal project, I was in need of allowing the user to enter a rotation angle. I wanted to allow the user to make any entry, but the code that performs the rotation only accepts positive angles, so it became necessary to create a simple little function to perform a conversion of the input (so any value) and output a controlled value between 0 and 359 degrees.
 
Continue reading →

MS Access: The Last Office Holdout Without Copilot & Why That Should Change

Microsoft Copilot has rapidly become the centerpiece of productivity and AI-driven efficiency across the Microsoft 365 suite. From Word and Excel to PowerPoint, Outlook, and Teams, Copilot is transforming how users interact with their data, automate tasks, and generate content.  Yet, one notable exception remains: Microsoft Access. As the only major Office program without Copilot integration, Access stands apart-and not in a way that benefits its users.
 

Why Has MS Access Been Left Out of the AI Revolution?

Despite Microsoft’s aggressive push to integrate Copilot AI across the Office suite, MS Access remains conspicuously absent from this wave of innovation. This raises a fundamental question: why has Access, a core productivity tool for countless organizations, been left out while Word, Excel, PowerPoint, Outlook, and Teams all benefit from AI-powered assistance? The omission is especially puzzling given Copilot’s reliance on Microsoft 365 data and the Graph, both of which Access can leverage for data-driven tasks and automation.

Is the exclusion due to technical challenges, lack of internal resources, lower perceived demand, or concerns about how Copilot would interact with Access’s unique database structures? Or is it simply a matter of prioritization as Microsoft focuses on more widely used apps first? Whatever the reason, the lack of Copilot in Access leaves a gap in the AI productivity ecosystem and prompts users to wonder when, or if, Access will receive the same transformative capabilities as its Office counterparts.
 

The Case for Copilot in MS Access

Continue reading →

VBA Function to Determine if a File is a Valid JSON File

JSON

After publishing my article on determining if a file was a valid XML file:

XML
VBA Function to Determine if a File is a Valid XML File
I was quickly reviewing a couple forums to look for interesting questions, ideas for blog posts and came across the following question on UA: and thought this could make for a good quick post.  

I thought I’d do similarly for JSON files as they have become quite common too.

Now, like everything else in VBA, there are a multitude of possible approaches to this.

Like XML files, JSON files do not possess a file signature also referred to as ‘magic number’. The bigger issue with JSON files however is that unlike their XML counterpart, they do not include any declaration line to easily validate.
 
Continue reading →

Get a Drive’s Name/Label Using WMI in VBA

Doing my daily rounds, checking various forums to see if there were any interesting nuggets of knowledge, I came across a question on UtterAccess

How to get Drive Volume Label in Ms Access 2024 vba code
As previously I used function to get volume label of hard disk in MS access vba, now in new office version it is not working, can any one tell me that how can I get volume label for any drive like E: drive

 

Since, I’ve previously done much work retrieving all sorts of PC related information I figured I quickly help Raheel out and at the same time, post the code here for all to benefit.
 
Continue reading →

Access – Playing With Database Properties – Part 2

I while back I publish about Database Properties:

Child Playing With Bubbles
Access - Playing With Database Properties
Today, I thought we’d take a look at playing around with Database Properties: Listing the Properties Getting the Value of a Specific Property Creating a Property Deleting a Property To simplify my code, I am using my oCurrentDb Self-Healing Object Variable (SHOV).  If you’re not familiar with that yet, then start off by reviewing: Or if your truly don’t want to learn/use SHOV, in all the code below, simply replace ‘oCurrentDb’ with ‘CurrentDb’. Now, let the fun begin!

In this post I thought I’d simply provide a listing of the common properties (you know the ones we see in the File -> Options -> Current Database dialog) with their relevant information so you as a developer can automate them without needing to search endlessly for property names, types, value as I have never found any proper documentation on the subject from Microsoft (or anywhere else).
 
Continue reading →

VBA – Opening Files and URLs

Have you seen my previous post?!
Before going any further, have you seen my previous post regarding opening a URL in the browser of your choice entitled VBA – Open a URL in FireFox/Chrome, check out the section entitled ‘A Procedure to Control Them All!‘
So what does a developer do when he can’t sleep? He explores what options can be used to open files and/or URLs, of course!

In this article I will attempt to explore multiple approaches that can be used to open Files and URLs using VBA, the choice of which one to use is left to you to decide! That said, I will expand on:

 
Continue reading →

Adding Spell Check To Your Microsoft Access Forms

Spell checking is a valuable feature to incorporate in Microsoft Access forms, ensuring data accuracy and professionalism. Access provides built-in spell checking capabilities that can be triggered both by keyboard shortcuts and programmatically through VBA. Here’s how you can implement and optimize spell checking in your Access forms
 
Continue reading →