AccessBlog.net
News, links, downloads, tips and tricks on Microsoft Access and related
| About Me | Search |
Tuesday, March 28, 2017
Friday, January 20, 2017
Wednesday, November 09, 2016
MS Access Right-Click Context Menu Creator
Context Menu Creator - useful tool to create Windows Explorer file context menu like Compact, Decompile, Open Exclusively for desired Access file exnetsions.
Labels: Access
Wednesday, June 15, 2016
Access WizHook library
Plus I saved copy here
One more link, documented by Thomas Möller, Access MVP
Labels: Access
Wednesday, May 11, 2016
Access SQL Editor
Access SQL Editor – quite useful add-in for Microsoft Access (where we still have such a basic SQL editor, no changes since version 1,0!), allows you to save formatted SQL queries in a Microsoft Access (Jet/ACE) database, with syntax highlighting and comments.
Labels: Access
Tuesday, April 26, 2016
Meet SQL Server 2016
SQL Server 2016 Release Candidate 3 was released recently, amoung other new features - temporal tables: a system-versioned table allows you to query updated and deleted data, while a normal table can only return the current data.
These are the most common use cases for temporal tables:
- Audit. With temporal tables you can find out what values a specific entity has had over its entire lifetime.
- Slowly changing dimensions. A system-versioned table exactly behaves like a dimension with type 2 changing behavior for all of its columns.
- Repair record-level corruptions. Think of it as a sort of back-up mechanism on a single table. Accidentally deleted a record? Retrieve it from the history table and insert it back into the main table
See Introduction to SQL Server 2016 Temporal Tables for more info
Saturday, February 20, 2016
Add-ins for Access web apps
Create add-ins for Access web apps – step through the process
Latest Microsoft Office Developer Tools for Visual Studio 2015 - link to the latest Microsoft Office Developer Tools for Visual Studio 2015
JavaScript API for Office
Office UI Fabric
Office 365: Bind and manipulate data in a SharePoint Access app
Create JavaScript web apps using CORS to access Office 365 APIs
Have more links? Write me in comments
Labels: AWA



