Category Archives: MS Access Samples

Free Nonprofit CRM Template to Organize Contacts and Members

Over the years, I’ve worked with several charities to help them get their data organized. One of the most common challenges they face is keeping track of their contacts, clients, and members in a clear and consistent way.

Many of these organizations, through no fault of their own, simply don’t have the resources or technical expertise to build a professional database solution. Instead, they often make do with a mix of spreadsheets, usually in Excel, stitched together to somewhat meet their day-to-day needs.

To make things a little easier, I’ve decided to share a simple, bare-bones sample database that can serve as a solid starting point. From here, new features and functionality can be added over time, but this foundation gives non-profits a reliable and well-structured beginning.
 
Continue reading →

Understanding and Managing Microsoft Access Shift Bypass

Microsoft Access Shift Bypass is a feature that allows users to open an Access database without running startup options or AutoExec macros. This functionality can be crucial for developers and administrators but may pose security risks in deployed applications.
 

How Shift Bypass Works

When opening a Microsoft Access database, users can hold down the SHIFT key to bypass startup properties and the AutoExec macro. This feature is particularly useful for troubleshooting and accessing databases that might have errors in their startup code.
 
Continue reading →

Using ExifTool in VBA to Work With File Exif Meta Information

A while back I published a several articles about working with images and other files to read/write Exif meta data:

Well, while I was developing all of those techniques, I kept seeing mentions of ‘exiftool’ which is a standalone program designed by Phil Harvey to specifically work with Exif file information.  So today, I thought I’d show you all how we can take advantage of this tool via VBA.
 
Continue reading →

Playing Around With Microsoft Access Text Boxes

Today, I thought I’d simply share a few bits of code for things developers often need to do with Text boxes, and a few that I had fun creating just for the sake of seeing how it could be done!

Things like:

  • Positioning the Cursor
  • Selecting Text
  • Inserting Text
  • Retrieving Content
  • And More…

Continue reading →

Form and VBA Based Slider Control – Modernizing the Interface

Well, 96% of people indicated that they want to learn more about creating Slider controls.

So, in this post, I start covering the subject by introducing the ‘simplest’ (maybe not quite, but what you would think would be the simplest) slider control built entirely using a couple label controls and a command button.

I will post a few more articles in the coming days that will cover other possibilities:

  • Multi-range slider
  • Legacy Web Browser slider
  • Modern Web Browser slider

Continue reading →

Table Driven Modern Menus

In a continuation of my article on Improving the Microsoft Access Interface

Modernizing The Microsoft Access Interface!
Some people have asked me what I’ve been working on and so I thought I’d share a sneak peak. Basically, I’ve been working on trying to elevate the Access interface a bit and have been working on a few new menus concepts and thus developing content, demos for my blog and YouTube channel.

I recently released a YouTube video in which I demonstrated how we could take a static menu and switch it to be table/data driven.

Continue reading →

How-to Send E-mails Via Gmail Using The Google API

So this post goes hand in had with my post

How-to Send E-mails Via Outlook Using The Microsoft Graph API
Well, unless you’ve been living under a rock, by now, you are aware of some fundamental changes coming to Outlook in the not too distant future, mainly the fact that it will cease to support any form of VBA! Now, many have tried to make Microsoft reverse course, understand the millions of solutions (Access, Word, Excel, …) that will instantaneously break with such a switch, but there has been no change in course.  Actually, per the usual, there has been little to no response whatsoever. This brings us to today’s post!  

and was an attempt to find a solution to Microsoft Outlook dropping all VBA support when the ‘New Outlook’ is implemented.

So please start by reviewing the article above as it covers aspects that I won’t repeat here: Basic Authentication Flow, Making Requests, JSON, …
 
Continue reading →