Tag Archives: MS Access

Bye Bye Access TechCommunity Forum?

Microsoft Tech Community Access Forum

I thought it might be a glitch when I could no longer access the site yesterday, but now it has been confirmed by others as well (John left me a comment to the effect), the Microsoft Tech Community Access forum appears to be gone:

https://techcommunity.microsoft.com/t5/access/ct-p/Access_Cat

If you try to navigate to the above URL you get prompted to login and will eventually get redirected to:

https://techcommunity.microsoft.com/

From there, good luck finding a way to navigate to Access, or Excel, ….

That said, I did manage to eventually find Access and it can be directly accessed via:

https://techcommunity.microsoft.com/category/microsoft365/discussions/access

If you really want to know how to locate it, here you go:

  1. Navigate to https://techcommunity.microsoft.com/
  2. From the header menu click on the Products drop-down and select Microsoft 365
  3. Click on the Discussion Spaces tab
  4. Click on the Show More button
  5. Click on the Access card

Microsoft couldn’t have made it any easier! 🙄
 
Continue reading →

Export Report to Excel Only Available As XLS Format

Well, I’m all for reminiscing, but in this instance I think the Dev Team may have gone a little too far!

A user recent left me a comment inquiring about how they could export an Access report in Excel format, but as an xlsx. Seem like a reasonable enough question considering the xlsx file format has been the default format for at least 17 years now!

Continue reading →

How-To Copy a Table’s Structure Only Without The Data

Here’s an interesting question that I was asked today:

I want yo copy only structure, empty table without data?

We immediately think of CopyObject method, but sadly, Microsoft never included the option to include/omit the data. So it always includes the data. Yes, you could use it non the less and then clear the table of the data afterwards, but this will cause unnecessary bloating and require a Compact and Repair to complete the process properly. It remains an option, but there are better approaches, so let’s briefly explore a couple of them.
 
Continue reading →

Working With Dates and Times

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.

Continue reading →

What is the Difference Between Office 2024 and MS365?

After my recent post and video regarding Office 2024’s release:

Microsoft Office 2024 Released!
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:  

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.

Continue reading →

Microsoft Office 2024 Released!

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:

Office 2024 for consumers available October 1 | Microsoft 365 Blog
Office 2024 includes updated, locked-in-time versions of Word, Excel, PowerPoint, OneNote, and Outlook for PC and Mac. Learn more.

 
Continue reading →

You need to do something extra before we can sign you in.

Once again, in the category of ‘you can’t make this crap up’, I was trying to connect to a new client’s SharePoint site via Access to review their data and determine how I could clean things up and get them setup properly in Azure…

Well, using the External Data -> More -> SharePoint List and entering the SharePoint URL, I was prompted for my credentials after when I go to authenticate, this is what I get!

Continue reading →

How to Select and De-Select an Item in a Listbox

Simplifying Data Entry in Microsoft Access: Setting Default Selections in Listboxes

While working on a project for a charity I support, I aimed to streamline data entry by setting a default selected item in a Listbox. Given that 95% of the time, this would be the desired value, it seemed like a simple way to reduce clicks and enhance user experience.

Instead of hardcoding a value directly into the Property Sheet or using VBA, I recalled a subroutine I had developed years ago for a similar purpose. After some digging, I found that routine and decided to enhance it by updating the header and refining the error handler. The result? A more robust solution for selecting or deselecting specific items in a Listbox.
 
Continue reading →

Microsoft Access’ Latest Bug Highlights The Importance Of Your Update Channel!

Maximize Stability in Microsoft Access: The Importance of Update Channels

Unless you’ve been living under a rock for the past 2 weeks, people have been dealing with the latest Microsoft Access bug.

Software Bug
Another msaccess.exe Process Not Closing Properly Bug
There isn’t much information at this point in time on the root cause and no official fix to the issue (there are workarounds however, see below), but it would seem that with the most recent update(s) Microsoft Access no longer closes properly and leaves instances of the msaccess.exe running in the background.

Continue reading →