Access – List of Bugs

As I had posted a short while ago, a bunch of MVPs set off to do what Microsoft has, thus far, refused to do: provided timely, detailed supported of bugs as soon as they are spotted in the wild and impacting users.

A New Microsoft Access Bug Tracking Website

As many of you are aware, for years, I tried to keep up with the onslaught of continual Microsoft Office/Access bug on this very blog, some (not all) are mentioned in my article: That said, bug tracking has truly become a full-time job as more and more bugs occurs and trying to keep the information…

Continue reading →

The truth of the matter is Microsoft is a HUGE entity and everything there has procedures to follow, approvals to be gotten, so most everything runs at a snails pace. Hence, even confirming and then documenting bugs has shown MS to be less than responsive leaving users holding the bag for days, weeks … (and this isn’t due to the Dev Team not being aware of and actively working on the problems!)

Continue reading →

Update Crosstab Query’s Subform To Reflect New Fields

I recently embedded a query as a subform in another form and encountered an issues.

Here’s the gist of the situation. For a project I was working on, I have a process that updates a tables data. I then use a crosstab query to display it properly (or as the user wants it displayed). The issue being that the fields in the crosstab change with iteration of the process. Thus, it was impossible to build a form since the fields were not constant.

So the solution was to embedded a query directly as a subform.

The Real Issue

The issue I then encountered was that after the process ran, I could requery the query’s subform and the data would indeed update to refelect the latest iteration’s values, but the field that were displayed did not get updated. I tried Requery, Refresh, Repaint, nothing seemed to be able to get the subform to show the proper listing of fields from the source query. Yet, if I opened the query, the fields had indeed been changed.

Continue reading →

VBA – Get SSL Certificate’s Expiry

I was helping a user in a forum and thought I’d publish the solution here in case it could help others as it currently is behind the forum’s PayWall.

The user wanted to know how we could,using VBA, retrieve a site’s SSL Certificate’s Expiry Date/Time.

Continue reading →

Critical Microsoft Outlook Vulnerability/Bug – Update Now!

If you haven’t kept up on recent Microsoft bugs, there another new HUGE vulnerability impacting Outlook. It is currently all over the internet because of the scope and ease of use by hackers and the fact that it has been effectively detected as being currently used to infect/attack people.

Microsoft’s official release on the matter is found at:

Security Update Guide - Microsoft Security Response Center

Microsoft Outlook Elevation of Privilege Vulnerability
CVE-2023-23397
Security Vulnerability

Microsoft themselves quantify the Severity as Critical.

Continue reading →

Access – Buttons Won’t Print

I was working on a report recently and my client wanted to include some buttons (this isn’t something that I commonly do).

So I set everything up and show them the mock-up and everyone was happy.

Then we tested it out by printing it! Nothing appeared, no buttons?!

No problem, there’s a setting for that, I’ve seen it. So I went into design mode and found the “Display When” property, but to my amazement it was already set to “Always”?!?!!?

Continue reading →

Access – Controlling A Label’s Trailing Colon

In my recent YouTube video:

I demonstrate how we can set Access to include, or not, trailing colons for text box associated labels.

Now this is great when doing new development, but what about when we take over an existing project and we want to update and standardize things?!

Have no fear, the solution is hear!

Continue reading →

Access – New Modern Web Browser Control

At one point in time the New (Modern) Web Browser Control was scheduled for General Availability (GA) for October 2021. Then it was pushed back to September 2022. Then it was removed from the Roadmap altogether! Recently, it reappeared with a GA date of March 2023 and then a second entry appeared stating April 2023. I guess it got pushed back again, but the previous entry wasn’t removed.

Well, I finally have some good news! No really.

Continue reading →

Microsoft’s Quick Assist Remote Assistance App

Did you know that recent versions of Windows come with a baked-in remote access/support App called Quick Assist?

For years now, I’ve used TeamViewer and it work flawlessly. That said, I was turned off by their ‘recent’ change over to subscription based updates and disabling of older versions forcing people to update.

So in recent months, I have been trying to look at alternatives and have used Quick Assist now on multiple occasions with multiple clients/family and friends. Below are some of my experiences and observations.

Continue reading →

VBA – WMI – Gather Information & Configure Printers Cont’d

So, I’ve recently been on a WMI Printer kick! 🙂

VBA - WMI - Deleting A Printer

Just a short post today to demonstrate how easy it is to delete a printer from a PC executing some simple WMI code via VBA. If you follow my blog at all, by now you are fully aware that WMI can easily retrieve information regarding pretty much any aspect of your PC: Hardware, Software, Events,…

Continue reading →

VBA - WMI - Configure A Printer

Earlier in the week, I demonstrated that WMI can be use for more than just retrieve information about a PC. What about configuring different aspects of your PC! That’s right, WMI can do that too.

So let’s do one more article and share a little more of some of what can be done, things like:

Get Information About The Printer And Drivers
Get The PC’s Default Printer
Set A Printer As The Default Printer
Rename A Printer

Continue reading →

VBA – WMI – Change the ‘Use Printer Offline’ Property

Earlier in the week, I demonstrated that WMI can be use for more than just retrieve information about a PC.

VBA - WMI - Deleting A Printer

Continue reading →

What about configuring different aspects of your PC! That’s right, WMI can do that too.

Continue reading →