Microsoft Office 2019 Now Available – Comparing 2019 vs 2016 vs 365, New Features in Access & Excel
Microsoft Office 2019 is out! Microsoft started the roll-out today of Microsoft Office 2019 for Windows & Mac – with major updates to Access, Excel, Word, PowerPoint, Outlook, Project, Visio, and Publisher – to commercial volume license customers. Microsoft is following up with Office 2019 releases to consumers and other business customers, as well as SharePoint / Exchange / Skype / Project Server 2019 releases, in the coming weeks. Office 2019 provides a subset of features Microsoft has added to Office 365 over the past three years. As Office 2019 is a one-time release, Office 365 is still the better choice with not only far more features (Co-Authoring, etc) unavailable in Office 2019, but also far earlier access to them than on-premises, non-subscription Office 2019, etc. editions. Speculation has been that Office 2019 may be the last perpetual license (on-premises / non-subscription) release of Office, so that Microsoft can focus in on its Office 365 subscription offerings. However, Microsoft has responded in one case that there is likely to be one more perpetual license release after this one. Either way, Microsoft Office 2019 product pages even describe Office 2019 as a "one-time release" with Office 365 being needed to gain access to new features after that. It may also be that there are fewer editions available for Office 2019 than for Office 2016. Whether you move to Office 2019 or 365, it's suggested you don't delay doing so, as Office 2016 cloud support will be dropped in 2020, with Office 2016 installs barred from connecting to Microsoft's cloud-based services, including hosted email (Exchange) and online storage (OneDrive for Business), after Oct. 13, 2020. New in Office 2019 Word – text-to-speech, improved inking & accessibility, focus mode, translator, Learning tools (captions & audio descriptions), @ Mentions PowerPoint – Morph transitions, Zoom, SVG, 3D model, play in-click sequence, 4k video, @ Mentions Excel – Power Query (Get & Transform) enhancements, Power Pivot included with all editions, new functions & connectors, publish to Power BI, AI-driven Excel Insights for chart suggestions, new charts, @ Mentions Excludes Co-Authoring, new Data Types like Stocks, and some other new features only available in Office 365 Outlook – @ Mentions, Office 365 Groups OneNote – OneNote for Windows 10 (Modern App included with Windows) has replaced OneNote desktop app (though OneNote 2016 will be available via Volume License Install tool) All Office apps – Ribbon customizations and roaming pencil case Microsoft Access - including the many updates we've seen recently such as: Modern Charts New Linked Table Manager Dark theme Big Int Salesforce & Dynamics connectors Other Recent Developments with Microsoft Access It's especially exciting to see all the new features, growing user base and communities, new integrations, and development team responsiveness seen with Microsoft Access of late. Inclusion on the Office templates page Which I hope will become permanent soon SQL Server Migration Assistant (SSMA) updates ODBC and OLE DB driver updates – for optimized use and new feature support for SQL Server, Azure SQL and other back-ends databases Power BI support (via On-Premises Data Gateway) Considering On-Premises Data Gateway is shared with PowerApps, hopefully that means we may see PowerApps support too in the future New & growing Access conferences and user communities: New Access Developers' Day in Amsterdam DevCon in Vienna, AEK in Germany, UKAUG in UK, PAUG in Portland, Access Day in Redmond, Access Madrid in Spain Presence at Microsoft Ignite and other conferences Access User Groups (AUG) webinars and local chapters (Chicago, Denver, Madrid, Hertfordshire, etc.) Access now included in most Office editions Included in nearly all (besides Online-only) editions Access in Office 365 Home, Personal, Business, Business Premium, ProPlus, E3, and E5 editions Access in Office 2016 Professional and ProPlus editions With MS Access having been added to most Office editions, presumably it will likewise be available with most Office 2019 editions now too. It's great to see these features available to Office 365 subscribers (or even sooner if opt-in for Insiders program) now being made available to others with Office 2019, and I look forward to the many more new advancements with Microsoft Access and Office to come. Links to More Info about Office 2019 You can find out more about Office 2019 with the following articles, FAQs and product pages: https://products.office.com/en-us/business/office-365-proplus?activetab=tabs%3aprimaryr4 https://support.microsoft.com/en-us/help/4133312/office-2019-commercial-for-windows-and-mac-frequently-asked-questions https://www.microsoft.com/en-us/microsoft-365/blog/2018/09/24/office-2019-is-now-available-for-windows-and-mac/ https://www.computerworld.com/article/3229906/software-productivity/office-2019-is-coming-heres-what-you-need-to-know.html https://www.theverge.com/2018/9/24/17896700/microsoft-office-2019-release-date-features https://www.zdnet.com/article/microsoft-starts-rolling-out-office-2019-for-windows-and-mac/ https://www.engadget.com/2018/09/24/microsoft-releases-office-2019/ https://venturebeat.com/2018/09/24/microsoft-launches-office-2019-for-windows-and-mac-promises-it-wont-be-the-last/ https://www.techspot.com/news/76598-microsoft-office-2019-launches-commercial-customers.html -- Dan Moorehead Founder & Chief Software Architect PowerAccess (https://www.PowerAccess.net "Empower Microsoft Access – with new Tools | VBA Framework | PowerGit | Power Query-like PowerSQL | VSTO-like .NET API | CodeGen | Excel Formulas & Functions | Consulting | Excel ➜ Access ➜ SQL Conversion Tools"
Username from Office-Account with VBA (Access2016)?
I want to read the username of the current logged in Office account in MS Access 2016 with VBA (not Windows or network username). The logged in user appears indeed in the Office2016 applications respectively in the title bar at the top right. Environ (), etc. unfortunately does not help. As some users have different office accounts (partly for business and / or private) and change between these (eg due to access to your own OneDrive files). I would like the Office-username (account-name) for the user-specific representation of information in forms, queries, etc. I Have already found that the previously registered users will be added to the registry and are thus read, but which of these is the currently logged on? Thanks for your help
Microsoft Access now included in Office 365 Business and Business Premium with new enhancements
As businesses of all sizes come to realize the value of data analytics to inform decision-making, many are also discovering the need for database solutions like Microsoft Access to help collect, organize and share data, as well as create reports that deliver valuable insights. That’s why we’re pleased to announce today that Microsoft Access is now included in the Office 365 Business and Business Premium plans—designed to meet the needs of small and mid-size businesses. Learn more on the blog.Netherlands Access Developers Day (NADD) is Around the Corner (Sep. 14th) - Register Now!!!
If you are looking for opportunities to connect with Access developers and customers in Europe, learn from world known Access experts, and get up to speed with the latest Access technology - the NADD is the right place to be. This event has been noted as an incredibly successful and informative event that capitalizes on the journey of Access and the amount that the product has to offer. This year, it will be held on Saturday, September 14th in the greater Amsterdam area. There will be many presentations and demos by the Access Team and by several of our Access MVPs, and we will host an open Q&A and provide some insight into new and improved features. Learn more about this international conference (content delivered in English) and register here! https://www.sys.nl/netherlands-access-developer-day-2019/ See you there!
Access 365 2302 16130.20218 Subform with sourceobject query has interesting glitch
I've got a form with a subform that has a stored query as a source object. When I cursor over the data, I get what appears to be some of the query design elements: Here is the "show" checkbox https://i.imgur.com/rTniQct.png Crosstab pulldown: https://i.imgur.com/5FUwo1w.png Total pulldown: https://i.imgur.com/vJUR0vx.png I thought maybe it was some form corruption so I tried making a new form with a subform referencing the same stored query and got the same result? It also does this with stored queries that are NOT crosstabs (like the above example) Here's a short video of the glitch in action: https://www.screencast.com/t/dfLDfEE1B I've tried setting the subform control to locked = yes/enabled = no to no avail. Here's a link to a basic 1 table / 1 query /1 form mdb that reproduces the glitch: https://drive.google.com/file/d/1VktXsLHAoeqeDL67eTukhYYVjVjRpF3O/view?usp=sharing Another note: using the runtime simulation flag from the command line, the subform now shows NO data but you can still click in / around to get the query designer elements.
