VBA
Hello everyone, I'm new here, so please be kind! This happens every time I create a new file, and Visual Basic Editor won't open in Access. When I click on 'Visual Basic', a pop-up box appears and I'm told that the database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all codes from modules, forms and reports. You should backup your database before attempting to delete the VBA project. Note: To create a backup copy, click Cancel and then make a backup copy of your database. To open the database and delete the VBA project without creating a backup copy, click OK. Well, I have no database to read in the first place because I haven't made one, so what does it mean, and how do I fix this, please?End of support for Access 2016 and Access 2019 nears
Your product will still work, but when Microsoft says a product has reached "end of support", it means the product will no longer receive: Security updates Non-security updates Bug fixes New features Assisted support (free or paid) What this means for Access users: No more updates: Customers will not receive any new builds, patches, or improvements—even if vulnerabilities are discovered. No support: Microsoft will no longer provide technical support or troubleshooting assistance. Increased risk: Continued use of unsupported software can expose systems to security threats and compliance issues. Migration encouraged: Customers are advised to upgrade to a supported version or product to maintain security and functionality. We strongly encourage all Access users with perpetual licenses to upgrade to a Microsoft 365 Apps subscription. Subscription users get more out of the same Office desktop apps with artificial intelligence (AI) backed design ideas and analytic insights, rich contents and templates, cloud powered connected experiences and more. They also enjoy additional benefits beyond capabilities in Office apps, such as 1TB storage, Office on multiple devices and mobile, Microsoft Family Safey app, etc. I've noticed many perpetual users are "subscription adverse." I hear "I've used the desktop version forever and prefer not to switch to the cloud." Migrating to subscription does not mean that you'll get a different version of Access. You'll still get the desktop version you know and love, plus all the premium Office features a subscription provides. My favorites are Editor in Word, Money in Excel, and all the extra OneDrive storage. Check with Microsoft Sales Support to see if you're eligible for upgrade incentives depending on your region or organization type. (Yes, we know the Access icon does not appear with the other Office apps. You'll find it directly below the icons in the alphabetized apps list.) Sources: End of support for Office 2016 and 2019 Overview - Product End of Support and Retirements - Microsoft Lifecycle Access 2016 - Microsoft Lifecycle Access 2019 - Microsoft LifecycleAccess announces removal of Salesforce ODBC driver in October 2025
MS Access 2019 (and newer) ships a licensed Salesforce ODBC driver from InsightSoftware that will lose sustaining support after June 30th, 2026. But because we can no longer provide updates for the driver, the Access team has decided to accelerate the removal of this driver and remove it from the product in October 2025. Applies to: Access 2019 volume licensed and Enterprise plans Access 2021, Access 2024, and Microsoft 365 subscriptions Access 2021 and Access 2024 as part of the Office 2021 and Office 2024 perpetual licenses (standalone versions) The Salesforce ODBC driver bundled with Office includes shared libraries such as: libcurl.dll libcrypto-3.dll libssl-3.dll These libraries are located under the following path: Program Files\Microsoft Office\ODBC Drivers\Salesforce. They may also be present in different locations. Drivers installed by Office and used to access your Salesforce data will be removed on permanently on October 28, if you are using Access as part of a Microsoft 365 Apps monthly version and on November 11 if you are on the semi-annual release. For customers using perpetual Access 2019, 2021, or 2024, the drivers will be removed on November 11. You do not need to manually remove the drivers. Access currently doesn't have a way to talk directly to the Salesforce APIs so customers must continue to use the standardized ODBC driver framework that we currently support. Customers can independently purchase the Simba.DLL driver if needed from InsightSoftware. There are also other vendors that offer a Salesforce driver. Simba driver from InsightsSoftware https://insightsoftware.com/simba/ ODBC driver from devart https://www.devart.com/odbc/salesforce/ Salesforce integration from boomi https://boomi.com/solutions/application/salesforce/ Salesforce driver from cdata https://www.cdata.com/drivers/salesforce Once you purchase and install the driver, Access can connect to your Salesforce external data source. On the External Data ribbon, choose New Data Source > From Other Sources > ODBC Database We will provide more updates when available.
Adding sub form for a new year
I am new to access. I have a new job to work on the database. I am attaching a copy of the page where there is the membership record and below there are several subforms. I would like to add a new subform of "2025-2026 Dues". There are forms for the previous years and I can copy them, but I don't know how to get them at the bottom ofthe page I have shown below. Can someone help me?
How to Delegate Access Package Approvals in My Access
Microsoft recently published some documentation on enabling a new preview feature to allow access package approvers to delegate approval of their Access Packages. I walk through enabling it and the experience in my article > https://ourcloudnetwork.com/how-to-delegate-access-package-approvals-in-my-access/Microsoft Support
Dear Team, I’m currently experiencing an issue with Microsoft 365 Business Basic. I’m trying to purchase a domain and set it up with an Exchange Online mailbox, but I’ve run into several roadblocks when attempting to report the problem: I’m using a personal account and cannot reach Microsoft Business Support. Consumer Support was unable to assist or escalate the issue to a business support case. The Qatar toll-free number is not working. Given these challenges, I’m unsure how to proceed with resolving my initial issue related to the M365 account setup. I would appreciate any guidance on how to access the appropriate support channels. Thank you for your assistance. Best regards,
Pictures are not displayed in report
Hello, I have a serious problem in Access 2016. Our database is running on multiple machines. Most access databases are running without any problems but some access databases do not display the product pictures in reports (jpg format). The strange thing is that the pictures are displayed correctly within the forms. The pictures are not embedded but shown as link. Any ideas how to fix this? Tom
Viva Engage Community Membership
Hi I need some assistance with Viva Engage. The default community All Company has 300 members where we only have 200 active staff. The additional users that are showing have no licenses and are disabled in admin centre. How can i remove these users? I only noticed the All Company group in entre exists but has no users. Can you help Thanks, CiaranIn form or report design view, cannot paste objects
Hello all. I have used MS Access for over 20 years as a user (not developer). I like to design forms and reports from scratch (not using wizards), and it is handy to copy and paste objects in design mode. This includes controls, labels, lines, buttons, etc. For example, in a tabular transaction-type report, I can copy already-formatted controls from the detail to the report or group footer and just edit each to be a sum. For the last several months, I can click Copy on the bar (or ctrl +c), but the paste icon does not light up and ctrl + v does not work. Sometimes if I wait long enough (like several minutes later), the paste function becomes enabled. It takes me substantially longer now to add new objects from the Report Design bar and reformat them to match the existing report or form. I don't know if this is an Access issue or a clipboard issue. I am able to copy and paste large volumes of data with no problem at all. I am thinking about re-installing my Office 365 (which includes Access). Has anyone else had this problem, and is there a solution? The version I have is Access for Microsoft 365 MSO (Version 2503, Build 16.0.18623 20076 64-bit)Microsoft 365 Windows 11 external user or guest user sign in
Consider the following situation: CompanyA has a Microsoft 365 tenant with licensed users. CompanyA has a business relationship with CompanyB which also has a Microsoft 365 tenant. All of CompanyB's Windows 11 Pro computers are Entra ID joined and Intune enrolled. All of CompanyB's users have Microsoft 365 Business Premium licenses. An employee of CompanyA is stationed at CompanyB's office and needs to use one of CompanyB's computers as his primary computer. How would a technician have to configure things so that CompanyA user can sign into CompanyB's Windows 11 Pro computer and work like normal? I've done some reading online but most of the articles focus on access to cloud resources, whether that be Microsoft Teams or Entra Enterprise Apps or similar resources. I haven't found an article touching on Windows 11 sign in. Matthew
