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: Office 365 vs. 2019 Editions Office 2019 Commercial FAQ Microsoft's Office 2019 Announcement Office 2019 and Discontinuing of Office 2016 The Verge release article ZDNet release article Endgadget release article VentureBeat release article TechSpot release article -- Dan Moorehead Founder & Chief Software Architect PowerAccess (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"
Microsoft access database engine 2016 download 64 bit rendering Access unopenable
Hello everyone, I have a problem where I downloaded Microsoft access database engine 2016 64 bit which rendered Microsoft Access unopenable. I have the slow Insider build. Does anyone have a solution? The download is necessary for an operation in another program.Microsoft Access Version Comparison Matrix
Microsoft Access debuted in 1992 and recently celebrated its 25th Anniversary! Over the decades, Microsoft Access evolved with a large number of enhancements, database formats, and discontinued features. It's hard to remember all the changes. We created a page that shows the different Microsoft Access versions and changes in an easy to understand comparison matrix. Microsoft Access Version Features and Differences Comparison Matrix See when versions were released, their latest service packs, database formats, linked tables, field types, security features, Windows Operating Systems, and many other features both new and old. Hope this helps. Let us know if we missed anything.
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
Import from Access to Excel returns empty table.
Hello. When linking an access query to excel using method Data>Get Data> From Database> From Microsoft Access Database, the table in Excel returns the column headers but no other data. When I got to Access to check the table, everything there seems fine. Any suggestions? I'm using Access & Excel 2016.
Drag and Drop a file within a form in Microsoft Access 2016 on Windows 10 problem
I have an Access Database that was designed and working fine in Windows 7 with Access 2010. It has a form that allows you to drag a file from the desktop (such as a pdf file) and load the path on the form for further action in order to transport the file over to a folder on a share drive. In Windows 10 and Access 2016, it no longer works. Has something changed with an API reference? I am attaching the code below. I appreciate your input and suggestions on this. Thanks. KT Option Compare Database Option Explicit 'basDragDrop '2011-09 jl Private Declare Function SetWindowLong _ Lib "user32" Alias "SetWindowLongA" _ (ByVal hWnd As Long, _ ByVal nIndex As Long, _ ByVal dwNewLong As Long _ ) As Long Private Declare Function GetWindowLong _ Lib "user32" Alias "GetWindowLongA" _ (ByVal hWnd As Long, _ ByVal nIndex As Long _ ) As Long Private Declare Sub DragAcceptFiles _ Lib "shell32.dll" _ (ByVal hWnd As Long, _ ByVal fAccept As Long) Private Declare Sub DragFinish _ Lib "shell32.dll" _ (ByVal hDrop As Long) Private Declare Function DragQueryFile _ Lib "shell32.dll" Alias "DragQueryFileA" _ (ByVal hDrop As Long, _ ByVal iFile As Long, _ ByVal lpszFile As String, _ ByVal cch As Long _ ) As Long Private Declare Function CallWindowProc _ Lib "user32" Alias "CallWindowProcA" _ (ByVal lpPrevWndFunc As Long, _ ByVal hWnd As Long, _ ByVal msg As Long, _ ByVal wparam As Long, _ ByVal lparam As Long _ ) As Long Const GWL_WNDPROC As Long = -4 Const GWL_EXSTYLE = -20 Const WM_DROPFILES = &H233 Const WS_EX_ACCEPTFILES = &H10 Private currFrm As Access.Form 'reference to the Form currently 'hooked to the callback. This 'is required to pass the dropped 'files to the form Private currHwndFrm As Long 'handle to the currently hooked form 'this is used to verify there isn't 'two forms hooked at the same time '(for example overlapping controls 'where the mouse jumps from one 'to the other) Private prevWndProc As Long 'handle to the window's previous 'WindowProc. This is only set while 'currHwndFrm is valid Private hookOn As Boolean Public Function DragDropInitForm(hWndFrm As Long) 'inits the form for drag/drop Dim lExStyle As Long 'get the current extended window style lExStyle = GetWindowLong(hWndFrm, GWL_EXSTYLE) 'add the flag for accepting dragged files lExStyle = lExStyle Or WS_EX_ACCEPTFILES 'set the new extended window style SetWindowLong hWndFrm, GWL_EXSTYLE, lExStyle 'register the form for drag/drop acceptance DragAcceptFiles hWndFrm, True End Function Public Function DragDropSetHook(hookOn As Boolean, hWndFrm As Long) 'toggles the hook on or off If hookOn Then dragDropHookOn hWndFrm 'Debug.Print "HookOn" Else dragDropHookOff 'Debug.Print "HookOff" End If End Function Public Function DragDropCallback( _ ByVal hWnd As Long, _ ByVal msg As Long, _ ByVal wparam As Long, _ ByVal lparam As Long _ ) As Long 'callback for drag/drops 'as in all callbacks, we're screwed if there's an error 'and need to be absolutely certain this procedure will 'exit On Error Resume Next 'We want to turn this hook off as soon as possible after 'the files are dropped, otherwise it clogs up the rest 'of the project operations. It just so happens that the 'MouseMove event for a control accepting the dropped files 'fires exactly one time when the files are physically 'dropped on the form - that one time is where this hook 'is turned on, so it's almost a safe bet that we can 'turn this directly back off as soon as it's called. ' 'If you experience occasional times where you drop files 'but they do not register, set the DDH_MAXCALLS constant 'to a higher number. In Access 2010 in particular this 'number seems to want to be set around 50 or so for 'it to work every time. You might need to go higher Const DDH_MAXCALLS = 150 Static intCallCount As Integer If msg <> WM_DROPFILES Then 'the hWnd parameter passed to this function by the OS is 'the handle to the form that was hooked. If the message 'is not for a file drop, we'll send the message to that 'form's standard message procedure CallWindowProc ByVal prevWndProc, _ ByVal hWnd, _ ByVal msg, _ ByVal wparam, _ ByVal lparam Else 'we have a file drop, handle that dragDropQueryFiles wparam End If 'check the callcount and unhook if required intCallCount = intCallCount + 1 If intCallCount >= DDH_MAXCALLS Then intCallCount = 0 DragDropSetHook False, hWnd End If End Function Private Sub dragDropQueryFiles(hDrop As Long) 'passes a semicolon delimited list of the dropped 'files to the currFrm.DragDropFiles() sub Const MAX_PATH = 255 Dim ret As String 'function return Dim s As String 'temp/various Dim Icount As Integer 'count of files dropped Dim iPathLen As Integer 'length of the current path Dim I As Integer 'temp/various 'get the count of files dropped s = String(MAX_PATH, 0) Icount = DragQueryFile(hDrop, &HFFFFFFFF, s, Len(s)) 'iterate the filecount and build the return For I = 0 To Icount - 1 s = String(MAX_PATH, 0) iPathLen = DragQueryFile(hDrop, I, s, MAX_PATH) ret = ret & ";" & Left(s, iPathLen) Next I DragFinish hDrop currFrm.DragDropFiles Mid(ret, 2) End Sub Private Function dragDropHookOn(hWndFrm As Long) 'turns the callback on If hookOn Then Exit Function 'set the current form and handle for later use currHwndFrm = hWndFrm Set currFrm = dragDropGetFrmFromHWnd(hWndFrm) 'use SetWindowLong to set the new callback address 'and return the previous callback address to prevWndProc prevWndProc = SetWindowLong(hWndFrm, GWL_WNDPROC, AddressOf DragDropCallback) hookOn = True End Function Private Function dragDropHookOff() 'turns the callback off 'set the window's callback address to it's previous value SetWindowLong currHwndFrm, GWL_WNDPROC, prevWndProc 'clear the window and callback settings until next callback init prevWndProc = 0 currHwndFrm = 0 Set currFrm = Nothing hookOn = False End Function Private Function dragDropGetFrmFromHWnd(hWnd As Long) As Access.Form 'retrieves a form reference from the form's handle 'this reference is later used to call the form's procedure and pass 'it the dropped file list Dim frm As Access.Form For Each frm In Access.Forms If frm.hWnd = hWnd Then Exit For Next frm Set dragDropGetFrmFromHWnd = frm End Function
