Document Generation using Word Content Controls – Back in Business
This article shows how to create a complex structured Word 2019 Document from a template using XML as a data source. I wrote this to apply to Word 2013 / 2016’s Repeating Content Controls. I abandoned this article in 2017 when I found that the results were not consistent when the structure of the XML file became more complicated, i.e. […]
Export XML Data from Microsoft Access – Part 3 – Matching a schema
Previously Export XML Data from Microsoft Access – Part 1 – Tricks and Traps Export XML Data from Microsoft Access – Part 2 – using VBA In the previous two parts of this series we found it easy to Export XML data from Microsoft Access either using the UI or VBA, but that the schema (or structure) of the output […]
Export XML Data from Microsoft Access – Part 2 – using VBA
This follows on from a previous blog Export XML Data from Microsoft Access – Tips and Tricks, about how to export XML data from Microsoft Access using the interactive tools in Access. The example used the Northwind database to export the Order information for one Customer, so that they could use this XML document for merging with Microsoft Word using […]
Export XML Data from Microsoft Access – Part 1 – Tricks and Traps
Ever since Microsoft Access 2003, Access has had the inbuilt ability to easily export data as XML, and the schema of the underlying table or query to an XSD.. Even before this it was possible to write XML from Access by using VBA to write it out as a text file, or by setting a reference to the MSXML or […]
Document Generation with Microsoft Word and Microsoft Access
Background Back in the late 80’s early 90’s I wrote some software called Rendezvous and sold it as shareware. I wrote it in Clipper (a dBase III compiler). It’s purpose was generally for lead generation and outbound telemarketing. Telemarketing using databases was relatively new at the time. For general lead processing one of the better strategies was to call the […]
Expanded MouseOver and MouseOut events
In the previous post Simple Microsoft Access MouseOver and MouseOut Events the only type of control monitored was the CommandButton. This expands on the same idea but extends this to the major form controls. It still does not handle where controls are close to each other or overlapped, as the MouseOut event will only be fired when then the mouse […]
Simple Microsoft Access MouseOver and MouseOut Custom Events
Microsoft Access supports mouse events for a number of control types. The mouse events Access supports are MouseDown, MouseUp, and MouseMove. When the mouse is moved over a control the MouseMove event is fired, not just once, but potentially for every pixel, depending on the speed of the mouse movement. There is not a specific event for when the mouse […]