Microsoft Office has just rolled out a fresh new look, with its suite of apps receiving a long-awaited facelift. As of yesterday, the familiar icons for Word, Excel, PowerPoint, Outlook, and more have been refreshed, giving the productivity tools a modern, streamlined design.
Continue reading
Did you see the new heading banner that appears when you go and access the (Microsoft) Access (Database) forum on Microsoft Answers?
We are excited to announce that soon, the Microsoft 365 and Office forum will be available exclusively Microsoft Q&A. This change will help us provide a more streamlined and efficient experience for all your questions and discussions.
Starting July 16, you will no longer be able to create new questions here in the Microsoft Support Community. However, you can continue to participate in ongoing discussions and create new questions on Microsoft Q&A. Thank you for your understanding and cooperation.
In recent years, the hype surrounding AI has permeated every aspect of our lives, including software development. While initially skeptical due to ethical concerns and copyright issues, curiosity led to exploring AI’s potential in code generation. After months of testing, using multiple programming languages (PHP, VBA, HTML, JavaScript), it’s clear that AI has both strengths and weaknesses in this domain.
Continue reading
In the world of data processing, we often find ourselves dealing with information from various sources. This “ingested” data can be a bit like a wild animal – unpredictable and sometimes difficult to handle. One of the most common challenges? Strings containing Nul characters and other Unicode oddities that refuse to play nice with our systems.
Have you ever output a string to the VBE Immediate Window, only to be greeted by a parade of question marks? These enigmatic symbols are often the calling card of characters that can’t be properly rendered. It’s like trying to read a book written in invisible ink – frustrating and not very useful!
So, how do we tame this Unicode jungle? The answer lies in sanitization – carefully processing our raw strings to remove these troublesome characters.
Have you ever encountered mysterious behaviors when working with strings or text from various sources? You’re not alone. Many developers have faced situations where the Len() of a string doesn’t match what’s visually apparent on the screen. Perhaps, you’ve gotten string which displays as a series of ‘?’ characters,
These puzzling discrepancies often stem from non-printable and Unicode characters. These sneaky characters can be part of your data but don’t necessarily show up when displayed. They’re like invisible guests at a party – present but unseen!
Continue reading
This is something I’ve been wanting to do for quite a while, that is, to create a page dedicated to working with Dates and Times.
I was doing a little more advanced Date/Time VBA programming and decided that now was as good a time as ever to start creating such a page. So here it is.
This article will evolve with time, so come back from time to time.
After my recent post and video regarding Office 2024’s release:
I’ve seen a few questions on my YouTube channel and in various forums where people are trying to understand the difference between Microsoft 365 (also referred to as MS 365 or MS365) and this latest release of Office 2024.
As such, I thought this an important subject to cover.
Did you know, Office 2024 launched yesterday!
That’s right, if you want a perpetual license (1 time purchase rather than the MS365 Subscription model) of the latest and greatest version of Office then 2024 is now on the market.
Here’s Microsoft’s official announcement:
Unless you’ve been living under a rock for the past 2 weeks, people have been dealing with the latest Microsoft Access bug.
Just a quick heads up everyone that:
You should also note this will also impact MS365 users as it is being reported that it will begin to rollout for them as well as of April 2025.
