Category Archives: MS Access General Information

So What’s Your Access Version And Build No?

Confuse, eyes squiting

Since Click-to-run (CTR or C2R) came out, one of the fundamental questions anyone trying to help out other users with their problems asks is:

What Version and Build are you running?

The problem is this question seems so mundane, yet it can be very confusing!

I’ve previously covered the subject

That said, I never covered the issue of 2 distinct values appearing at time and thought it important to clarify the difference and which is the correct one to refer to.
 

Why Are The Version And Build So Important?

It helps us determine if there are known bugs with that specific release.  Each update, so each build, bring along new bugs and by telling us the Version and Build we can check known issues to either determine, or eliminate the potential of a bug causing the issue.

It also helps us try and reproduce such bugs and report them to Microsoft (it’s typically one of the first questions they ask of us! 🙂 ).

It’s similar to say buying tires, you have to tell the shop what make/model of car you have to purchase the right ones.  Same for Office/Access, the make and model equate to the Version and Build and this tell us what flavor of Access you are driving!  This way we can better gear our help towards the specifics of your make/model.

Continue reading

Microsoft Access YouTube Resources

In previous posts, I’ve provided links to some valuable Microsoft Access websites

Today, I thought I’d offer a few online learning YouTube resources worth investing your time in and watching:
 
Continue reading

Access – Proper Folder Setup

Traffic Light

By now, we all know that the proper setup of an Access database is to split the database into a back-end (tables) and front-end (everything else) and then deploy the back-end on a central share and an individual copy of the front-end to each user’s local PC.  Furthermore, both the back-end and front-end required Read/Write/Delete permissions.

If you’re not already aware of this, I’d recommend you review:

 
Continue reading

Access – New Modern Web Browser Control

Microsoft 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

A More Modern Date Time Picker

In a recent discussion, someone asked if there were any more modern Date Time Pickers available to implement in their Microsoft Access database. Rightfully, as they stated, most current Date Time Pickers are very much visually stuck in the 80’s.

So I set out to tinker and see what was possible.

Continue reading

Microsoft Access – Table Field Captions

In this article I want to touch upon Field Captions. Why you should Love them and Hate them!

 

What Is A Caption?

The first thing we need to do is understand what the caption property is exactly:

The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Microsoft

Continue reading

Access – Bing Maps Basics

After demonstrating how easy it was to use Google Maps to display a map of an Address or Geolocation coordinates in my article

I wanted to demonstrate that the same was true for mapping with Microsoft Bing Maps.

Microsoft Access - Web Browser Control - Bing Maps Continue reading