Tag Archives: MS Access

Microsoft Answers Is Being Retired

Did you see the new heading banner that appears when you go and access the (Microsoft) Access (Database) forum on Microsoft Answers?

Microsoft 365 and Office forum Moving to Microsoft Q&A

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.

Continue reading →

No Labels Rendering/Displaying on Microsoft Access Command Buttons

Software Bug

This is a short post to advise you that there is a new bug affecting Microsoft Access where some or all command buttons may not display their labels and some also indicating images don’t render either!

Multiple forum threads have already reported this issue across various Access communities impacting Version 2506. Below are some of the specific build no. some users have mentioned as impacted by this issue:

  • 18925.20022
  • 18925.20064
  • 18925.20076
  • 18827.20164

 
Continue reading →

MS Access: The Last Office Holdout Without Copilot & Why That Should Change

Microsoft Copilot has rapidly become the centerpiece of productivity and AI-driven efficiency across the Microsoft 365 suite. From Word and Excel to PowerPoint, Outlook, and Teams, Copilot is transforming how users interact with their data, automate tasks, and generate content.  Yet, one notable exception remains: Microsoft Access. As the only major Office program without Copilot integration, Access stands apart-and not in a way that benefits its users.
 

Why Has MS Access Been Left Out of the AI Revolution?

Despite Microsoft’s aggressive push to integrate Copilot AI across the Office suite, MS Access remains conspicuously absent from this wave of innovation. This raises a fundamental question: why has Access, a core productivity tool for countless organizations, been left out while Word, Excel, PowerPoint, Outlook, and Teams all benefit from AI-powered assistance? The omission is especially puzzling given Copilot’s reliance on Microsoft 365 data and the Graph, both of which Access can leverage for data-driven tasks and automation.

Is the exclusion due to technical challenges, lack of internal resources, lower perceived demand, or concerns about how Copilot would interact with Access’s unique database structures? Or is it simply a matter of prioritization as Microsoft focuses on more widely used apps first? Whatever the reason, the lack of Copilot in Access leaves a gap in the AI productivity ecosystem and prompts users to wonder when, or if, Access will receive the same transformative capabilities as its Office counterparts.
 

The Case for Copilot in MS Access

Continue reading →

Adding Spell Check To Your Microsoft Access Forms

Spell checking is a valuable feature to incorporate in Microsoft Access forms, ensuring data accuracy and professionalism. Access provides built-in spell checking capabilities that can be triggered both by keyboard shortcuts and programmatically through VBA. Here’s how you can implement and optimize spell checking in your Access forms
 
Continue reading →

Yet Another New Microsoft Access Roadmap Item!

After months, if not years of neglect, we get the surprise of another new item popping-up on the Microsoft Access Roadmap. Twice in two weeks!

Access: Add zoom slider magnification to Microsoft Access
Access will add magnification slider (10% to 500%) in lower right of the application, similar to the feature in Word, PowerPoint, and Excel. It will also be keyboard accessible and available on the ribbon.
With the rollout scheduled for June 2025

 
Continue reading →

Saving User Settings and Preferences in Microsoft Access Database

Microsoft Access provides several effective strategies for saving user settings and preferences, ensuring a personalized experience while maintaining data integrity across sessions and devices. In this article I will explore some of the possible methods we can use for storing user-specific and application-wide settings in Access databases.
 
Continue reading →

Where To Turn To As The New Outlook Is Deployed And Breaks Our Applications

Anyone that follows my blog, knows that I’ve published many articles about the ‘New Outlook’. People are starting to face the issue of Outlook automation breaking when they upgrade to the ‘New Outlook’, and I use the term ‘upgrade’ VERY loosely as it truly is not an upgrading in any shape or form.

For instance, today, there were a couple posts on the subject on the Microsoft Answers Access forum:

How do I fix the SendObject failure with MS Access and the new version of Outlook
MS Access 365 Run-time error 2293

there have been others and many, many, many more will surface in the coming months.
 
Continue reading →

How to Address Corruption in Microsoft Access Databases

Database corruption can be a significant issue for Microsoft Access users, potentially leading to data loss and operational disruptions. I will attempt to outline some of the steps you can use to diagnose and address potential corruption in your Access database, as well as tools that can assist in the recovery process.
 
Continue reading →

Mastering Microsoft Access’ DLookUp Function

Outside of queries, DLookup is another built-in versatile and essential function in Microsoft Access that allows users to retrieve specific field values from tables or queries based on a defined criteria. This function is particularly useful when you need to access data that isn’t directly available in your current form, report, or query.
 

Syntax and Structure

The basic syntax of the DLookup function is as follows:

DLookup(expr, domain, [criteria])
  • expr
    The field or expression you want to retrieve.
  • domain
    The table or query name containing the data.
  • criteria
    Optional. The criteria to filter the records with.

 
Continue reading →