sharepoint

53 Topics

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"
Solved
DanMoorehead_PowerWeb5AI
Sep 24, 2018 Place Access
412KViews
8likes
21Comments
Future of Microsoft Access: PowerApps｜CDS｜VSTO｜VBA｜Flow｜JS｜VS｜.NET｜Graph Cloud｜Mobile｜Web｜Developers
Access & Office Development Roadmap & Suggestions In addition to summing up recent Access updates & resources (including those from Access), I've compiled some suggestions & questions for the Access & Office Dev Platform teams (ranging from PowerApps & Common Data Service integration to VSTO Add-in dev, VBA & VBE) here. I've also recapped the recent Microsoft reorg changes along with thoughts on potential implications for Access & Office. Also, if at all possible, any glimpse the Microsoft Access and Office Developer Platform (VBA, VBE IDE, Office.js, VSTO) teams could provide us with into what they are considering (even if not confirmed yet) as possible future enhancements, fixes and data connectors for Access and improvements for Access developers (automation/macros/add-in development) for Access 2019 / Office 2019 (http://www.codekabinett.com/rdumps.php?Lang=2&targetDoc=office-access-2019-news) onward would be greatly appreciated. Promising Trend of Access Updates vs. Cloud-first Focus & Dropped Web Support Considering, on one hand, the number of promising recent Access updates (summarized below, per Access Day) and, on the other, the deprecation of Access Web Apps (AWA & Access Services for Microsoft-hosted SharePoint Online going read-only by April 2 '18) and Microsoft's recent Cloud-first focus (PowerApps, Common Data Service, Azure) and Cloud vs. UX reorg. shakeup. Microsoft Reorganization (Cloud vs UX Shakeup) Implications Also, I'm wondering if anyone has any thoughts on possible implications of the just-announced http://www.zdnet.com/article/heres-how-and-why-microsoft-is-splitting-up-windows-in-its-latest-reorg/ on Access, Office development and Microsoft Office / Office 365 in general. Specifically, as I will detail in my next post, Microsoft has combined their 4 groups into just two groups, essentially splitting by Cloud vs. non-Cloud - a "Cloud & AI" group, including Azure, PowerApps, Power BI, Dev Tools/APIs, among other things vs. a "Devices & User Experience" group, including Office, Windows, Surface & Mobile. Recent Access Features & Updates I'd like to start off by recapping all the recent advancements we've seen with Microsoft Access, at Access Day and beyond. Considering all the http://www.fmsinc.com/microsoftaccess/history/features.htm and toying with removal of Access from most Office editions, it's really great to see that Microsoft ended up (after the user backlash) https://twitter.com/PowerAccessSQL/status/974477100521525248 instead! More than that, its really incredible to see all the new Access updates, such as new Data Connectors (Microsoft Dynamics & Salesforce), https://blogs.office.com/en-us/2017/03/06/new-in-access-2016-large-number-bigint-support/ support, an upcoming https://blogs.office.com/en-us/2016/09/07/back-by-popular-demand-dbase-file-support-in-access/, https://support.office.com/en-us/article/featured-access-templates-e14f25e4-78b6-41de-8278-1afcfc91a9cb?ui=en-US&rs=en-US&ad=US (experimentally) and 32-bit SSMA release (with the SQL Server Migration Assistant for Access previously only usable with uncommon 64-bit Office installs). Also, I'm glad to see the Access Accessibility Updates (Screen reader, F6 navigation, high contrast, etc.), which even as I understand, helped lead to Microsoft receiving the https://blogs.microsoft.com/firehose/2017/09/07/microsoft-recognized-for-leadership-in-bringing-inclusion-to-product-design/ for tech enabling the over 1 Billion across the world with disabilities. Congrats to the Access, Office and Accessibility teams on that achievement! Access Team's Support & Updates I also very much appreciate the new content and support from the Access team. For those not familiar with all of it, that includes new resources under and https://support.office.com/en-us/access with https://developer.microsoft.com/en-us/access/docs and https://support.office.com/en-us/article/access-video-training-a5ffb1ef-4cc4-4d79-a862-e2dda6ef38e6, as well as https://support.office.com/en-us/article/featured-access-templates-e14f25e4-78b6-41de-8278-1afcfc91a9cb?ui=en-US&rs=en-US&ad=US and the attention the Access dev team is providing to https://access.uservoice.com/ and https://officespdev.uservoice.com/, as well as all the activity in the the new Access blog and Access forums here. Upcoming Features for Access and Access Day Revelations I was exciting hearing about the upcoming support for New Chart types and R2 update of https://www.microsoft.com/en-us/download/details.aspx?id=54920, all covered at http://jstreettech.com/RedmondWA2018Schedule.aspx by Access Program Manager Michal_Bar, as seen in her https://www.facebook.com/JStreetTech/videos/1871973549481976/ (thanks to ArmenS and his post on the new charts). Access Dropped from Visual Studio Tools for Office (VSTO) for .NET Add-in Development However, there are a few things long-missing or rarely updated which I would love to see to simplify life for Access developers and enable better integration with or taking advantage of the latest, Cloud-focused Microsoft product and developer tool/API advancements. For example, I, and many others https://www.linkedin.com/feed/update/urn:li:activity:6331932689293279232/, would really like to see at least Access supported with https://msdn.microsoft.com/en-us/library/ms268878.aspx for add-in development again, as well as modernizing development tools/APIs for macros/automation. Specifically, it would be great if at some point in the future we could see updates to the VBE / VBA IDE (eg. adding tabbed documents, both forward/backward edit navigation, etc. as missing most VS updates since forked from VS around VB6), updates to VBA language (which hasn't seen much in the way of updates since VB6 it was based on), Visual Studio use for VBA (for macro coding, debugging & edit-and-continue), Microsoft Flow automation (eg. using On-premises Data Gateway or VPN connection or OneDrive), Office.js API, and/or VB.NET / C# / .NET for macro coding. VBE (VBA IDE) Issues There are also long-standing issues with VBE (VBA IDE) like it being unable to handle multiple monitors with different resolutions without ghosting when resizing tool panels. And missing modern text editor features (let alone modern Visual Studio features) like Tabbed Documents, Forward & Backwards edit navigation/history, etc. We ended up seeing and dealing with this for example (in addition to encountering it all the time myself) even during the presentations at Access Day. Automation (Macro & Add-in Development) API Limitations For Add-in developers and VBA Macro/Automation developers, Access could really benefit IMO from adding events, like for OnAppExit, OnSave globally and for each object/window, access to multiple objects selected in Navigation Sidebar, defining hotkeys via code (vs AutoKeys), extend the Nav sidebar context menu - to name a few. I will likely post a compiled list of suggestions later on regarding Access and VBA/VBE Automation APIs. Documentation & Samples Missing However, developer docs and content is completely missing for Access from https://developer.microsoft.com/en-us/office/gallery/?filterBy=Samples,Access and https://dev.office.com/training, and https://products.office.com/en-US/business/office-365-roadmap?filters=access (which only has 3 entries for Access: Salesforce + BigInt as completed, and Dynamics 365 connector shown as still WIP/Still Rolling Out) as well as https://docs.microsoft.com/en-us/office/dev/add-ins/, https://msdn.microsoft.com/en-us/library/23cw517s.aspx and https://docs.microsoft.com/en-us/visualstudio/ide/creating-project-and-item-templates. Content missing from those last three places is likely due to Access being dropped entirely from VSTO for some reason, but even then there are other ways (eg. COM APIs, 3rd party wrappers, etc.) that could at least be mentioned there, or even include older VSTO docs. People are developing add-ins with Access, regardless of it being dropped from VSTO, but there is no documentation on how to do that. Making the Access Templates Experiment Permanent Also, Access Templates should definitely be kept permanently and shown to everyone all the time. As Michal had pointed out, Access Templates end up being shown randomly (for A/B testing) just for some users on https://templates.office.com/. However, after refreshing 2 dozen times, trying with a dozen Incognito sessions across several dozen sessions it took dozens of attempts to finally see it, so I'm not sure it's shown as often may be though. Cloud Data Connectors (Common Data Service and Graph) like Excel & other Office Apps Similarly, I would love to see https://docs.microsoft.com/en-us/common-data-service/ and https://developer.microsoft.com/en-us/graph support (and maybe direct access to Power BI-embedded data) in Microsoft Access. As Juan Soto had pointed out, Excel and other Office and MS apps provide Common Data Service support, with just Microsoft Access as the one missing out. Access Web App "Replacement" PowerApps Supports Everything Except Access For other improvements beyond Access/Excel/Office Macros and Developer Tools/API, I'd really think it valuable for https://powerapps.microsoft.com/en-us/, https://flow.microsoft.com/en-us/, and https://powerbi.microsoft.com/en-us/ Online (beyond just Desktop version, for Service / Premium / Report Server / Mobile / Gateway, and without import Desktop to Service hack) to provide direct support for Access databases. On-premises Data Gateway: Possibility for Using Access from PowerApps & Power BI for Web & Mobile It's frustrating not even being able to setup the https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem (installed on local PC for "File System" access, shared by PowerApps and Power BI) to support Access databases in PowerApps - just Excel workbooks. Concerns Regarding Microsoft Priorities for Azure & PowerApps vs. Access However, considering how even Access Services (for SharePoint-Access integration via Access Web Apps (AWA) as well as earlier Access Web Databases) being deprecated and going read-only (April 1, 2018), I wonder how likely that might be that we get further Cloud/Web/Mobile features. Considering this and how Microsoft attempted to even remove Access from most Office editions recently, as well as their Cloud-first focus, it's a bit concerning. It seems like with Access being included in Office there is a lot less revenue to be made from it compared to billing monthly (and by usage) with PowerApps, Power BI, Azure, etc. I can understand Microsoft's business priorities there, but, considering Access is often used for prototyping databases for SQL Server and Azure SQL, as well as quick, end-user-editable front-ends for them, I think it would make more sense IMO to expand Access' integration with Azure and Cloud Services versus trying to drop it from Office editions and replace with PowerApps which can't even connect to Access (pushing use of Excel spreadsheets for data storage and queries instead, for file system connectors). There is little-to-no support for even connecting to Access Databases from PowerApps and Power BI and even OneDrive/Dropbox deployment not being feasible (unlike Excel, now with its real-time multi-user collaborative desktop editing enabled when deployed that way, let alone Excel Online deployment). Remaining Deployment Options: VPN File Shares & Remote Access (RDP, RemoteApps, Citrix) Considering this, the we are limited for multi-user deployment to Network Shares over VPN (not feasible if want clients or customers to be able to use, or access from home for many) and Remote Desktop (RDP - though RemoteApp is a pretty good option), or Citrix & other RDP-like options (now that Azure RemoteApp hosting is deprecated). Questions for Access & Office Dev Platform Teams To sum up, my primary questions (and suggestions) for the Access development team are the following: Is there any chance we may see Microsoft Access integration with PowerApps, Common Data Service, Azure, Microsoft Graph, Power BI Online, SharePoint, Office Online, On-premises Data Gateway, OneDrive, Dropbox and/or Microsoft Flow? Any other possibilities to simplify Web, Mobile, Cloud Drive (eg. making OneDrive feasible to use, like with Excel for multi-users), or otherwise simplifying Multi-User use and deployment for Microsoft Access? Is there any chance we could get Access added back to Visual Studio Tools for Office (VSTO) for officially supported and documented (complete with Visual Studio project templates) for .NET Add-in development for Access, like with Excel and other office apps? Any possibility of updates to VBA, VBE IDE, or support for Visual Studio for VBA or C#/VB.NET for macro coding, or JavaScript (eg. Office.js), or even Microsoft Flow (eg. via Gateway, VPN, or OneDrive) for automation?
Solved
DanMoorehead_PowerWeb5AI
Mar 30, 2018 Place Access
27KViews
6likes
6Comments
Access web apps will be read only on April 1st, please plan accordingly
A year ago Microsoft announced that Access Service in SharePoint will be discontinued. We hope you've had a chance to migrate your app, but if you haven't here are some of the platforms you can recreate your application into: PowerApps - Web App Microsoft Access - a "regular" Access file that is not a web app Another web technology such as php or .Net Other platforms Which technology you pick will depend on: Your IT department's guidelines on applications, some may prefer .Net or don't have any preference Your budget to re-architect the solution, some platforms, such as PowerApps, are easy to develop but are not as powerful, others such as .net are more powerful but much more expensive to develop, with Access in between the two Your time constraints: Given the short period between now and April 1st, you may need to put together an Access application instead of .Net just because it's faster. What you should absolutely not do is wait, the time to act is now if you do have a mission critical access web application.
Solved
Juan Soto
Mar 14, 2018 Place Access
4.4KViews
3likes
13Comments
Linking Data From Excel to Access to Sharepoint List
Hi - I retrieve data in Excel. I am trying to create a link from this data to a Sharepoint List so that the data can be shared in a separate template that includes that data as a Power Query. If I export from Excel to Sharepoint, I do not maintain a "live" refresh of the data (when the data is updated in Excel it is not reflected in Sharepoint list). I am now trying to link the data from Excel to Access and from there link it to Sharepoint. I am able to link the Excel to Access and see changes reflected; I am able to link Access to Sharepoint and see changes reflected. But I am unable to see changes reflected in Sharepoint that are made in the original Excel file. Any thoughts/suggestions/work-arounds? *Note, I am currently using Office 2013 but will be moving to 365 in the next month!
mkmeach89
Jun 08, 2019 Place Access
1.9KViews
1like
2Comments
I can sense a signal of life in Access Web Apps
Hi. From an AWB App, online, if you click the gear botton (top right) , there is a new command "Export to SharePoint Lists" this creates a subside with the name as in App name, creates tables with relashionships as in AWA App, and copies (i think copies) the data. this has been the first signal of life of AWA development team since years. i wish this is serious and wish see linking not copying to sharepoint lists, plus tens of other new fearures in AWA.
Deleted
Mar 28, 2017 Place Access
2.2KViews
1like
5Comments
Patient Tracker and Package Tracker
Hi, I have two excel sheets one in which patient attendance is tracked with which therapist has been attended. Another sheet that says the type of package that the patients has bought. Every day I need to calculate the revenue by each Therapist. I have attached both the sheets, to show the type of data that is being generated from the system. From the software that we use we can generate the patient attendance tracker in excel (csv format). I would like to know can MS Access help me. The attendance sheet needs to be generated at the end of the day every day and needs to uploaded to MS Access, how will I be able to do that Patient Attendance Tracker Patient Name Patient ID Therapist Department Date Shyam Hani 153 Ryaan Occupational Therapy 02/10/2024 Shyam Hani 153 Ryaan Occupational Therapy 04/09/2024 Shyam Hani 153 Ryaan Occupational Therapy 06/09/2024 Shyam Hani 153 Sanju Speech Therapy 02/10/2024 Shyam Hani 153 Sanju Speech Therapy 04/09/2024 Shyam Hani 153 Sanju Speech Therapy 05/10/2024 Shyam Hani 153 Sanju Speech Therapy 06/09/2024 Shyam Hani 153 Sanju Speech Therapy 07/09/2024 Meera Hasan 152 Sanju Speech Therapy 09/10/2024 Meera Hasan 152 Sanju Speech Therapy 09/10/2024 Meera Hasan 152 Sanju Speech Therapy 10/08/2024 Meera Hasan 152 Sanju Speech Therapy 11/09/2024 Meera Hasan 152 Sanju Speech Therapy 11/09/2024 Meera Hasan 152 Sanju Speech Therapy 11/10/2024 Meera Hasan 152 Sanju Speech Therapy 11/10/2024 Meera Hasan 152 Sanju Speech Therapy 12/10/2024 Dev Mani 112 Sanju Occupational Therapy 01/10/2024 Dev Mani 112 Sanju Occupational Therapy 02/10/2024 Dev Mani 112 Sanju Occupational Therapy 04/10/2024 Dev Mani 112 Sanju Occupational Therapy 08/10/2024 Dev Mani 112 Sanju Occupational Therapy 09/10/2024 Dev Mani 112 Sanju Occupational Therapy 10/09/2024 Dev Mani 112 Sanju Occupational Therapy 10/10/2024 Dev Mani 112 Ryaan Occupational Therapy 11/09/2024 Dev Mani 112 Ryaan Occupational Therapy 11/10/2024 Dev Mani 112 Ryaan Occupational Therapy 12/09/2024 Dev Mani 112 Ryaan Occupational Therapy 01/10/2024 Dev Mani 112 Ryaan Occupational Therapy 04/10/2024 Dev Mani 112 Ryaan Occupational Therapy 08/10/2024 Dev Mani 112 Ryaan Occupational Therapy 10/10/2024 Patient Price Tracker Patient Name Therapist Patient ID Package From Package To Package Price Package Shyam Hani Sanju 153 Wednesday, 2 October 2024 Wednesday, 4 September 2024 100 Speech Therapy Shyam Hani Ryaan 153 Wednesday, 2 October 2024 0 Occupational Therapy Meera Hasan Sanju 152 Wednesday, 9 October 2024 Saturday, 12 October 2024 200 Occupational Therapy Dev Mani Sanju 112 Tuesday, 1 October 2024 Tuesday, 8 October 2024 300 Occupational Therapy Dev Mani Ryaan 112 Saturday, 27 July 2024 Tuesday, 27 August 2024 400 Occupational Therapy
team280
Oct 25, 2024 Place Access
557Views
1like
8Comments
Access Europe meeting on Wed 6 Sept - Database Analyzer and other tools
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please check https://www.worldtimebuddy.com/ In this month's session, I will be demonstrating my new Database Analyzer Pro application. The free evaluation version is now available for download from the above link on my website If time permits, I will also be discussing a number of related Access examples and code samples such as: • the use of progress bars • creating a table of contents in Access reports • the undocumented SaveAsText/LoadFromText features • changing query views using command bars code For more details about this session, see: https://accessusergroups.org/europe/event/access-europe-2023-09-06/ or https://isladogs.co.uk/aeu-19/ The meeting will again be held on Zoom. When the time comes, you can connect using: Join Zoom Meeting. If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210 For more connection options, please see the AccessUserGroups.org web page for this event All sessions are recorded and later uploaded to the Access User Groups channel on YouTube I hope you will join us for this month's session. As always, the session will be recorded and the video uploaded to YouTube after the event NOTE: I regret that the planned presentation on Better Access Charts by Thomas Moller originally scheduled for Wed 6 Sept has been postponed until further notice.
isladogs
Sep 02, 2023 Place Access
951Views
1like
2Comments